Solution for Practice Data Set for Normalization

(NOTE: not being able to put a dotted Line under a Foreign Key, the <> symbols are used to surround the Foreign Keys)

Relations:

CUSTOMER (Customer_Number, Customer_Name, Customer_Address, Customer_Phone)

PRODUCT (Product_Number, Product_Description, Product_Unit_Weight, Product_Unit_Price, Product_Unit_Cost)

ORDER (Order_Number, <Customer_Number>, Order_Date)

LINE ITEM (Order_Number, Product_Number, Order_Quantity, Product_Unit_Price)

INVOICE (Invoice_Number, <Order_Number>, Invoice_Date)

SHIPMENT (PACKING SLIP) (Invoice_Number, Product_Number, Shipping_Quantity, Shipping_Date)

Extended_Product_Price and Total_Invoice_Price are both Calculated Values and should not be incorporated into the Relations, but calculated and printed/displayed as needed