Consider a hospital in which each doctor is responsible for many patients while each patient is cared for by just one doctor. Each doctor has a unique employee number, name, telephone number, and office number. Each patient has a unique patient number, name, home address, and home telephone number.

a. What kind of relationship is there between doctors and patients?

b. Develop sample doctor and patient data and construct two files in the style of Figure 3.5 in which to store your sample data.

c. Do any fields have to be added to one or the other of the two files to record the relationship between doctors and patients? Explain.

d. Merge these two files into one, in the style of Figure 3.6. Does this create any problems with the data? Explain.

FIGURE 3.5 Three files with redundant data Customer Number 2746795 Customer Number 2746795 Customer Number 2746795 Sales file Customer Name Customer Address John Jones 123 Elm Street Accounts Receivable file Customer Customer Name Address John Jones 123 Elm Street Credit file Customer Customer Name Address John Jones 123 Elm Street FIGURE 3.6 Three files with a data integrity problem Customer Number 2746795 Customer Number 2746795 Customer Number 2746795 Sales file Customer Address John Jones 456 Oak Street Accounts Receivable file Customer Name Customer Name John Jones Credit file Customer Name John Jones Customer Address 456 Oak Street Customer Address 123 Elm Street