Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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 pointsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started