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
2
Explanation:
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?
Similar questions