Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q1 Draw context diagram and level-0 diagram to the requesting agency with a letter stating why the purchase order cannot be filled, and a copy

image text in transcribed
Q1 Draw context diagram and level-0 diagram to the requesting agency with a letter stating why the purchase order cannot be filled, and a copy of the let- ter is filed. If the purchase order is valid, the contract- ing 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 Fulfill- ment department. Here the inventory is checked for each item ordered. If any items are not in stock, the Government Solutions Company (GSC) sells com puter equipment to federal government agencies Whenever a federal agency needs to purchase equip- ment from GSC, t issues a purchase order against a standing contract previously negotiated with the company various federal agencies. When a purchase order is re- ceived by GSC's contracting officer, the contract num- ber referenced on the purchase order is entered into the contract database. Using information from the da tabase, 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 equip- ment ordered is listed on the original contract, and the total cost of the equipment does not exceed a pre- determined lmit. If the purchase order is not valid the contracting officer sends the purchase order back GSC holds several standing contracts with er 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 ware- house, 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 ship- ping b sting the items shipped and sends it to the contracting officer. If all items were shipped, the con- tracting officer closes the outstanding purchase order record in the database. The purchase order, shipping bill, and exception report (if attached) are then filed in the contracts office

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

Principles Of Database Systems With Internet And Java Applications

Authors: Greg Riccardi

1st Edition

020161247X, 978-0201612479

More Books

Students also viewed these Databases questions

Question

Chapter 5, Exercise 5-1

Answered: 1 week ago