Dental Hospital Management ER Diagram

This ER (Entity Relationship) Diagram represents the model of Dental Hospital Management Entity. The entity-relationship diagram of Dental Hospital Management shows all the visual instrument of database tables and the relations between Patient, Nurses, Dental Problems, Medicines etc. It used structure data and to define the relationships between structured data groups of Dental Hospital Management functionalities. The main entities of the Dental Hospital Management are Dental Problems, Patient, Doctors, Nurses, Appointments and Medicines.

Dental Hospital Management entities and their attributes :

• Dental Problems Entity : Attributes of Dental Problems are problem_id, problem_name, problem_type, problem_description
• Patient Entity : Attributes of Patient are patient_id, patient_name, patient_mobile, patient_email, patient_username, patient_password, patient_address,
• Doctors Entity : Attributes of Doctors are doctor_id, doctor_name, doctor_specialist, doctor_mobile, doctor_email, doctor_username, doctor_password, doctor_address
• Nurses Entity : Attributes of Nurses are nurse_id, nurse_name, nurse_duty_hour, nurse_mobile, nurse_email, nurse_username, nurse_password, nurse_address,
• Appointments Entity : Attributes of Appointments are appointment_id, appointment_doctor_id, appointment_number, appointment_type, appointment_date, appointment_description
• Medicines Entity : Attributes of Medicines are medicine_id, medicine_name, medicine_company, medicine_composition, medicine_cost, medicine_type, medicine_dose, medicine_description

Description of Dental Hospital Management Database :

• The details of Dental Problems is store into the Dental Problems tables respective with all tables
• Each entity (Medicines, Doctors, Appointments, Patient, Dental Problems) contains primary key and unique keys.
• The entity Doctors, Appointments has binded with Dental Problems, Patient entities with foreign key
• There is one-to-one and one-to-many relationships available between Appointments, Nurses, Medicines, Dental Problems
• All the entities Dental Problems, Appointments, Doctors, Medicines are normalized and reduce duplicacy of records
• We have implemented indexing on each tables of Dental Hospital Management tables for fast query execution.