Description Instructions Multiple Attempts Not allowed This test can only be tak

Question

Description Instructions Multiple Attempts Not allowed This test can only be taken once Force Completion This test can be saved and resumed later Relation Contracts (supIP, partID, projID, qty) is a relation whose tuples mean that supplier supID supplies part partID to project projID In quantity Suppose that each of the four Attributes is An integer Write a CREATE TABLE statement fox relation Contracts. 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 a; part of the definition. FOREIGN KEY (supID)

Explanation / Answer

The answer to the question is d.

d) FOREIGN KEY(supID, partID,proID) since it the key to each element.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---