Page 247 -

214 Part 3 • the analysis Process

Figure 8.4
Data structure example for adding
a customer order at World’s Trend Customer Order =
Customer Number +
Catalog Division. Customer Name +
Address +
Telephone +
Catalog Number +
Order Date +
{Available Order Items} +
Merchandise Total +
(Tax) +
Shipping and Handling +
Order Total +
Method of Payment +
(Credit Card Type) +
(Credit Card Number) +
(Expiration Date)
Customer Name =
First Name +
(Middle Initial) +
Last Name
Address =
Street +
(Apartment) +
City +
State +
Zip +
(Zip Expansion) +
(Country)
Telephone =
Area Code +
Local Number

Available Order Items = Quantity Ordered +
Item Number +
Item Description +
Size +
Color +
Price +
Item Total
Method of Payment =
[Check Charge Money Order]
Credit Card Type = [World’s Trend American Express MasterCard Visa]

2. Codes to identify the status of master records, such as whether an employee is active
(currently employed) or inactive. Such codes can be maintained on files that produce tax
information.
3. Transaction codes are used to identify types of records when a file contains different record
types. An example is a credit file containing records for returned items as well as records of
payments.
4. Repeating group entries containing a count of how many items are in the group.
5. Limits on the number of items in a repeated group.
6. A password used by a customer accessing a secure website.
Figure 8.5 is an example of the data structure for a CUSTOMER BILLING STATEMENT,
one showing that the ORDER LINE is both a repeating item and a structural record. The ORDER
LINE limits are from 1 to 5, indicating that the customer may order from one to five items on this
screen. Additional items would appear on subsequent orders.