Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 reordered. 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 reorder request. This gives details of the stock item such as item number,
reorder quantity, supplier reference number and supplier name. The reorder 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 contextlevel data flow diagram for this problem.
b Draw Diagram for this problem.
c Describe the metadata for any data flows such as field size, data type, basederived
etc. This will be the information you need to create the tables in the database.
Identify the main input and output design elements for the problem in Question 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
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