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)

Placement Office Automation ER Diagram

Placement Office Automation ER Diagram

This ER (Entity Relationship) Diagram represents the model of Placement Office Automation Entity. The entity-relationship diagram of Placement Office Automation shows all the visual instrument of database tables and the relations between Users, Resumes, Placements, Registration etc. It used...
Library Inventory System ER Diagram

Library Inventory System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Library Inventory System Entity. The entity-relationship diagram of Library Inventory System shows all the visual instrument of database tables and the relations between Store, Author, Student, Address etc. It used structure data and to...
Graphical Payroll System ER Diagram

Graphical Payroll System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Graphical Payroll System Entity. The entity-relationship diagram of Graphical Payroll System shows all the visual instrument of database tables and the relations between Payment, Salary Slips, Salary, Login etc. It used structure data...
Laboratory Inventory System ER Diagram

Laboratory Inventory System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Laboratory Inventory System Entity. The entity-relationship diagram of Laboratory Inventory System shows all the visual instrument of database tables and the relations between Annotate Items, Maintenance, Items, Record Information etc....
Hostel Management System ER Diagram

Hostel Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Hostel Management System Entity. The entity-relationship diagram of Hostel Management System shows all the visual instrument of database tables and the relations between Beds, Rent, Hostel, Payments etc. It used structure data and to...
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...
Student Feeback System ER Diagram

Student Feeback System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Student Feeback System Entity. The entity-relationship diagram of Student Feeback System shows all the visual instrument of database tables and the relations between Feedback, Faculty, Student, Subject etc. It used structure data and to...
Parking System ER Diagram

Parking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Parking System Entity. The entity-relationship diagram of Parking System shows all the visual instrument of database tables and the relations between Vehicles, Duration, Parking Slots, Customers etc. It used structure data and to define...
Decision Support System ER Diagram

Decision Support System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Decision Support System Entity. The entity-relationship diagram of Decision Support System shows all the visual instrument of database tables and the relations between Information, Projects, Decision, Researcher etc. It used structure...
Student Evolution System ER Diagram

Student Evolution System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Student Evolution System Entity. The entity-relationship diagram of Student Evolution System shows all the visual instrument of database tables and the relations between Exams, Results, Student, Merit List etc. It used structure data and...
Call FreeProjectz WhatsApp FreeProjectz