A wines and spirits wholesaler stocks a range
- Slides: 8
A wines and spirits wholesaler stocks a range of approximately 400 different lines and delivers by van on regular weekly runs to customers who are mainly off-licenses and clubs. The majority of orders are received by telephone and any one customer may place several orders during the week which must be accumulated and delivered in one consignment. When a customer telephones he expects to be advised on the availability of an item requested and, if not in stock, the alternatives that are available. At present, sales order forms are filled in by the telephone salesmen and sent to the warehouse where they are used for the despatch of the items. Hand-written despatch notes are used as the basis of the invoices which are typed and sent by post sometime later.
Final LDS customer order line item Despatch note invoice
customer Draw DFD Order Advice 1 Sales M 1 Accumulate orders Advise availability Complete forms Sales Order Forms 2 Warehouse Produce despatch notes Produce Invoices Despatch note + goods Invoice customer Stock file
Extensions Maintenance of Stock File Customer file – address, credit etc Payments Accounts dept – invoices, payments etc Accumulate orders – temporary file
Customer Draw DFD Order Advice 1 Customers Sales Stock file M 1 M 2 Accumulate orders Advise availability Confirm details Complete forms Sales Order Forms Payments Orders M 3 M 4 2 Warehouse Pick Goods 3 Accounts Produce Despatch Notes Copy Dispatch Note Update Stock File Produce Invoices Handle payments Goods + Copy Order Payment Despatch Note + Goods Invoice D/N + Inv M 5 Customer Supplier
Data Dictionary Name Alias Type Length Max Custno Custnum Num 10 Item. Desc Alp 20 Ord. Tot. Ord Cur 5 e. t. c. 999 Min 9
SELECT (SSADM) A software package for the development of data flow diagrams and data models etc. Comes in various editions to match the methodology used (SSADM) Check compatibility between DFD and LDS Checks DFD level compatibility FREE to copy from library short term loan (need to sign license agreement and get key from CEMS Help Desk)
SSADM Structured Systems Analysis And Design Methodology A highly structured IS development methodology with the emphasis on analysis and design including the user but little about writing programs, testing or implementation.
