Question 6 Inventory Database: Customers(custid, custName, address, phone, credit Limit) Orders(orderNo, order Date, totalAmount, custID) products(prodNo, prodName, unitPrice) Includes(onderNo, prodNo, orderedQantity). The primary keys are underlined. The referential integrity constraints are as follows: • the column custID of relation Orders that references table Customers, • the columns orderNo of relation Includes that references table orders, and • the column prodNo of relation Includes that references table Products. For the Inventory Database in the reference, write the SQL command to find the product numbers of all products ordered by John Smith on March 1, 2022. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BIUS Paragraph V Arial V I XQ 8 V 10pt Ev Ev A V 흥

Question 6 Inventory Database: Customers(custid, custName, address, phone, credit Limit) Orders(orderNo, order Date, totalAmount, custID) products(prodNo, prodName, unitPrice) Includes(onderNo, prodNo, orderedQantity). The primary keys are underlined. The referential integrity constraints are as follows: • the column custID of relation Orders that references table Customers, • the columns orderNo of relation Includes that references table orders, and • the column prodNo of relation Includes that references table Products. For the Inventory Database in the reference, write the SQL command to find the product numbers of all products ordered by John Smith on March 1, 2022. For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac). BIUS Paragraph V Arial V I XQ 8 V 10pt Ev Ev A V 흥

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

convert it to relations that are normalization
27. Which of the following is not a restriction for a table to be a relation? a. The cells of the table must contain a single value. b. All of the entries in any column must be of the same kind. c. The columns must be ordered. d. No two rows in a table may be identical.
Define the term referential integrity constraint. Give an example of a referential integrity constraint for the tables you created for question 1.8.
Create a view vLab3_xxx in the class database list the staff who have the highest salary in each of the branch city. You will need both Staff and Branch table. The output header should be (city, name, salary) where the name is "fname lname".