Consider a hospital in which each doctor is responsible for many patients while each patient is cared
Question:
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.
Applied Statistics and Probability for Engineers
ISBN: 978-1118539712
6th edition
Authors: Douglas C. Montgomery, George C. Runger