Macon Supplies inc. sells auto parts to the wholesalers. When a customer calls in with an order and gives the customer ID and name, an order entry 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 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 amount limit.

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 order event data, customer data and inventory data are used to record the sales order in the sales order mater data store. At the same time, a customer acknowledgement is printed in the mail room and is mailed to the customer. Also, a picking ticket is printed and sent to the warehouse.

Table of Entities and Activities

Entities	Activities
Customer	1. Call in with an order and give customer ID and name.
Clerks	2. Enter customer number.
Computer	3. Retrieve and display the customer data.
Clerks	4. Compare name to display.
Clerks	5. Key in order.
Computer	6. Verify that the order does not exceed credit balance.
	7. Create an entry in the sales order event data store and allocate inventory.
	8. Record the sale order in the sales order master data store with the sales order event data, customer data and the inventory data.
	9. Print customer acknowledgement.
	10. Print picking ticket and send to warehouse
Mailroom (clerk)	11. Mail acknowledgement to customer.

Requirements:

1. Prepare a Context Diagram

2. Prepare a Physical Diagram

3. Prepare a System Flowchart