Patient Information 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 Patient Information System Entity. The entity-relationship diagram of Patient Information System shows all the visual instrument of database tables and the relations between Treatments, Doctors, Tests, Medicines etc. It used structure data and to define the relationships between structured data groups of Patient Information System functionalities. The main entities of the Patient Information System are Tests, Treatments, Reports, Doctors, Patient and Medicines.

Patient Information System entities and their attributes :

  • Tests Entity : Attributes of Tests are test_id, test_patient_id, test_name, test_type, test_cost, test_report, test_description
  • Treatments Entity : Attributes of Treatments are treatment_id, treatment_name, treatment_type, treatment_description
  • Reports Entity : Attributes of Reports are report_id, report_title, report_type, report_description
  • Doctors Entity : Attributes of Doctors 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,
  • Medicines Entity : Attributes of Medicines are medicine_id, medicine_name, medicine_company, medicine_composition, medicine_cost, medicine_type, medicine_dose, medicine_description

Description of Patient Information System Database :

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

Library Management System ER Diagram

Library Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Library Management System Entity. The entity-relationship diagram of Library Management System shows all the visual instrument of database tables and the relations between Books, Librarian, Student, Address etc. It used structure data...
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...
Eye Care Appoitment System ER Diagram

Eye Care Appoitment System ER Diagram

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...
Courier Management System ER Diagram

Courier Management System ER Diagram

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

Car Rental System ER Diagram

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

Shoe Shop Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Shoe Shop Management System Entity. The entity-relationship diagram of Shoe Shop Management System shows all the visual instrument of database tables and the relations between Shopping Cart, Product, Shoe, Payment etc. It used structure...
Employee Management System ER Diagram

Employee Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Employee Management System Entity. The entity-relationship diagram of Employee Management System shows all the visual instrument of database tables and the relations between Salary, Experience, Employee, Attendance 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...
Hall Booking System ER Diagram

Hall Booking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Hall Booking System Entity. The entity-relationship diagram of Hall Booking System shows all the visual instrument of database tables and the relations between Booking, Customers, Hall, Bill etc. It used structure data and to define the...
Enrollment System ER Diagram

Enrollment System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Enrollment System Entity. The entity-relationship diagram of Enrollment System shows all the visual instrument of database tables and the relations between Student, Fees, Enrollment, Login etc. It used structure data and to define the...
Call FreeProjectz WhatsApp FreeProjectz