Specify the entity-relationship diagram for database

Assignment Help Software Engineering

Reference no: EM1372487

We would like to design a database to maintain information about hospital staff, including doctors and nurses, and patients at the hospital. The information we need includes:

* Staff, including their names, addresses and social-security numbers.

* Patients, including their names, addresses, and the name of their insurance company.

* Patients are each assigned to a ward (room).

* Those staff who are nurses are assigned to zero or more wards. Each ward has at least one nurse assigned.

* Those staff who are doctors are assigned to zero or more patients. Patients may or may not have a doctor assigned, and they may have more than one doctor. Patients in the same ward may have different doctors but will always have the same nurse(s).

Specify an entity-relationship diagram for this database. Don't forget to underline key attributes and include arrowheads indicating the multiplicity of relationships. Note that there is no single right answer to this question, although some answers may be better than others.

Reference no: EM1372487

Questions Cloud

Illustrate and explain how each market value of us dollar : illustrate and explain how each of following would affect market value of US dollar. Canada experiences severe deflation. US engages in an expansionary monetary policy.

What is the maximum weight that a massless balloon : The third floor of a house is 6.00 m above street level. How much work is essential to move a 159 kg refrigerator to the third floor.

Discussing us social security system : There're many aspects of the program that can be adjusted. Do you believe that you should be able to choose if you want to contribute and therefore collect Social Security?

Compute the break even point in dollars : Cruz Manufacturing had a very bad year in 2008. For 1st time in its history it operated at a loss. The firm's income statement showed the following results from selling 80,000 units of product:

Specify the entity-relationship diagram for database : Specify the entity-relationship diagram for this database. Do not forget to underline main attributes and include arrowheads indicating multiplicity of relationships.

What is the average power output of the automobile engine : A child, hunting for her favourite horse, is running on the ground around the edge of a stationary merry-go-round. The angular speed of the girl has a constant value of .250 rad/sec.

Determine total demand for plumbers in new york : Wages are specified as dollars per hour of work and L represents number of workers per day. Determine total demand for plumbers in New York.

Would there be any automatic stabilizers government budget : would there be any automatic Stabilizers in government budget. Would re be any distinction between full-employment deficits and actual beget deficit.

Compute the break even point in total sales dollars : A cost behavior analysis indicates that 75 percent of the cost of goods sold are variable, 50 percent of the selling expenses are variable, and 25 percent of the administrative expenses are variable.

User Account

All Pages