U.M. (Windows)

Using data from related files 10-17
4. For each file, decide which fields will store data and which ones will
use data from other files.
The fields in each database file all store a single occurrence of the
subject of the database file. For example, the fields in the Client file
(client identification number, name, address, and phone number)
together store all the information about one client. Other data can be
combined as needed from other database files.
Based on the file’s subject, you can see where it makes sense to store
the data and where to use stored data from a different file. For
example, you might want to use trip information in a Client file (to
see which clients took which trips), so you could use the Trip fields
in the Client file.
Client file
Route file Trip file