Question: 3. Relation SPP(supID.partID, projID. qty) is a relation whose tuples mean that supplier supID supplies part partID to project projID in quantity aty. Suppose that

 3. Relation SPP(supID.partID, projID. qty) is a relation whose tuples mean

3. Relation SPP(supID.partID, projID. qty) is a relation whose tuples mean that supplier supID supplies part partID to project projID in quantity aty. 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 projld 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) supID INTEGER o b) supID, partID INTEGER O c) TABLE SPP od) PRIMARY KEY (partID) 4. Relation R has schema: CREATE TABLER a INT PRIMARY KEY, DINT DEFAULT O C INT NOT NULL ): R is currently empty. Develop a test that determines whether an insertion into R is currently legal. Then apply your test to determine which of the following INSERT statements is allowable. O a) INSERT INTO R(b, a) VALUES(5.6); ob) INSERT INTO R(a,b) VALUES(1.2); O ) INSERT INTO R(ca) VALUES(6,7); od) INSERT INTO RO) VALUES(O); Submit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!