Database Entity Relationship Diagram (ERD) Presentation

Database Entity Relationship Diagram (ERD) Presentation. Database Components Hospital,
Department,
Doctor,
Patients,
Appointments,
Prescriptions,
Medical History,
Lab Test,
Billing,
Follow-Up-Appointment,
Room-Details,
Feed-Back.

1. Focus-Heal Health Care 1

2. Index Objective Scope of work Role of works Entity Relationship Diagram Table Description Specific User Requirements Procedural Constraint 2

3. Objectives Focus-Heal is a diagnostic center connecting Patients with the Right Doctors based on their needs.  3

4. Objectives 4

5. Focus-Heal Health Care 5

6. For Patient Who Come For 6

7. Scope of work This project aims to create a doctor-patient handling management system that will help doctors in their work and will also help patients book doctor appointments and reports. The system also allows the patient to manage their booking slots online manage their information and see which doctor is available as they need. 7

8. Database Components Hospital Department Doctor Patients Appointments Prescriptions Medical History Lab Test Billing Follow-Up-Appointment Room-Details Feed-Back 8

9. Entity Relationship Diagram (ERD) 9

10. Doctor Table The "Doctor" table serves as a crucial component in the Focus-Heal database, capturing essential information about medical practitioners . Doctor Id Name Doctors Qualification Email 10

11. Doctor’s Table 11

12. Specific User’s Requirements Patient registration Patient check out Generation of patient information reports Availability of beds Storage of mandatory patient information Updating patient information 12

13. Procedural Constraint 13

14. Procedural Constraint 14

15. 15

16. 16