DFD Test Narrative--by sentence:

DFD Test Narrative:

John's Jewelry Store, Inc.

John's Jewelry Store is a small family run retail store in a strip mall. John has been in business for 50 years, so as patriarch he likes the business run the old fashioned way. But his son and daughter have just graduated from Cal Poly Pomona. So they would like Dad to make some improvements in the technology used by the business.

Paragraph 1: Customer Review of Items for Sale

John's son Jack has designed an Ebay store to post all the merchandise they offer.

Customer access the Ebay store to look at all the jewelry that is for sale.

If the customer sees an item they would like to buy, they must come into the store to look at the item in person. John wants to maintain the utmost in quality and customer satisfaction.

Paragraph 2: Sell Item and Receive Payment

Customers come into the store to look at the item they think they want to purchase. They browse the store to see if they see any more items they would like to buy.

The customer presents their total purchase at a checkout location in the store.

They receive a paper copy of the receipt when their sale is processed.

An employee will use a POS (point of sale) terminal to record the sale. John's son and daughter have set the business up in Quickbooks. Quickbooks has set up tables to record transactions as they occur.

As each sale occurs, the POS terminal will:

(1) immediately update quantity on hand in the inventory table,

(2) add a record to sales invoice table,

(3) prints out several coupons to give to the customer to incentivize another sale in the next week.

(4) If a customer uses a coupon received the previous week, coupon discounts are indicated in coupon and discounts column of the sales invoice table.

John's Jewelry store only accepts cash and checks. John refuses to accept credit cards as a customer used a stolen credit card last year and John took quite a loss on the sale. His son and daughter have tried to convince him to try again but he will not.

John does extend credit to certain longtime customers that he knows. When these customers make a sale, their sale details are recorded in the Accounts Receivable table.

Paragraph 3: Bank deposit

Bank deposits are made once a day.

For each deposit the cashier fills out the deposit slip, detailing total checks and cash.

John reviews the deposit, signs the deposit slip, and takes the deposit (cash, checks and deposit slip) to the bank.

He brings back a validated deposit slip stamped by the bank.

Validated deposit slips document the amount of cash actually received by the bank into John's Jewelry Store accounts.

Paragraph 4: Returns

Occasionally a customer will return an item they have purchased.

The item is inspected, cleaned if necessary, and placed back into the inventory listing.

If cash sale, cash will be refunded.

If credit sale, Account Receivable will be debited.

The return data will also be entered into a Quickbooks table for returns. This will act to reduce sales in closing procedures.

Table of entity and activity--optional

Context diagram

Chronologically sorted table of entity and activity with groups

Level zero dfd