Question 11.Write the SQL statement that will implement the relational algebra expressions in thefollowing relational algebra expressionsO(discount_percent-30)(PRODUCTS)E RESULT1xproduct_id=product_idORDER_ITEMSRESULT2Morder_id=order_idORDERSRESULT3Mcustomer id=customer idCUSTOMERSRESULTIRESULT2RESULT3RESULT4RESULTE Tfirst_name last name,product_name(RESULT4)

Question 11. Write the SQL statement that will implement the relational algebra expressions in the following relational algebra expressions RESULTI E O(discount_percent=30 RESULTIproduct_id=product_idORDER_ITEMS - RESULT2Morder_id=order_idORDERS RESULT3Acustomer_id=customer_idCUSTOMERS Tfirst_name.last_name,product_name(RESULT4) »(PRODUCTS) RESULT2 RESULT3 RESULT4 RESULT

Question 11. Write the SQL statement that will implement the relational algebra expressions in the following relational algebra expressions RESULTI E O(discount_percent=30 RESULTIproduct_id=product_idORDER_ITEMS - RESULT2Morder_id=order_idORDERS RESULT3Acustomer_id=customer_idCUSTOMERS Tfirst_name.last_name,product_name(RESULT4) »(PRODUCTS) RESULT2 RESULT3 RESULT4 RESULT

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

//trying to make recursive SQL statement to get the days of the week , can you tell me what does not work in this query: WITH cte_number (counter, weekday) AS(SELECT 0, Datename(DW,0) UNION ALLSELECTcounter+1, Datename(DW, counter+1)FROM cte_numberwhere counter<6) select weekday from cte_number; //thanks for you assistance
8. Write a Relational Algebra expression to represent the following SQL statement: select building, room_number, section.course_id, title from section, time_slot, course where section.time_slot_id = time_slot.time_slot_id and section.course_id = course.course_id and building = 'Painter' and semester = 'Spring' and day = 'F';
True or False below: Given two relations named A and B, if we q-JOIN A and B, the maximum number of attributes in the result relation could be (the number of attributes of A) times(*) the number of attributes of B). * in an SQL SELECT statement means “all the tuples”. In relational algebra, Cartesian Product (X) can be implemented using the q-JOIN operator. Cartesian Product ISA q-JOIN where q-condition always evaluates to true. SQL is based on Predicate Calculus. A query in SQL always specifies what should be included in the query result.
Question 13 Given the following relation: Book (BookID, Author, ISBN, Title) Write a PL/SQL block of code that performs the following tasks: i. Read a Book id provided by user at run time and store it in a variable. ii. Fetch the Author and title of the book having the entered id and store them inside two variables iii. Display the fetched book author and title.
Write appropriate SQL DDL statements for declaring the database "Employee", assign admin privilege to user "AMAL" Write appropriate SQL DDL statements for declaring the table PERSONS. Specify all constraints: Field Null key PersonID No PRIMARY No LastName varchar(30) FirstName varchar(30) No Address varchar(50) YES City varchar(30) YES Type int
Given the following relation: Movie (MovieID, Title, Genre, Year) Write a PL/SQL block of code that performs the following tasks: Read a movie id provided by user at run time and store it in a variable. Fetch the Genre and title of the movie having the entered id and store them inside two variables Display the fetched movie Genre and title.
Quèstion 13 Given the following relation: Student (StudentID, studentName, StudentAddress, MobileNumber) Write a PL/SQL block of code that performs the following tasks: 1. Read a student id provided by user at run time and store it'h a variable. ii. Fetch the name and mobile number of the student having the entered id and store them inside two variables. ii. Display the fetched student name and mobile number. TTTT Paragraph Arial 3 (12pt) 品DOQ T T. J. O Mashups 曲 P 四HTML CS 直。
Given the following relation: Book (BookID, Author, ISBN, Title) Write a PL/SQL block of code that performs the following tasks: Read a Book id provided by user at run time and store it in a variable. Fetch the Author and title of the book having the entered id and store them inside two variables Display the fetched book author and title.
Question 13 Given the following relation: Movie (MovielID, Title, Genre, Year) Write a PL/SQL block of code that performs the following tasks: i Read a movie id provided by user at nun time and store it in a variable. i. Fetch the Genre and title of the movie having the entered id and store them inside two variables i Display the fetched movie Genre and title. TTTT Paragraph - Arial 3 (12pt) O f Mashups- HTHL ESS
Write the SQL statements using the university schema to perform the followingoperations: Delete all takes tuples corresponding to any section of any course withthe word “advanced” as a part of the title; ignore case when matching theword with the title.
(d) Write an SQL statement, using the inner join construct, that will, for the lecturer John Smith, list in alphabetical order the students taking any module which he teaches. (e) What information does the output from the following SQL query provide? SELECT Lecturer, COUNT(DISTINCT Student) FROM class INNER JOIN staff ON class.Module = staff.Module WHERE Grade < 40 GROUP BY Lecturer; (f) Write an SQL query which would obtain the following information: for each lecturer, what is the average grade obtained by students across all of the modules which they have taught?
Question 7 Writes a PL/SQL function that calculates the factorial of a number passed as a parameter. The Factorial of a number n is defined as - O! = 1 n! = n*(n-1)*(n-2)*(n-3)... 1 for n>0