Health Care Appointment System ER Diagram

Subscribe our YouTube channel for latest project videos and tutorials Click Here

Posted By freeproject on July 17, 2017

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.
Health Care Appointment System ER Diagram
Get 6 diagrams only in 300/- or $6.99 USD.
Call or WhatsApp us on +91-8470010001 for more details.

Project Category

Related Entity Relationship Diagram (ERD)

Inventory Sales System ER Diagram

Inventory Sales System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Inventory Sales System Entity. The entity-relationship diagram of Inventory Sales System shows all the visual instrument of database tables and the relations between Sales, stock, Inverntory Item, Customer etc. It used structure data and...
internet Banking ER Diagram

internet Banking ER Diagram

This ER (Entity Relationship) Diagram represents the model of internet Banking Entity. The entity-relationship diagram of internet Banking shows all the visual instrument of database tables and the relations between Credit, Fund Transfers, Banks, User etc. It used structure data and to define the...
Crime Record Management System ER Diagram

Crime Record Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Crime Record Management System Entity. The entity-relationship diagram of Crime Record Management System shows all the visual instrument of database tables and the relations between Complaints, Charge Sheet, Crime, Criminals etc. It used...
Car Pooling System ER Diagram

Car Pooling System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Car Pooling System Entity. The entity-relationship diagram of Car Pooling System shows all the visual instrument of database tables and the relations between Pooling, Car Routes, Cars, Drivers etc. It used structure data and to define...
Patient Management System  ER Diagram

Patient Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Patient Management System Entity. The entity-relationship diagram of Patient Management System shows all the visual instrument of database tables and the relations between Doctor, Diease, Patient, Medicine etc. It used structure data and...
Doctor Appointment System ER Diagram

Doctor Appointment System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Doctor Appointment System Entity. The entity-relationship diagram of Doctor Appointment System shows all the visual instrument of database tables and the relations between Appointment, Fees, Doctors, Clinics etc. It used structure data...
E-Learning Management System ER Diagram

E-Learning Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of E-Learning Management System Entity. The entity-relationship diagram of E-Learning Management System shows all the visual instrument of database tables and the relations between Students, Fees, Course, Training etc. It used structure...
Coach Management System ER Diagram

Coach Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Coach Management System Entity. The entity-relationship diagram of Coach Management System shows all the visual instrument of database tables and the relations between Coach Number, Train, Coach, Report etc. It used structure data and to...
Medical Diagnostic System ER Diagram

Medical Diagnostic System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Medical Diagnostic System Entity. The entity-relationship diagram of Medical Diagnostic System shows all the visual instrument of database tables and the relations between Tests, Doctors, Medical Reports, Employees etc. It used structure...
Canteen Billing System ER Diagram

Canteen Billing System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Canteen Billing System Entity. The entity-relationship diagram of Canteen Billing System shows all the visual instrument of database tables and the relations between Products, Items, Canteen, Payment etc. It used structure data and to...
Call FreeProjectz WhatsApp FreeProjectz