Description on data flow diagrams


Question:

Description on Data Flow Diagrams

Question 1.

Develop a context diagram and a level-0 diagram for the contracting system described in the following narrative. If you discover that the narrative is incomplete, make up reasonable explanations to complete the story. Supply these extra explanations along with the diagrams. Here is the narrative.

Government Solutions Company (GSC) sells computer equipment to federal government agencies. Whenever a federal agency needs to purchase GSC, it issues a purchase order against a standing contract previously negotiated with the company. GSC holds several standing contracts with various federal agencies. When a purchase order is received GSC's contracting officer, the contract number referenced on the purchase order is entered in the contract database. Using information from the database, the contracting officer reviews the terms and conditions of the contract and determines whether the purchase order is valid. The purchase order is valid if the contract has not expired, the type of equipment ordered is listed on the original contract, and the total cost of the equipment does not exceed a predetermined limit. If the purchase order is not valid, the contracting officer sends the purchase order back to the requesting agency with a letter stating why the purchase order cannot be filled, and a copy of the letter is filed. If the purchase order is valid, the contracting officer enters the purchase order number into the contract database and flags the order as outstanding. The purchase order is then sent to the order fulfillment department. Here the inventory is checked for each item ordered. If any items are not in stock, the order fulfillment department creates a report listing the items not in stock and attaches it to the purchase order. All purchase orders are forwarded to the warehouse to the warehouse where the items in stock are pulled from the shelves and shipped to the customer. The warehouse then attaches to the purchase order a copy of the shipping bill listing the items shipped and sends it to the contracting officer. If all items were shipped, the contracting officer closes the outstanding purchase order record in the database. The purchase order, shipping bill, and exception report 9if attached) are then filed in the contracts office.

Solution Preview :

Prepared by a verified Expert
Database Management System: Description on data flow diagrams
Reference No:- TGS01938485

Now Priced at $20 (50% Discount)

Recommended (93%)

Rated (4.5/5)