Coursework.Info - Inspiration in an Instant

On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:

Assignment 1 Entity Relationship Diagram PHILIP YUNFEI CHANG 187542 1. Information Requirements: * The new system shall: i. Manage details of its inventory; ii. Manage relevant information of each employee; iii. Manage relevant information of each supplier; iv. Manage relevant information of each customer; v. Maintain record of each order placed; vi. Maintain record of each delivery received; vii. Maintain record of each prescription handled; viii. 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: i. Monitor the quantity of items in stock and reduce the dependence of operations on stock-take; ii. Maintain up-to-date prices of each item from multiple suppliers; iii. Monitor the expiry dates of medications in stock and sell as many items as possible before they expire; iv. Orders are made by authorized employees only and whoever placed an order can be traced back. v. Maintain control over access to inventory. (Whenever an item is picked from the...

Get instant access

• Instant, unlimited access to our documents in full
• Swap your work for free access, or pay £4.99
• To see the full version of this document and 147,231 others

OR

Receive email updates for this category

• Simply tell us your email address and receive a weekly Study Help Email for FREE
• Receive 3 FREE essay views with each email
• Get all the latest essays from Coursework.Info & discussion from TheStudentRoom.co.uk