December
1999 QUESTION 4 Total Marks: 15 Marks |
Click here to access other
questions
Click to access |
| (a) |
Define the term data flow diagram .
|
[2] |
| (b) |
Consider the following scenario: Orders are received from customers and validated against the stock file to see if all the items exist.If an item does not exist,then it is added to the stock file. Each order is then checked for availability.Orders that can be supplied immediately have the order details sent to to the warehouse,and the stock file is decremented accordingly.Orders that cannot be satisfied immediately are placed in a back orders file and a requisition note is sent to the purchasing department for the missing items.If the items are no longer supplied,the purchasing department sends back a ‘not supplied ’note and the items are deleted from the stock file. When the items are received from suppliers,the goods inward department completes a ‘goods inward ’note and the stock file is incremented. Once a year there is a stock audit which results in an audit report to the warehouse manager.Any items not ordered in the last year are deleted from the stock file.Any items for which there is a discrepancy between the physical stock and the stock file have their stock level adjusted on the stock file. (i)Identify five entities associated with the above scenario.[3 marks ] (ii)Identify five processes associated with the above scenario.[3 marks ] (iii)Identify two data stores associated with the above scenario.[1mark ] (iv)Using these entities,processes and data stores,draw a data flow diagram for the above scenario.[6 marks ] |
[13] |