Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Information And Database Systems Asian Conference Aciids 2012 Kaohsiung Taiwan March 19 21 2012 Proceedings Part 3 Lnai 7198

Authors: Jeng-Shyang Pan ,Shyi-Ming Chen ,Ngoc-Thanh Nguyen

2012th Edition

3642284922, 978-3642284922

More Books

Students also viewed these Databases questions

Question

1. Who should participate and how will participants be recruited?

Answered: 1 week ago