WestMercia Notebooks Ltd - Essay Example

Level DFD - Existing System Confirmation Invoice/ ment Balance Sending the ordered notebooks Sending reminders to customers about outstanding Level-1 DFD - Proposed System Confirmation Invoice/ Statement Balance Sending the ordered notebooks Sending reminders to customers about outstanding Level-2 DFD - Existing System Confirmation Invoice/ Statement Balance Sending the ordered notebooks Level-2 DFD - Proposed System Confirmation Invoice/ Statement Balance Brief narrative of the proposed system Since the company has been in business for about 18 yrs now, it is an established name in the market. Therefore, the company might not be able to take fullest advantage of its brand identity, if it does not accept the orders requiring immediate delivery. For this the company will have to keep some minimum stock of readymade notebooks. As and when such orders come, the company can deliver it immediately. Notebooks prepared on order, generally carry the name of the college, institute, corporate house etc. who is ordering it. When WestMercia starts keeping some minimum stock of readymade notebooks, carrying the name of the company, it is bound to help the company in establishing a brand identity. Entities for E-R Diagram An entity is something that is supposed to have a distinct, separate existence and identity. In this category, generally we take person, place, thing, event, or concept, about which information is to be stored. WestMercia Notebooks mainly has the following entities; Notebook Buyers Order Suppliers file Purchase file Invoices E-R Diagram Entity History Entity Life History (ELH) analyses the life cycle of the entities in the WestMercia Notebooks Ltd. ELH diagram also includes sequencing, iteration or timing of events in the system. It also investigates the integrity requirements and successor actions relevant for each entity, the administration of the entity, and the deletion of the entity. ELH is thus used to define the rules and regulations determining the life cycle of the entities and how do we perform actions like insert, update, and delete. ELH Diagram for 'Notebook': Event-1: The Customer i.e. college/ institution/ retailer/ wholesaler approaches the company with the specification of the notebook. Event-2: After WestMercia Notebooks Ltd. receives the orders, it starts processing it with the help of different departments Event-3: The production department makes the notebooks with appropriate specifications and sends them for being delivered to the customer. Event-4: The notebook is distributed amongst students, employees by the colleges or institutions and sold by retailers and wholesalers. Students and employees in turn use the notebooks and thus the notebook completes its useful life. ELH Diagram for 'Order': Event-1: Marketing team starts negotiations on the order. Negotiations take place regarding order size, prices, expected time of delivery etc. Such negotiations also often involve some discounts, if the customer has been a regular one for the company, with good payment record. Event-2: Once the negotiations are over, a consolidated order is prepared, with details like terms of payments, advances, discounts etc. Event-3: The production department starts working on the order, places order for raw material and once the notebooks are ready, sends it across to the dispatch sections for packaging and delivery. Event-4: The account department takes a look at the payment position, and accordingly gives a go ahead to the dispatch department for sending it across to the customer. Thus the order is completed within couple of days or weeks, depending upon the order size. Read More