Sprocket warehouse, inc is a wholesale distributor of office supplies, such as disks, stationery file cabinets, and related items. Customers receive an updated catalog annually and place orders over the phone.

When a customer calls in with an order, a clerk asks for the customer ID and name. The clerk keys in the customer number, and the computer retrieves the customer record from the customer database and displays it on the clerk's screen. The clerk compares the customer's name to the data on the screen to ensure that the customer is legitimate. If everything checks out, the clerk enters the customer's order. After the order is entered, the computer compares the amount of the order to the available credit to ensure that the purchase does not exceed the credit limit amount.

This results in the creation of an entry in the sales event data store and an allocation of inventory. At the end of the day, the sales event data is processed against the customer data and the inventory data, and the sales order is recorded in the sales order master data store. At the same time, a customer acknowledgment is printed in the warehouse and will be used to assemble the customer's order.

The completed order (goods and attached picking ticket) is forwarded to the shipping department. The shipping clerk keys the sales order number into the computer, and the order is displayed on the screen. The shipping clerk keys in the items and quantites being shipped, and after the computer displays the shipment data, the clerk accepts the input. After the shipment is accepted, the computer updates the sales order and inventory master data and creates a record for biling (in the biling-due liste data store). The computer also prints a packing slip and bill of lading on a printer in the shipping department. These shipping documents and the goods are given to the carrier for shipment to the customer.

From the following draw:

- a context diagram

- a physical flow diagram or logical data flow diagram

- a systems flowchart

Answer rating: 100% (QA)

Call from Customer Clerk obtain Customer name and ID Clerk put customer data in system to retrieve c... View the full answer