Relation SPP(supID, partID, projID, qty) is a relation whose tuples mean that su

Question

Relation SPP(supID, partID, projID, qty) is a relation whose tuples mean that supplier supID supplies part partID to project projID in quantity qty. Suppose that each of the four attributes are integers. Write a CREATE TABLE statement for relation SPP. Do not forget to declare that supID, partID, and projID together form the key. and that these are each foreign keys referencing the relations Suppliers, Parts, and Projects, respectively. Then, identify from the list below the element that would appear as part of the definition. a) qty INTEGER b) FOREIGN KEY projID c) INTEGER projID d) FOREIGN KEY Projects REFERENCES projID Relation SPP(supID, partID, projID, qty) is a relation whose tuples mean that supplier supID supplies part partID to project projID in quantity qty. Suppose that each of the four attributes are integers. Write a CREATE TABLE statement for relation SPP. Do not forget to declare that supID, partID, and projID together form the key. and that these are each foreign keys referencing the relations Suppliers, Parts, and Projects, respectively. Then, identify from the list below the element that would appear as part of the definition.

Explanation / Answer

FOREIGN KEY Projects REFERENCES projID

FOREIGN KEY Projects REFERENCES projID

Related Questions

Navigate

• Browse (All)
• Browse R
• Subjects

---

---

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