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 redundont doto Sales file Customer Customer Address Numbe Nome 2746795 John Jones 123 Elm Street, ACcounts Receivable file Customer Customer Customer Number Address Nome 2746795 John Jones 123 Elm Street Credit file Customer Customer Customer Address Numbe Nome 2746795 John Jones 123 Elm Street FIGURE 3.6 Three files with a dataintegrity problem Soles file Customer Customer Customer Number Address Nome 2746795 John Jones 456 Oak Street Accounts Receivable file Customer Customer Customer Number Address Name 2746795 John Jones 456 Oak Street Credit file Customer Customer Customer Nome Number 2746795 John Jones 23 Elm Street