Assume you have determined the follow tables for the database: EMPLOYEE (EmployeeID, LastName, FirstName, Department, Position, Supervisor, OfficePhone, Office Fax, EmailAddress) STORE (StoreName, City, Country, Phone, Fax, EmailAddress, Contact) PURCHASE ITEM (PurchaseItemID, StoreName, Purchasing AgentID, Purchase Date, Item Description, Category, PriceUSD) SHIPPER (ShipperID, ShipperName, Phone, Fax, EmailAddress, Contact) SHIPMENT (ShipmentID, ShipperID, Purchasing AgentID, ShipperInvoiceNumber, Origin, Destination, Scheduled DepartureDate, ActualDepartureDate, EstimatedArrivalDate) SHIPMENT_ITEM (ShipmentID, ShipmentItemID, PurchaseItemID, Insured Value) SHIPMENT_RECEIPT (ReceiptNumber, ShipmentID, PurchaseItemID, Receiving AgentID, ReceiptDate, ReceiptTime, Receipt Quantity, isReceivedUndamaged, DamageNotes) TO DO:
Create a MySQL Workbench Design.