Hello!
I'm a (online) student with NO experience when it comes to databases. I just need a little push in the right direction here.
I have to normalize these tables, and I'm almost positive that the first 3 are in 3rd normal form, but I can't quite get a handle on the last table.
PARTS INVENTORY PURCHASES
Transaction ID
Purchase Date
Purchase Price
Quantity
PARTS INVENTORY ISSUES
Transaction ID
Issue Date
Purchase Price
Quantity
PARTS CATALOGUE
ID
Description
Type
Manufacturer
Quantity On Hand
Reorder Point
Reorder Quantity
Parts Purchasing History
Transaction ID
Catalogue ID
Quantity Purchased
Manufacturer ID
Order Quantity
Price
Shipping
Tax
FOB
Thanks for any assistance!!
Rachel