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

Patient Care System entities and their attributes :

  • 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
  • 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

Description of Patient Care System Database :

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

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...
Budget Controlling System ER Diagram

Budget Controlling System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Budget Controlling System Entity. The entity-relationship diagram of Budget Controlling System shows all the visual instrument of database tables and the relations between Employee, Sales, Budget, Login etc. It used structure data and to...
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...
HRD Management System ER Diagram

HRD Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of HRD Management System Entity. The entity-relationship diagram of HRD Management System shows all the visual instrument of database tables and the relations between Trainings, Departments, Employee, Salary slip etc. It used structure data...
Content Management System ER Diagram

Content Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Content Management System Entity. The entity-relationship diagram of Content Management System shows all the visual instrument of database tables and the relations between Content Type, Comment, Content, Web Page etc. It used structure...
Consignment Tracking System ER Diagram

Consignment Tracking System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Consignment Tracking System Entity. The entity-relationship diagram of Consignment Tracking System shows all the visual instrument of database tables and the relations between Track, Delivery, Consignment, Schedule etc. It used structure...
Telephone Directory Management System ER Diagram

Telephone Directory Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Telephone Directory Management System Entity. The entity-relationship diagram of Telephone Directory Management System shows all the visual instrument of database tables and the relations between Contact Details, City Name, New Phone...
Timetable Management System ER Diagram

Timetable Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Timetable Management System Entity. The entity-relationship diagram of Timetable Management System shows all the visual instrument of database tables and the relations between Attendance, Student, Timetable, Teacher etc. It used...
 Product Service Management System ER Diagram

Product Service Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Product Service Management System Entity. The entity-relationship diagram of Product Service Management System shows all the visual instrument of database tables and the relations between Product Service, Delivery, Product, Inventory etc...
Project Planning Management ER Diagram

Project Planning Management ER Diagram

This ER (Entity Relationship) Diagram represents the model of Project Planning Management Entity. The entity-relationship diagram of Project Planning Management shows all the visual instrument of database tables and the relations between Project Issues, Tickets, Projects, login etc. It used...
Call FreeProjectz WhatsApp FreeProjectz