Design an appropriate set of normalized relation to represent the Material Supply

Details. Decompose the following relation to First Normal Form (INF), Second Normal Form (2NF) and Third Normal Form (3NF).

Material (Material Id. Material Name,Units Of Measure, Standard Cost, Vendor Id, Vendor Name, Tel No,Email,Unit price, Terms Code, Terms) 

Based on Shipment relation below briefly explain THREE (3) different types of anomalies that occur in this unnormalized table.  

Shipment relation 

Shipment (ShipmentID, ShipmentDate, Expected Arrival Date, Origin, destination, ship#, Captianld, Captain Name, Item#, Type, description, weight, quantity)

Answer rating: 100% (QA)

To design an appropriate set of normalized relations to represent the Material Supply chain we need to decompose the given relation into smaller more ... View the full answer