Throughout this chapter we use three RMSfiles for examples. The first RMSfile
contains information about magazines offered by a subscription house. This file,
mag, has the following fields:
magazine, 16 character string
magazine code
title, 36 character string
magazine title
year_rate, money
rate for one year's subscription
subscribers, integer
number of subscribers to this magazine
The second RMSfile contains information about each subscriber who receives magazines from the subscription house. This file, sub, has the following fields:
subscriber, 16 character string, key
subscriber code
name, 36 character string
subscriber name
address, two 36 character strings
two lines of street address
city, 32 character string
subscriber city
state, 8 character string
subscriber state
zip, 12 character string
subscriber zip code
The third RMSfile holds the individual magazine subscriptions for each subscriber (one magazine, one subscriber per record). This file, script, has the following fields:
subscriber, 16 character string
subscriber code
magazine, 16 character string
magazine code
issues, integer
number of issues left in subscription
started, date
date subscription was started