Health Care Appointment System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Health Care Appointment System Entity. The entity-relationship diagram of Health Care Appointment System shows all the visual instrument of database tables and the relations between Booking, Customer, Health Care, Test etc. It used structure data and to define the relationships between structured data groups of Health Care Appointment System functionalities. The main entities of the Health Care Appointment System are Health Care, Booking, Appointment, Customer, Medicine and Test.

Health Care Appointment System entities and their attributes :

• Health Care Entity : Attributes of Health Care are health_care_id, health_care_name, health_care_type, health_care_description
• Booking Entity : Attributes of Booking are booking_id, booking_title, booking_type, booking_appointment, booking_date, booking_description
• Appointment Entity : Attributes of Appointment are appointment_id, appointment_doctor_id, appointment_number, appointment_type, appointment_date, appointment_description
• Customer Entity : Attributes of Customer are customer_id, customer_name, customer_mobile, customer_email, customer_username, customer_password, customer_address
• Medicine Entity : Attributes of Medicine are medicine_id, medicine_name, medicine_company, medicine_composition, medicine_cost, medicine_type, medicine_dose, medicine_description
• Test Entity : Attributes of Test are test_id, test_patient_id, test_name, test_type, test_cost, test_report, test_description

Description of Health Care Appointment System Database :

• The details of Health Care is store into the Health Care tables respective with all tables
• Each entity (Test, Appointment, Medicine, Booking, Health Care) contains primary key and unique keys.
• The entity Appointment, Medicine has binded with Health Care, Booking entities with foreign key
• There is one-to-one and one-to-many relationships available between Medicine, Customer, Test, Health Care
• All the entities Health Care, Medicine, Appointment, Test are normalized and reduce duplicacy of records
• We have implemented indexing on each tables of Health Care Appointment System tables for fast query execution.