Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2019 Wurzburg Germany September 16 20 2019 Proceedings Part 2 Lnai 11907

Authors: Ulf Brefeld ,Elisa Fromont ,Andreas Hotho ,Arno Knobbe ,Marloes Maathuis ,Celine Robardet

1st Edition

3030461467, 978-3030461461

More Books

Students also viewed these Databases questions

Question

what are the three primary classification of cloud network

Answered: 1 week ago

Question

5. Describe the relationship between history and identity.

Answered: 1 week ago