SQL and Database Questions QUESTION 6 0.5 points Save Answer Below is a partiall

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 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)

Explanation / Answer

Question 6:
FOREIGN KEY(customerID) REFERENCES Customers(customerID)

Question 7:
B - if a row from the parent table is updated then matching rows in the child table are automatically updated as well.

Question 8:
Projection
Set Difference
UNION
Natural join
Cartesian Product

Question 9:
A - The projection operator is most similar to the WHERE clause in SQL

Question 10:
E - all of the above

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.