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)

Railway Management System ER Diagram

Railway Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Railway Management System Entity. The entity-relationship diagram of Railway Management System shows all the visual instrument of database tables and the relations between Booking, Trains, Stations, Employee etc. It used structure data...
Metro Rail Ticket Booking System ER Diagram

Metro Rail Ticket Booking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Metro Rail Ticket Booking System Entity. The entity-relationship diagram of Metro Rail Ticket Booking System shows all the visual instrument of database tables and the relations between Routes, Fare, Metro, Stations etc. It used...
Shopping Cart System ER Diagram

Shopping Cart System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Shopping Cart System Entity. The entity-relationship diagram of Shopping Cart System shows all the visual instrument of database tables and the relations between Category, Cart, Products, Orders etc. It used structure data and to define...
Airline Managmenet System ER Diagram

Airline Managmenet System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Airline Managmenet System Entity. The entity-relationship diagram of Airline Managmenet System shows all the visual instrument of database tables and the relations between Passengar, Booking Enquiry, Airlines Booking, Employee etc. It...
Error Tracking System ER Diagram

Error Tracking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Error Tracking System Entity. The entity-relationship diagram of Error Tracking System shows all the visual instrument of database tables and the relations between Tracking, Developer, Error, Project etc. It used structure data and to...
Campus Recruitment System ER Diagram

Campus Recruitment System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Campus Recruitment System Entity. The entity-relationship diagram of Campus Recruitment System shows all the visual instrument of database tables and the relations between College, Job, Student, Qualification etc. It used structure data...
Fast Food Corner Portal ER Diagram

Fast Food Corner Portal ER Diagram

This ER (Entity Relationship) Diagram represents the model of Fast Food Corner Portal Entity. The entity-relationship diagram of Fast Food Corner Portal shows all the visual instrument of database tables and the relations between Items, Receipts, Foods, Bill etc. It used structure data and to...
Restaurent Reservation Management System ER Diagram

Restaurent Reservation Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Restaurent Reservation Management System Entity. The entity-relationship diagram of Restaurent Reservation Management System shows all the visual instrument of database tables and the relations between Employees, Sells, Restaurent,...
Finance Management System ER Diagram

Finance Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Finance Management System Entity. The entity-relationship diagram of Finance Management System shows all the visual instrument of database tables and the relations between Profit, Interest, Day Book, Loaner etc. It used structure data...
Election Management System ER Diagram

Election Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Election Management System Entity. The entity-relationship diagram of Election Management System shows all the visual instrument of database tables and the relations between Candidates, Votes, Elections, poll etc. It used structure data...
Call FreeProjectz WhatsApp FreeProjectz