U.M. (Mac OS)

Using data from related files 10-37
Example step 1: Plan the system
In addition to booking cruises, EveryWhere Travel sells souvenirs, like
shirts and ship photographs. The company followed the procedure in
“Planning a relational database” on page 10-15 to design the following
database files for tracking and billing the souvenir sales.
1 A Customers file stores information for each customer, including a
unique identification number. When a new customer calls to place an
order, an agent creates a record in the Customers file.
1 A Products file stores information about available products.
One record
per customer