Hey Guys, I need help on an ERD normalization question. from 1NF to 3NF?
Hey I have two questions on normalization that I am practicing for my final but I cant seem to get them.
This is in the 1st normal form and I need to get it to the 3rd normal form.
1.
Customer( CustomerID, Name, Address)
Product(ProductID, Description)
Order(Order Number, Customer ID, OrderDate)
LineItem(OrderNumber, ProductID, OrderQuantity)
Invoice(InvoiceNumber, OrderNumber, InvoiceDate)
Shipment(InvoiceNumber,ProductID,Quant…

2.
Vendor(VendorID,Address)
PriceOuote(QuoteQuantity,Price)
Part(itemNumber, Description)
PartReceipt(OrderNumber,Date,OrderQuan…

I did them but I am not sure if they are correct.
I need someone to help me get these to the 3rd NF from 1stNF.
Thanks to all you guys out there.
Any input is valued.