Answer to Question #195359 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. You are required to identify the entities for the above scenario. 

Q2. You are also required to identify the attributes of each entity which is already identified in the above Q1.

Answer 1

UML diagrams

USECASE DIAGRAM

E- R diagram for the appointment application.

Patients request for an appointment for any doctor. The details of the existing patients are retrieved by the system. New patients update their details in the system before they request for an appointment with the help of an assistant. The assistant confirms the appointment based on the availability of free slots for the respective doctors and the patient is informed. The assistant may cancel the appointment at any time.