Answered step by step
Verified Expert Solution
Link Copied!

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 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.
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.
image text in transcribed

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

Relational Database Design A Practical Approach

Authors: Marilyn Campbell

1st Edition

1587193175, 978-1587193170

More Books

Students also viewed these Databases questions

Question

7. What decisions would you make as the city manager?

Answered: 1 week ago

Question

8. How would you explain your decisions to the city council?

Answered: 1 week ago