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

Eye Care Appoitment System entities and their attributes :

  • Doctor Entity : Attributes of Doctor are doctor_id, doctor_name, doctor_specialist, doctor_mobile, doctor_email, doctor_username, doctor_password, doctor_address
  • Patient Entity : Attributes of Patient are patient_id, patient_name, patient_mobile, patient_email, patient_username, patient_password, patient_address,
  • Test Entity : Attributes of Test are test_id, test_patient_id, test_name, test_type, test_cost, test_report, test_description
  • Spectacles Entity : Attributes of Spectacles are spectacle_id, spectacle_patient_id, spectacle_number, spectacle_type, spectacle_description
  • Appointment Entity : Attributes of Appointment are appointment_id, appointment_doctor_id, appointment_number, appointment_type, appointment_date, appointment_description
  • Booking Entity : Attributes of Booking are booking_id, booking_title, booking_type, booking_appointmnet booking_date, booking_description

Description of Eye Care Appoitment System Database :

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

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 and Travel Management System ER Diagram

Travel and Travel Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Travel and Travel Management System Entity. The entity-relationship diagram of Travel and Travel Management System shows all the visual instrument of database tables and the relations between Transportation, Hotel, Package, Customers etc...
Wedding Planner Management System ER Diagram

Wedding Planner Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Wedding Planner Management System Entity. The entity-relationship diagram of Wedding Planner Management System shows all the visual instrument of database tables and the relations between Planner, Booking, Wedding, Package etc. It used...
Movie Rental System ER Diagram

Movie Rental System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Movie Rental System Entity. The entity-relationship diagram of Movie Rental System shows all the visual instrument of database tables and the relations between Customer, Payment, Movie, Shows etc. It used structure data and to define the...
Payment Management System ER Diagram

Payment Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Payment Management System Entity. The entity-relationship diagram of Payment Management System shows all the visual instrument of database tables and the relations between Bill, Account, Payment, Location etc. It used structure data and...
Library Application System ER Diagram

Library Application System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Library Application System Entity. The entity-relationship diagram of Library Application System shows all the visual instrument of database tables and the relations between Book, Address, Student, Supplier etc. It used structure data...
Laboratory Management System ER Diagram

Laboratory Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Laboratory Management System Entity. The entity-relationship diagram of Laboratory Management System shows all the visual instrument of database tables and the relations between Lab, Update, Student, Point etc. It used structure data and...
Clinic Appointment System ER Diagram

Clinic Appointment System ER Diagram

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...
Employee Attendance System ER Diagram

Employee Attendance System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Employee Attendance System Entity. The entity-relationship diagram of Employee Attendance System shows all the visual instrument of database tables and the relations between Employees, Leave, Attendance, salary etc. It used structure...
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...
Call FreeProjectz WhatsApp FreeProjectz