Entity Relationship Diagram Assignment Read and understand the following case and submit your answer electronically A lo

[answerhappygod]

Entity Relationship Diagram Assignment Read And Understand The Following Case And Submit Your Answer Electronically A Lo 1 (42.54 KiB) Viewed 12 times

Entity Relationship Diagram Assignment 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