Question 12 5 pts OrdenLineltems Ordel D OrderSequence ProduclD Orders Products

Question

Question 12 5 pts OrdenLineltems Ordel D OrderSequence ProduclD Orders Products ProductlD ProductNam e Ordel D OrderD te Suppose the following are true (a) OrderlD and ProductID are the primary key of Orders and Products, respectively (b) Within an order sequence numbers never repeat and always begin from 1 (c) A same product may appear twice as two line items in an order Then, without adding an extra column and using a minmum number of columns, which should be defined as the primary key of OrderLineltems in the above model? OrderlD ProductID OrderlD and ProductiD together OrderlD and OrderSequence together OrderSequence and ProductiD together

Explanation / Answer

Answer) OrderId and OrderSequence together

Explnation:- As OrderSequence wont repeat for an OrderId and as OrderId is unique, both together will be unique for each row in OrderLineItems table

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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