Question: SQL and Database Questions QUESTION 6 0.5 points Save Answer Below is a partially complete CREATE TABLE statement for the Orders table in the Clothing
SQL and Database Questions





QUESTION 6 0.5 points Save Answer Below is a partially complete CREATE TABLE statement for the Orders table in the Clothing Store database. Consider it in conjunction with the Customers table in the same database you constructed in the previous question. Fill in the blank below to add a foreign key constraint on the customerlD attribute which links it to the appropriate attribute in the Customers table. There is a blank in the query, and you should enter the required text in the box below. Do not include ON UPDATE and ON DELETE clauses. Your answer will be marked incorrect if there is a spelling mistake, missing spaces, or unnecessary spaces. CREATE TABLE Orders orderlD int productiD int, customerlD int, storelD int PRIMARY KEY (orderlD, productiD) FOREIGN KEY (productID) REFERENCES Products (productID), FOREIGN KEY (storelD) REFERENCES Stores (ID)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
