Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started