-2 REQUIREMENTS: L3 74 From the narrative prepare the following: 15 a. A table of entities and activities--optional b. A context diagram C A chronologically sorted table of entities and activities. Indicate on this table the groupings, bubble numbers, and bubble titles to be used in preparing the level zero logical dfd. d A level zero logical did 16 17 18 19 20 Homero's Jerseys Store is a small retail store. Homero likes the business run the old fashioned way. But he would also like his daughters to take over the business as he is getting old and forgetful. He has decided to make certain changes his daughters think will help increase sales. He wants to make them 5 happy Homero's daughters designed a website to post all Jerseys available for sale. Customers can view the website to see the catalog of jerseys. While the customer can order online, Homero requires all customers to come into the store to pick up the item. This way the customer may see the item's quality first 7 hand before making their purchase. 8 (Start Drawing here) 20 11 12 Paragraph 1: Order 11 Homero's Jerseys Store uses a website to post the merchandise they offer 15 The was process is triggered by a customer accessing Homero's Jerseys Store catalog and deciding what and if to order. 16 l the customer so an tom they would like to order, they post a customer order within Homero's Jenseys Storo sales order database 13 17 10 20 22 19 Paragraph 2 Pick up Order (Sale) Cuntomens come into the store to pick up their orders. The customer presents their total purchase at a checkout location in the store. They receive a paper 21 copy of the receipt when their sale is processed 23 Sales clerks use POS (point of sale) terminals to record the sale. As each sale occurs, the POS terminal will: 251) immediately update quantity on hand in the inventory master file, 26 (2) compile detailed sales transaction data, 27 (3) indicate that the ordered items were picked up by the customer--in the sales order database, 204) and print out several coupons to give to the customer to incentivize another sabe Instruction Narrative by stence Table of Entity and Activity Sample Shapes for did Context diagram Chronological tale with you 24 28 (4) and print out several coupons to give to the customer to incentivize another sale. 29 (5) If a customer uses a coupon received the previous week, coupon discounts are indicated in detailed sales data. 30 31 Homero's Jerseys Store only accepts credit cards, NCC (national credit cards such as VISA and MasterCard). 32 The first thing the clerk will do is check a file of customers who have used stolen credit cards in the past if the customer is not on this file (and the customer uses a VISA or MasterCard to pay for the sale), the sales clerk makes an electronic request to a NCC bank 33 for payment. This request is an authorization 34 When the NCC bank approves the sale, an approval code is sent back. 35 This code is recorded in the detailed sales data 36 Occasionally sales are not approved by NCC banks 37 38 39 Paragraph 3: Inventory Reorder and Reconcile 40 41 At the end of each week, Homero's daughters review the inventory master file and decide what items to reorder. 42 For those items that are ordered, an email purchase order is sent to the preferred vendor 43 Iterns on order are indicated as such in the inventory master file in order to reconcile the exact amount of inventory on hand, and to determine inventory sales, Homero compares ordered and picked up items in the sales order 45 database, to sales of inventory in detailed sales data, and to the inventory master file. 46 47 Homero will also count iteme on store floor and compare to the inventory master file As It he is unable to reconcile item shortapes or oulages, he will speak to sales clerks individually 49 SO 51 Complete 52 Table of entity and activity-optional 53 Context diagram 54 Chronologically sorted table of entity and activity with groups ss Level zoro old 44 -2 REQUIREMENTS: L3 74 From the narrative prepare the following: 15 a. A table of entities and activities--optional b. A context diagram C A chronologically sorted table of entities and activities. Indicate on this table the groupings, bubble numbers, and bubble titles to be used in preparing the level zero logical dfd. d A level zero logical did 16 17 18 19 20 Homero's Jerseys Store is a small retail store. Homero likes the business run the old fashioned way. But he would also like his daughters to take over the business as he is getting old and forgetful. He has decided to make certain changes his daughters think will help increase sales. He wants to make them 5 happy Homero's daughters designed a website to post all Jerseys available for sale. Customers can view the website to see the catalog of jerseys. While the customer can order online, Homero requires all customers to come into the store to pick up the item. This way the customer may see the item's quality first 7 hand before making their purchase. 8 (Start Drawing here) 20 11 12 Paragraph 1: Order 11 Homero's Jerseys Store uses a website to post the merchandise they offer 15 The was process is triggered by a customer accessing Homero's Jerseys Store catalog and deciding what and if to order. 16 l the customer so an tom they would like to order, they post a customer order within Homero's Jenseys Storo sales order database 13 17 10 20 22 19 Paragraph 2 Pick up Order (Sale) Cuntomens come into the store to pick up their orders. The customer presents their total purchase at a checkout location in the store. They receive a paper 21 copy of the receipt when their sale is processed 23 Sales clerks use POS (point of sale) terminals to record the sale. As each sale occurs, the POS terminal will: 251) immediately update quantity on hand in the inventory master file, 26 (2) compile detailed sales transaction data, 27 (3) indicate that the ordered items were picked up by the customer--in the sales order database, 204) and print out several coupons to give to the customer to incentivize another sabe Instruction Narrative by stence Table of Entity and Activity Sample Shapes for did Context diagram Chronological tale with you 24 28 (4) and print out several coupons to give to the customer to incentivize another sale. 29 (5) If a customer uses a coupon received the previous week, coupon discounts are indicated in detailed sales data. 30 31 Homero's Jerseys Store only accepts credit cards, NCC (national credit cards such as VISA and MasterCard). 32 The first thing the clerk will do is check a file of customers who have used stolen credit cards in the past if the customer is not on this file (and the customer uses a VISA or MasterCard to pay for the sale), the sales clerk makes an electronic request to a NCC bank 33 for payment. This request is an authorization 34 When the NCC bank approves the sale, an approval code is sent back. 35 This code is recorded in the detailed sales data 36 Occasionally sales are not approved by NCC banks 37 38 39 Paragraph 3: Inventory Reorder and Reconcile 40 41 At the end of each week, Homero's daughters review the inventory master file and decide what items to reorder. 42 For those items that are ordered, an email purchase order is sent to the preferred vendor 43 Iterns on order are indicated as such in the inventory master file in order to reconcile the exact amount of inventory on hand, and to determine inventory sales, Homero compares ordered and picked up items in the sales order 45 database, to sales of inventory in detailed sales data, and to the inventory master file. 46 47 Homero will also count iteme on store floor and compare to the inventory master file As It he is unable to reconcile item shortapes or oulages, he will speak to sales clerks individually 49 SO 51 Complete 52 Table of entity and activity-optional 53 Context diagram 54 Chronologically sorted table of entity and activity with groups ss Level zoro old 44