Answer to Question #196100 in Databases | SQL | Oracle | MS Access for TALHA AFZAL

Question

A hospital has Patient Appointment Management System (PAMS), in which all the details of doctors, patients and appointments are given. In this scenario all the details of appointment and patients are shared with the doctor and all the doctors have access to fix and cancel the appointments. Similarly, patients are also authorized to view the doctors list and appointments. Following are the key points of the functionality of PAMS:

⦁ According to the system, patients get the basic information of the doctor, specialization, charges per hour and work hour.

⦁ The system will allow doctors to add/delete and update the schedule.

⦁ The doctors must be able to maintain per visit charges.

.Q1. Construct an Entity Relationship Diagram (ERD) using the identified entities, attributes and mention the valid relationships and cardinality between them.

Answer 1

// UPD