Is it possible to have two orders for the same customer? O No, viðlates entity Integrity constraint O No, violates key constraint. O No, violates referential integrity constraint. O Yes. O No, violates domain constraints. QUESTION 8 Consider the following relational database schema. Book (BookNo, BookTitle, BookType) Orders (OrderNo, BookNo, CustomeriD, Price) Write SQL Query to Retrieve the list of customers' ID who have made at least one order for a book of type "Science", but never ordered books of type "Novel".

Is it possible to have two orders for the same customer? O No, viðlates entity Integrity constraint O No, violates key constraint. O No, violates referential integrity constraint. O Yes. O No, violates domain constraints. QUESTION 8 Consider the following relational database schema. Book (BookNo, BookTitle, BookType) Orders (OrderNo, BookNo, CustomeriD, Price) Write SQL Query to Retrieve the list of customers' ID who have made at least one order for a book of type "Science", but never ordered books of type "Novel".

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

7. Question Comp
Consider the following database Scherpa for Car Ownership Database. In the database, we store information about cars and their owners. A car is owned by one owner, but an owner mayown many cars. Car (No, model, year, OwnerlD) Owner (ID, CPR, Name, address,Tel) Write SQL statements to: 1. List ID and name of all customers living in 'Bahrain'. 2. Delete all cars records from Car with unknown owner.
Consider the following relational schemaemployee (ename, street, city)works (ename, cname, salary, jdate)company (cname, city)manages (ename, mname)Write down the following queries in SQL 1. Find the names of all employees who earn more than every employee of Square Pharma. 2. Give all managers in this database a 4 percent salary raise, unless the salary would be greaterthan Tk.100,000. In such cases, give only a 3 percent raise.
The following SQL for a Point of Sale database for a grocery store is not properly constructed. As result, when student attempts to populate the tables, it gives a foreign key constraint fail error. Modify the SQL so that it models the depicted schema and follows the following constraints: They is a one-to-many relationship between the salesdetails.SalesNumber andsales.SalesNumber fields.  There is a one-to-many relationship between the products.prodid and salesdetails.prodid fields. There is to be a delete constraint on the product.prodid field a record in the product table should not be allowed to be deleted if they exist a matching prodid in the salesdetails table. Primary and foreign keys should be implemented in the appropriate tables. Referential Integrity should be enforce at the database level, where appropriate for example, if a sales record is deleted all associated records in the saledetails table should be deleted as well, etc. CREATE TABLE `products` ( `number`…
Map each of theER diagrams given below to a relational database by specifying its SQL schema. Make sure you capture as many integrity constraints as possible and explicitly mention those that cannot by captured by the SQL schema (if any). Please provide simplified SQL schema and have it typed/ Please do not copy other answers from Chegg they are incorrect. I will upvote
The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined) CUSTOMER (CustID, FirstName, LastName, City, Phone, Email) INVOICE (InvoiceNumber, CustID, Date) INVOICE_ITEM(InvoiceNumber, ItemNumber, Quantity) ITEM (ItemNumber, ItemName, UnitPrice) When a customer makes a purchase, an invoice is created. The invoice may be for many items. For example, in a single purchase, a customer might buy 10 Back Scratchers, 4 Hair Removers and a Dog Lead. Provide relational algebra (NOT SQL) queries to find the following information. NOTE: You can use the symbols s, P, etc., or the words’ PROJECT’, ‘RESTRICT’ etc. as you prefer. You do not need to try to make efficient queries – just correct ones. Where you use a join, always show the join condition. List the dates on which Homer Griffin made purchases. List the first and last names of customers who have bought “Back Scratcher” or “Hair Remover” List the first…
Note: solve only if you can answer it correctly . Otherwise I will dislike the answer. Thank you!! Q. Indicate the changes you need to make to the design of the BITS database to support the following situation. There is no relationship between clients and consultants. When a client places an order (service request), it may be performed by any consultant. On the order, identify both the client placing the order and the consultant responsible for the order.
Question 20 Please fill in the blank correctly.
Consider the relational database of Figure 3.19. Give an expression in SQL foreach of the following: Modify the database so that the employee whose ID is '12345' now lives in “Newtown”.
DATABSE
14- Study the relational schema:EMP(ID, Name, DeptID)DEPT(DeptID, DName, Loc)Which of the following join conditions will correctly join the two tables? a. Emp.DeptID = Dept.DeptID b. Emp.Name = Dept.DName c. Emp.ID = Dept.DeptID d. Emp.ID = Dept.ID
Run the problem using Relational Algebra, below the problem I added the needed table. Use self join find the answer (4) Find the name (fname,lname) of the direct supervisor of “Mary Smith”. (“Mary Smith” is an employee). group: emplyeeemployee = {fname, lname, ssn,superssn, departnumber'Mary', 'Smith',111, 222, 11'Green', 'Marjorie',333, 222, 12'Gren', 'Cheryl',222, 777, 14}