• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Entity Relationship Diagram

Extracts from this document...

Introduction

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 inventory, relevant information is recorded) vi. ...read more.

Middle

Qty_On_Hand may also be modified manually to adjust the mismatch after a stock take; ii. MEDICATION: 1) All items delivered on the same date also expires on the same date; 2) The quantity of items of each expiring date is calculated by adding the previous Qty_in_stock by any increase or decrease after a delivery, picking or throw-out of expired items; 3) Items are thrown out as soon as it expires. Items close to its expiry date are sold first; 4) Medications are classified as either controlled or non-controlled substances; iii. EMPLOYEE: 1) Each employee has only one position; 2) All employees works within the same country; iv. CUSTOMER: 1) There is no reason or appropriate way to obtain information of a customer if he/she did not purchase with prescriptions, therefore CUSTOMER is a weak entity depending on PRESCRIPTION; v. ORDER 1) The Completion of a particular order is set to be "True" whenever it is satisfied by a delivery(s); vi. ...read more.

Conclusion

Any supplier may or may not have made deliveries(E.g. A new supplier may just receive an order and haven't been able to deliver it); iv. ORDER-EMPLOYEE 1) Each order can only be made by one authorized employee; v. ORDER-INVENTORY 1) Each order may include one or many items;(E.g. A SARS breakout may demand large amount of the same medication); vi. ORDER-SUPPLIER 1) A supplier may just have entered the market and hasn't received any order from FirstCare Pharmacy; vii. PRESCRIPTION SALE-PRESCRIPTION 1) Every prescription sale requires at least one valid prescription to occur; 2) Each prescription can only be used once to buy medications; viii. PRESCRIPTION-EMPLOYEE 1) Each prescription is handled by only one employee; ix. PRESCRIPTION-CUSTOMER 1) Each prescription is written for specifically one customer; x. PICKING-SALE 1) Each sale triggers at least one picking to occur; 2) No pickings for separate sales shall be combined; xi. PICKING-EMPLOYEE 1) Every employee shall pick items from the INVENTORY alone; 2) Some employees might have never done the picking and some might frequently do; xii. PICKING-INVENTORY 1) Only one item shall be picked each time; 2) Some items may never be sold once. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level ICT in Business section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level ICT in Business essays

  1. Full Assignment

    There is no limit to the number of shareholders. Disadvantages of LTD * Disadvantages of being a Ltd is the profit that they make is shared between the owners, (dividends) so if there are a lot of owners (shareholders) all the profit will have to shared between them.

  2. Basic concepts (MRP, MRP II and ERP).

    It is similar to parts list but also shows the product structure. It is structured to reflect the sequence of steps necessary to produce the product. The Bill of Materials application provides a solid base for production activity to be defined, tracked and reviewed.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work