Car Stuff Inc.

Car Stuff Inc. is a wholesale distributor of autoparts, such as bulbs, brakes, upholstery, 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 clerks screen. The clerk compares the customers name to the data on the screen to ensure that the customer is legitimate, If everything checks out, the clerk enters the customers 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 event data are 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 acknowledgement is printed in the mail room and is mailed to the customer. Also, a picking ticket is printed in the warehouse and will be used to assemble the customers order.

Table of entities and activities (Annotated):

Entities	Para	Activities	Process
Order entry (clerks)	2	2. Enter customer number.	1.0 Validate and record customer order.
Computer	2	3. Retrieve and display the customer data.
Order entry (clerks)	2	4. Compare name to display.
	2	5. Key in the order.
Computer	2	7. Verify that the order does not exceed credit balance.
	3	8. Create an entry in the sales event data store and allocate inventory.
Computer	3	9. Process the sales event data against the customer and inventory data and record in sales order master data store.	2.0 Record sales order.
	3	10. Print customer acknowledgement.
	3	11. Print picking ticket.

Use MS Visio to:

Draw a context Diagram

Draw a physical Data flow diagram (DFD)

Draw a level 0 Logical DFD (you may annotate the Table of entities and activities provided).