Create Normalized relations for each relation. Please format like this: Primary Key:

Candidate Key:

Foreign Key:

Violation:

Determinate:

Normalization: -------------------------------------------------------------------------------- Warehouse (WarehouseNo, Address, Phone_Number, Email)

Vendor(VendorID, Address, Phone_Number, Email)

Employee (EmpId, FName, LName, SSN, Address, Email, Phone_Number, Dept, Position)

Customer (CustID, CustType, FName, LName, Email, Phone Number, AR, AP)

Inventory (ItemID, Name, Description, UnitCost, UnitPrice, Instock_Quantity, BackOrder_Quantity, WarehouseNo, LocationInWarehouse)

Purchase (PurchaseNo, ItemID, Date, Instock_Quanity, UnitCost, Purchase_Status, VendorID)

Sales (SaleID, Date, ItemID, units, paymentstatus, transtype, Instock_Quantity

BackOrder _Quantity, CustID)

SacCorporation (Fed taxid, State taxid, Sac name, Contact name, Address, Phone, Email)

Division (Div ID, Div type, Name, Employee ID, Fed taxid, State taxid)

Department (Dept ID, Dept Name, Manager ID, Div ID, Phone)

Sales item ( Item ID, Sales ID, Quantity, Unit Price, SalesPayment ID, Payment type,

Amount, Employee ID)

Sales Payment (SalesPayment ID, Paymenttype, Amount, Employee ID, Customer ID)

Item (Item ID, Name, Description, Category, Unit Price, Date, Div ID)

Order (Order ID, Order date. Delivery date. Vendor ID. Employee ID)

Order Item (Order ID, Item ID, Quantity Unit Price)

Order Payment (OrderPayment ID, Vendor ID, Payment amount, Date, Emplovee ID)