Read and understand the following case and submit your answer electronically A local hospital of capacity of 70 beds ser
Posted: Sat May 21, 2022 9:49 am
Read and understand the following case and submit your answer
electronically
A local hospital of capacity of 70 beds serves a city of 80,000
in population. The hospital staff includes 18 physicians (doctors)
35 nurses and 22 for administration. The health insurance for the
residents of the city is handled by three insurance companies.
There is no pharmacy in the hospital; the required medications can
be obtained from one local pharmacy in the city. The hospital
provides transportation for the residents using one bus that makes
a route around the city every one hour. The food of the patients is
provided to the hospital by one national company. The hospital
wants to buy an information system that helps it in managing daily
transactions. The hospital management is asking your help.
Develop the entity-relationship diagram to help the management
in designing the database for a new information system
electronically
A local hospital of capacity of 70 beds serves a city of 80,000
in population. The hospital staff includes 18 physicians (doctors)
35 nurses and 22 for administration. The health insurance for the
residents of the city is handled by three insurance companies.
There is no pharmacy in the hospital; the required medications can
be obtained from one local pharmacy in the city. The hospital
provides transportation for the residents using one bus that makes
a route around the city every one hour. The food of the patients is
provided to the hospital by one national company. The hospital
wants to buy an information system that helps it in managing daily
transactions. The hospital management is asking your help.
Develop the entity-relationship diagram to help the management
in designing the database for a new information system