Computer Science, asked by noorulabiyakhan, 8 months ago

Indus hospital has 52 health centers across Pakistan including hospitals, rehabilitation centers, blood banks and clinics. A database is to be designed which meets the requirements of various departments including patients for OPD, IPD, Laboratory, and staff including doctors, surgeons, nursing staff and janitors. Generate relational database tables for each requirements with proper field names, specify primary keys in each table. Also specify which fields needs data validation checks. Discuss, whether the hospital should opt for centralized database or distributed database and why?

Answers

Answered by vinodzala007

Answer:Indus hospital has 52 health centers across Pakistan including hospitals, rehabilitation centers, blood banks and clinics. A database is to be designed which meets the requirements of various departments including patients for OPD, IPD, Laboratory, and staff including doctors, surgeons, nursing staff and janitors. Generate relational database tables for each requirements with proper field names, specify primary keys in each table. Also specify which fields needs data validation checks. Discuss, whether the hospital should opt for centralized database or distributed database and why?

Explanation:

Previous Question

Next Question