Part 2 a) We want to keep track of the price we charge for each type of part, the supplier for each type of part, and the amount we pay the supplier...

Part 2 a)

We want to keep track of the price we charge for each type of part, the supplier for each type of part, and the amount we pay the supplier for each type of part (the cost). Each supplier can provide us with many different types of parts, but each part can be provided to us by only one supplier. This requires a one-to-many relationship.

Functional analysis:

Part - > Price, Cost, Supplier, Street, City, State, Zip, Telephone

Supplier - > Street, City, State, Zip, Telephone

Part - > Price, Cost, Supplier

Table:

Parts (Part, Price, Cost, Supplier, Street, City, State, Zip, Telephone)

Compete the following:

1. Is the above table in 2NF?

2. Using the table and field names in the above table explain your answer in plain English.

Part 2 b)

We want to keep track of the price we charge for each type of part, the supplier for each type of part, and the amount we pay each supplier for each type of part (the cost). This time, a supplier can provide us with many different types of parts, AND each part can be provided to us by more than one supplier. Each supplier may charge us a different amount for each part (cost). This requires a many-to-many relationship.

Functional analysis:

Part - > Price

Supplier - > Street, City, State, Zip, Telephone

Part, Supplier - > Cost

Table:

Parts (Part, Price, Cost, Supplier, Street, City, State, Zip, Telephone) 

Complete the following:

1. Is the above table in 2NF?

2. Using the table and field names in the above tables explain your answer for each table in plain English.