Relation contracts is a relation whose tuples mean that supp

Relation contracts is a relation whose tuples mean that suppliers part PardID to project projID in quantity. Suppose that each of the four attributes is an integer. Write a CREATE TABLE statement of relation Contracts. Do not forget to declare that together from the and that these are each foreign keys referencing the relations from the list below the element that would appear as part of the definition.

Solution

FOREIGN KEY constraint :A foreign key is a key used to link two tables together.

[D] FOREIGN KEY (supID,partId,proID)

 Relation contracts is a relation whose tuples mean that suppliers part PardID to project projID in quantity. Suppose that each of the four attributes is an int

Get Help Now

Submit a Take Down Notice

Tutor
Tutor: Dr Jack
Most rated tutor on our site