Unnormalized database of Parts Inventory Warehouse Supervisor Supervisor Quantit

Question

Unnormalized database of Parts Inventory Warehouse Supervisor Supervisor Quantity Supervisor Phone Part Part rt Warehouse Warehouse On-hand 200 Number Description Unit Cost Number Location 101 101 101 102 102 102 103 Wage 555-1234 20.00 555-1234 20.00 123-1000 Atlanta, GA Parky Wheel Wheel Wheel Gear Gear Gear Wire Wire Wire 1.40 1.40 Savannah, GA Parky New York, NY Albany, NY Savannah, GA P Atlanta, GA Savannah, GA Chicago, IL New York, NY 300 1.40 6.60 6.60 6.60 2.50 2.50 Bill Bill Parky Parky Parky 123-1000 555-1234 555-1234 555-1234 456-7890 123-1000 25.00 25.00 20.00 20.00 20.00 400 150 350 500 800 30,00 25.00 200 103

Explanation / Answer

Solution:

The tables in third normal form will be:

Part(PartNumber, Part Description, Part unit Cost)

Primary key: PartNumber

Warehouse( Warehouse Number, Warehouse Location, Part Number, Supervisor Phone)

Primary key: Warehouse

Foreign Key: PartNumber, Supervisor Phone

Supervisor(Supervisor Phone, Supervisor Wage, Quantity )

Primary key: Supervisor Phone

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

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