Question

Please can you answer this question. Thnks

2) Given the Supplier_Parts relation below with sample data, Determine an appropriate Key. Then list the Functional Dependencies and normalize the relation to 3NF.

Supplier_Parts ( PartNumber, Description, Supplier, SupplierCity, Price )

PartNumber	Description	Supplier	SupplierCity	Price
10010	20 TB Disk	Seagate	Cupertino, CA	$100
10010	20 TB Disk	IBM	Armonk, NY	$90
10010	20 TB Disk	Hitachi	Tarrytown, NY	$90
10220	256 GB RAM card	Kensington	Palo Alto, CA	$220
10220	256 GB RAM card	IBM	Armonk, NY	$230
10222	256 GB RAM card	Hewlett Packard	Palo Alto, CA	$310
10440	32′′ LCD Monitor	IBM	Armonk, NY	$310

Answer 1

2) Primary key ---- PartNumber, Supplier

1NF

Supplier_Parts ( PartNumber, Description, Supplier, SupplierCity, Price )

The table is already in 1NF as all the attributes are atomic

2NF

Partial Functional dependencies:

PartNumber -> Description

Supplier -> SupplierCity

Full functional dependency

PartNumber,Supplier -> Price

Tables in 3NF( There is no transitive dependency)

Part(PartNumber ,Description)

Supplier(Supplier , SupplierCity)

Supplier_Parts(PartNumber,Supplier , Price)

underlined are primary keys and italicized are foreign keys. Some attributes are both.

Do ask if any doubt. Please up-vote.