Given the following relation and example data: PartNumber Description Supplier S

Question

Given the following relation and example data: PartNumber Description Supplier SupplierAddress Price 10010 20 TB Disk Seagate Cuppertino, CA $100 10010 20 TB Disk IBM Armonk, NY $90 10220 256 GB RAM card Kensington San Mateo, CA $220 10220 256 GB RAM card IBM Armonk, NY $290 10220 256 GB RAM card Sun Microsystems Palo Alto, CA $310 10440 21 LCD Monitor IBM Armonk, NY $2,100 FD1: PartNumber Description FD2: PartNumber, Supplier Price FD3: Supplier SupplierAddress Normalize this relation into 3NF.

Explanation / Answer

Functional dependencies are:

FD1: PartNumber Description
FD2: PartNumber, Supplier Price
FD3: Supplier SupplierAddress
1NF: Suggest PartNumber, Supplier as the key so we are in 1NF
2NF: We have a partial key dependency in that Supplier SupplierAddress so normalize:

R1(PartNumber, Description, Supplier, Price)
FD1: PartNumber Description
FD2: PartNumber, Supplier Price

R2(Supplier, SupplierAddress)
FD1: Supplier SupplierAddress

But we still have a problem with R1 so normalize again:

R3 (PartNumber, Supplier, Price)
FD1: PartNumber, Supplier Price

R4 (PartNumber, Description PartNumber Description R2 (Supplier, SupplierAddress)
FD1: Supplier SupplierAddress

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.