Table 4-3 (page 196) contains sample data for parts and for vendors who supply those parts. In

Question:

Table 4-3 (page 196) contains sample data for parts and for vendors who supply those parts. In discussing these data with users, we find that part numbers (but not descriptions) uniquely identify parts and that vendor names uniquely identify vendors.
a. Convert this table to a relation (named PART SUPPLIER) in first normal form. Illustrate the relation with the sample data in the table.
b. List the functional dependencies in PART SUPPLIER and identify a candidate key.
c. For the relation PART SUPPLIER, identify each of the following: an insert anomaly, a delete anomaly, and a modification anomaly.
d. Draw a relational schema for PART SUPPLIER and show the functional dependencies.
e. In what normal form is this relation?
f. Develop a set of 3NF relations from PART SUPPLIER.
g. Show the 3NF relations using Microsoft Visio (or any other tool specified by your instructor).

image text in transcribed
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Modern Database Management

ISBN: 978-0133544619

12th edition

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

Question Posted: