Question: Systems Analyst and Design. Please answer with steps Thank you. happy holidays 1. The storeroom of the University receives incoming goods accompanied by a Goods

 Systems Analyst and Design. Please answer with steps Thank you. happy

Systems Analyst and Design. Please answer with steps Thank you. happy holidays

1. The storeroom of the University receives incoming goods accompanied by a Goods Inward Note from suppliers. The stores person issues an item to a department upon receipt of a Requisition for the item. The purchasing department needs to know which items are below their minimum stock level and which need to be re-ordered. The store manager sends details of stock issues and stock receipts to the stock control department that adjusts the stock records for the items in question. When an item falls below a certain specified minimum stock level the store manager writes out a re-order request. This gives details of the stock item such as item number, re-order quantity, supplier reference number and supplier name. The re-order request is sent to the purchasing department which generates a purchase order. Details of the supplier are obtained from a supplier name and address list. The purchase order is sent to the supplier. At the end of each month the stores manager creates a stock report that lists those items which have not moved during the last six months. The stores manager sends this report to the purchasing manager. (a). Draw a context-level data flow diagram for this problem. (b). Draw Diagram 0 for this problem. (c). Describe the meta-data for any 3 data flows (such as field size, data type, base/derived, etc.). This will be the information you need to create the tables in the database. 2. Identify the main input and output design elements for the problem in Question 1. How would you design the input and output for this application? Be detailed, specific, and clear. You can answer in bullet points

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!