Question: Provide working SQL DDL statements for the following database schema and queries EXERCISE CUSTOMER, Type, Firstname, Lastname, Address, City) INVENTORY(TD, ItemName, Type, MadeInStore, SupplierName, DailyAverageSold,

Provide working SQL DDL statements for the following database schema and queries EXERCISE CUSTOMER, Type, Firstname, Lastname, Address, City) INVENTORY(TD, ItemName, Type, MadeInStore, SupplierName, DailyAverageSold, Price) ORDERS, Customer-FI, Item-FK, Quantity, DeliveryDate) 1. Define the DDL to create the above tables, where Customer_FK is a referential integrity constraint from table ORDERS to table CUSTOMER Item FK is a referential integrity constraint from table ORDERS to table INVENTORY
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
