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

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 15RQ

See similar textbooks

Similar questions

Write the SQL code that will change the PROJ_NUM to 14 for employees who were hired before January 1, 1994, and whose job code is at least 501. (You may assume that the table will be restored to its condition preceding this question.)
Given the following SQL statement, which statement is most accurate?SELECT customer# FROM customersJOIN orders USING(customer#)WHERE shipdate-orderdate IN(SELECT MAX(shipdate-orderdate) FROM ordersWHERE shipdate IS NULL);a. The SELECT statement fails and returns an Oracle error message.b. The outer query displays no rows in its results because the subquery passes a NULLvalue to the outer query.c. The customer number is displayed for customers whose orders haven’t yet shipped.d. The customer numbers of all customers who haven’t placed an order are displayed
Write an SQL statement that will insert an order in the orders table with the following data: cutomerID=3, orderDate = current date, shipAmount=20, taxAmount=23.56, shipDate=a week after current date, shipAddressID=3, cardType=2, cardNumber=4123123412341234, cardExpires=05/2024, billingAddressID=3 Write an SQL statement to delete all orders that are created between 2017-06-01 and 2017-06-07.
What happens if we don’t specify the WHERE clause in an SQL DELETE FROM statement? a) statement compilation causes a “Syntax error”, and the statement is not executed. b) all the tuples of the relaton are deleted. c) none of the tuples of the relation is deleted. d) all the tuples not satisfying the condition are deleted. e) none of the above. Which one(s) of the following is(are) procedural? a) Relational Algebra b) Relational Calculus c) Tuple Relational Calculus d) Domain Relational Calculus e) SQL f) (a) and (e) e) (b) and (e).
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 15 Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program. declare employeeRecord employee%TYPE; ename varchar2; begin fetch ename, salary inside employeeRecord from employee where enum = 'E8'; DBMS_OUTPUT.PUT_LINE(employee.ename||' '|| employee.Salary); end;
Consider the following schema of employees working at Carlson Fabrics Ltd (CFL) and write SQL statements for the queries.Employee(emp_id, emp_name, address, age, gender, designation, department, shift, salary, transport) iv. List all employees, whose name start with letter "B" and ends with "e". v. Set salary of all supervisors to Rs 35 000. vi. Display the designation of the employees, whose salary is betweeen 30000 and 40000. vii. Display details of employees, where salary is 35000 or age is greater than 30. viii. List name and department of employees, where age is greater than 45 order by salary.
a) Write SQL queries for the following. 1) Display details of those patients whose age is either 25 or 36 or 29 without using comparison operator.2) Display first name and last name of those doctors whose salary is less than or equal to 77,000 and greater than or equal to 50,000 using between operator.3) Display details of those doctors who neither belong to Isb nor Rwp nor Multan without using in and like operator.4) Display full name of doctors whose first name is other than Tania.5) Display first name of doctors whose first name contains any of vowels (a,e,i,o,u).6) Display names of those patients whose name’s second letter is neither ‘a’ nor ‘d’7) Display details of those male patients whose age is 25 or 36.8) Display details of those patients whose name contains less than 5 characters.9) Display first 4 doctors who are earning least salary.10) Display details of all patients in such a way that female patients are shown before male patients.11) Display the unique cities from doctor…
The following SQL query is for retrieving the supplier's number, name, and city. SELECT.supNo, S.supName, S.city FROM Suppliers S GROUP BY S.supNo; This is all the information given. Which section of this is illegal? A. S.supName, S.city in the SELECT clause. B. The GROUP BY clause should be removed. C. S.city in the SELECT clause D. S.supName in the SELECT clause
The following SQL query is for retrieving the name of artists whose songs with an average length of 2021's songs SELECT artistName FROM Songs WHERE releasedYear = '2021' AND length = AVG(length): Which section of the query is illegal? A. AVG(length) in the WHERE clause B. Length in the SELECT clause C. releasedYear in the WHERE clause D. artistName in the SELECT clause
(a) What SQL statement would you use to create the table ”staff”, including specifying the primary key? (b) What SQL statement would you use to find out how many lecturers there are in the School of Computing? (c) What SQL statement would you use to list the lecturers of the modules COMP1121 and COMP1211? (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?
Write SQL statements for following:Student( Enrno, name, courseId, emailId, cellno)Course(courseId, course_nm, duration)i) Add a column city in student table.ii) Find out list of students who have enrolled in “computer” course.iii) List name of all courses with their duration.iv) List name of all students start with „a‟.v) List email Id and cell no of all mechanical engineering students

SEE MORE QUESTIONS

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS