Image link: https://imgur.com/a/IhZhX We added “Date_updated” on the purchase_order table in order to record any changes or updates in the purchase. We also removed the “Price_IN” on the purchase_detail table and replace it with three attribute to make it more exact, placing, “Total_amount”, “Total_payment” and “Total_Balance”. Now with this it is more detailed and we can […]

February 14, 2018

Purchase Module Data Flow Diagram  

  Added table PURCHASE_ORDER to track purchases to  supplier. With employee ID of the purchasing officer.

  This updated ERD has now ORDERLINE, ORDER DETAILS, PRODUCT INVENTORY and PURCHASE DETAIL.

This is the initial design for the Inventory Management System. This shows the relationships of different modules. The Employee, Sales, Product, Customer, Purchased, Supplier agent and the Supplier.   Submitted to Mr. Calo online on January 18, 2018.