Here are declarations of two relations Products and Orders CREATE TABLE Products

Question

Here are declarations of two relations Products and Orders CREATE TABLE Products p|D CHAR(2). qty INT, PRIMARY KEY(pID)). CREATE TABLE Orders(OID CHAR (2), PID CHAR(2 qty INT, PRIMARY KEY(OID). products(pID, qty) currently contains the four tuples (02, 10), (03, 11), (04, 12), and (05, 13). Order(oID, pID, qty) currently contains the four tuples (01, 04, 10), (02, 05, 11), (03, 04, 12), and (04, 05, 13). As a result, certain insertions and deletions on Products are illegal as are certain updates or insertions on Order You should develop simple tests for illegal operations of these four kinds. Then, show your understanding by indicating which of the following modifications will not be rejected because of a constraint violation. Inserting (05, 06, 2) into Orders. Updating (04, 05, 13) in orders to be (04, 06, 4) Updating (02, 10) in products to be (02, 5) Inserting (05, 5) into Products.

Explanation / Answer

Part C will not be rejected.

Part a will be rejected because pID is 06 which is not present

Same goes for part b as foreign key contrains are being violated

For part d, we already have 05 as pID, which violates the condition of primary key.

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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