Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started