Clinic 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 Clinic Appointment System Entity. The entity-relationship diagram of Clinic Appointment System shows all the visual instrument of database tables and the relations between Patient, Booking, Clinic, Doctor Schedule etc. It used structure data and to define the relationships between structured data groups of Clinic Appointment System functionalities. The main entities of the Clinic Appointment System are Clinic, Patient, Doctors, Booking, Appointments and Doctor Schedule.

Clinic Appointment System entities and their attributes :

  • Clinic Entity : Attributes of Clinic are clinic_id, clinic_doctor_id, clinic_name, clinic_place, clinic_type, clinic_description, clinic_address
  • 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
  • Booking Entity : Attributes of Booking are booking_id, booking_patient_id, booking_number, booking_type, booking_appointment, booking_date, booking_description
  • Appointments Entity : Attributes of Appointments are appointment_id, appointment_doctor_id, appointment_number, appointment_type, appointment_date, appointment_description
  • Doctor Schedule Entity : Attributes of Doctor Schedule are doctor_schedule_id, doctor_schedule_time, doctor_schedule_type, doctor_schedule_date, doctor_schedule_description

Description of Clinic Appointment System Database :

  • The details of Clinic is store into the Clinic tables respective with all tables
  • Each entity (Doctor Schedule, Doctors, Appointments, Patient, Clinic) contains primary key and unique keys.
  • The entity Doctors, Appointments has binded with Clinic, Patient entities with foreign key
  • There is one-to-one and one-to-many relationships available between Appointments, Booking, Doctor Schedule, Clinic
  • All the entities Clinic, Appointments, Doctors, Doctor Schedule are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Clinic Appointment System tables for fast query execution.
Clinic 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)

Login System ER Diagram

Login System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Login System Entity. The entity-relationship diagram of Login System shows all the visual instrument of database tables and the relations between Password, Programmer, Username, Permission etc. It used structure data and to define the...
Inventory Management System ER Diagram

Inventory Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Inventory Management System Entity. The entity-relationship diagram of Inventory Management System shows all the visual instrument of database tables and the relations between Customer, Stock, Inventory, Supplier etc. It used structure...
University Bulletin Board ER Diagram

University Bulletin Board ER Diagram

This ER (Entity Relationship) Diagram represents the model of University Bulletin Board Entity. The entity-relationship diagram of University Bulletin Board shows all the visual instrument of database tables and the relations between University News, News Category, University, Result News etc. It...
CD DVD Library Management System ER Diagram

CD DVD Library Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of CD DVD Library Management System Entity. The entity-relationship diagram of CD DVD Library Management System shows all the visual instrument of database tables and the relations between Movies, Customer, CD DVD, Booking etc. It used...
Pharmacy Management System ER Diagram

Pharmacy Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Pharmacy Management System Entity. The entity-relationship diagram of Pharmacy Management System shows all the visual instrument of database tables and the relations between Medicines, Company, Pharmacy, Sells etc. It used structure data...
Live Photo Galary Portal ER Diagram

Live Photo Galary Portal ER Diagram

This ER (Entity Relationship) Diagram represents the model of Live Photo Galary Portal Entity. The entity-relationship diagram of Live Photo Galary Portal shows all the visual instrument of database tables and the relations between Types, Categories, Images, Uploads etc. It used structure data and...
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...
Mobile Shop Management System ER Diagram

Mobile Shop Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Mobile Shop Management System Entity. The entity-relationship diagram of Mobile Shop Management System shows all the visual instrument of database tables and the relations between Customers, Sells, Mobile, Stock etc. It used structure...
Travel Management System ER Diagram

Travel Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Travel Management System Entity. The entity-relationship diagram of Travel Management System shows all the visual instrument of database tables and the relations between Customer, Bookings, Travel Agency, Payments etc. It used structure...
Jwellary Shoping System ER Diagram

Jwellary Shoping System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Jwellary Shoping System Entity. The entity-relationship diagram of Jwellary Shoping System shows all the visual instrument of database tables and the relations between Supplier, Sale, Customer, Stock etc. It used structure data and to...
Call FreeProjectz WhatsApp FreeProjectz