Does this create any problems with the data

Assignment Help Basic Computer Science

Reference no: EM131269982

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.6

Reference no: EM131269982

Questions Cloud

Investigate a career in investment banking : Use the Internet to investigate a career in investment banking. [Hint: Good starting places are websites such as The Princeton Review Career Profile,

Prepare a project proposal for anc and maternity tracker : Prepare a Project Proposal for ANC and Maternity tracker. Here, details such as mode of delivery, Apgar score, weight of the baby, conditions of both mother and child at discharge will all be captured.

Define at least two different cultures must be investigated : Use the University Library or other resources to locate three articles relating to culture and marriage/intimacy/family/parenting, in other words social behavior. Write one abstract for each article - If you are unsure of what an Abstract is do lo..

Find the gini index of income concentration for lorenz curve : Interpret the results of Problem with both a graph and a description of the graph.- Find the Gini index of income concentration for the Lorenz curve with equation.

Does this create any problems with the data : 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.

Will the company continue to manufacture the computer : If monthly sales now (t = 0) are 2,000 computers, find S(t). How long, to the nearest month, will the company continue to manufacture the computer?

Describe the purpose of the having clause : Describe the purpose of the HAVING clause. How do you decide whether to place a row-limiting predicate in the WHERE clause or in the HAVING clause?

What is the purpose of the distinct operator : Explain the difference between the SUM and COUNT built-in functions.

The rate of change of the monthly sales : The rate of change of the monthly sales of a new basketball game is given.- Find S(t). When, to the nearest month, will monthly sales reach 15,000 games?

User Account

All Pages