Case D:

Polis Grocers is an online grocery service that provides home delivery of groceries purchased via the Internet. Polis operates in the greater Chicago area and provides delivery to precertified customers. To be certified, the customer must have a user account with an established credit or charge line and rent a refrigerated unit to store delivered goods at their residence should they not be home at the time of delivery. To enter an order, the customer must log on to the Polis Web site with a user name and password. Using the customer database, the system confirms that the cus- tomer has a refrigerator unit in place and that the customer is in good standing. Once approved, the customer can browse the product list that is generated from the inventory database and add items to the shopping cart. When finished, the customer proceeds to the checkout screen to authorize the billing amount to be charged to her account. When the order is submitted, items are allocated in the inventory database, and a new order is recorded in the order database. In the warehouse, a clerk downloads an outstanding order from the order data- base to a handheld computer. The downloaded order provides an electronic picking ticket for use in assembling the customer's order. The clerk reads the order from the handheld computer screen, picks the goods, and scans each item as it is placed in a box. As each item is scanned, the computer updates the inventory and order data- bases. When the order is completed, the clerk presses a button on the handheld com- puter, and the computer prints a barcode on the handheld computer. The clerk attaches the barcode to the out- side of the box and places the order on a conveyor belt to delivery services. In delivery services, the delivery person uses another handheld device to read the barcode and access the sales order information from the order database. The items in the box are rechecked per the order and loaded for delivery to the customer. Keying in the confirmation of the order contents by the delivery person triggers the printing of delivery directions and receipt. Upon delivering pie groceries and receipt to the customer, the delivery person once again reads the barcode with the handheld device and presses the button for confirmation of delivery. The completion of the delivery is automatically recorded in the order database. The system at this time also updates the customer's master data for billing purposes. For the case assigned by your instructor, complete the following require- ments. For the diagramming and flowcharting assignments, use Microsoft Visio, or other appropriate software as directed by your instructor. a) Prepare a table of entities and activities. b) Draw a context diagram. c) Draw a physical data flow diagram (DFD)

d) Prepare an annotated table of entities and activities. Indicate on this table the groupings, bubble numbers, and bubble titles to be used in preparing a level 0 logical DFD. e) Draw a level 0 logical DFD.