ABC Catalog Database Application

A customer enters the store, chooses some merchandise from the store catalog, takes a blank

ORDER-FORM from the table, fills out the form, and presents the ORDER to the order clerk.

The order clerk verifies: (1) that the ORDER was properly filled out (2) that the customer

included the zip code in the ship-to address, (3) that the customer name and address, quantity,

product number are listed, and (4) that the customer listed the correct price for the product. The

order clerk computes the total amount due, adds all takes, and determines the grand total. The

order clerk accepts PAYMENT from the customer, places the PAYMENT in the CASH

DRAWER, dates the ORDER, approves the order initialing the order, and places the order in the

stack of APPROVED-ORDERS in the open window for the data clerk.

The stack of orders in the open window is organized by date and time written. The clerk takes

the next APPROVED-ORDER off the top of the stack and enters that order into the company's

computer system. The computer system performs four functions with the new order.

1. The system sends a SHIPPING-ORDER containing the customer's name, ship-to address,

product number and quantity to the warehouse, and a copy of the order prints out upon

receipt of the shipping clerk's REQUEST-ORDER.

2. The system saves information about the order in the ORDERS data store by date of sale

and customer's name.

3. The system provides information in the form of a report (ACCT-REPORT) to the

accounts receivable clerk (AACT-RECV Clerk). The ACCT-REPORT lists the following

information for all sales: date of sale, order clerk's initials, total payment for

merchandise, appropriate taxes, and the grand total amount collected from the customer.

4. The system produces a SALES-VOLUME-REPORT for management that indicates the

current dollar volume of sales by week compared to the dollar volume of sales for the

previous 12 weeks.

The shipping clerk obtains the SHIPPING-ORDER printed on a multipart pink form (PINK

SHEET). The warehouse worker picks up the PINK-SHEET and goes into the WAREHOUSE to

locate and select the ordered product (PRODUCT). The warehouse worker brings the ordered

product to the dispatch clerk together with the PINK-SHEET.

The dispatch clerk has four responsibilities:

1. Package the MERCHANDISE for shipment, which includes the PRODUCTS and

one copy of the PINK-SHEET.

2. Telephone the delivery service that delivers to the ship-to address. A list on the

wall (SHIPPERS) contains information on all of the freight delivery services

(names, phone numbers, and the cities and states that they service) sorted by cities

and states.

3. Give the teamster the MERCHANDISE and one copy of the PINK-SHEET.

4. Place one part of the PINK-SHEET in the COMPLETED-SHIPMENTS data

store.