Assignment 1 Entity Relationship Diagram
PHILIP YUNFEI CHANG 187542
- Information Requirements:
- The new system shall:
- Manage details of its inventory;
- Manage relevant information of each employee;
- Manage relevant information of each supplier;
- Manage relevant information of each customer;
- Maintain record of each order placed;
- Maintain record of each delivery received;
- Maintain record of each prescription handled;
- Maintain record of each sale made;
- The new system shall be able to handle the following tasks which the old system didn’t handle well:
- Monitor the quantity of items in stock and reduce the dependence of operations on stock-take;
- Maintain up-to-date prices of each item from multiple suppliers;
- Monitor the expiry dates of medications in stock and sell as many items as possible before they expire;
- Orders are made by authorized employees only and whoever placed an order can be traced back.
- Maintain control over access to inventory. (Whenever an item is picked from the inventory, relevant information is recorded)
- Prescription sales do not occur without valid prescriptions.
- Records of prescription to controlled substances are ready to be collected for inspection.