Data Model
Inventory
ProductCode (MED-ID-Date) Name (Item A) Category (Prescription/Non-Prescription) Manufacturer ReleaseDate
ProductCode QuantityInStock ReorderLevel (Min) CountedBy CountedByDate DiscontinueDate
ProductCode ReorderBy ReorderByDate SupplierID
OrderID ProductCode CustomerID Quantity SellingPrice ReceiptNo
CustomerID Name PhoneNo emailNo""