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)

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

Order Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Order Management System Entity. The entity-relationship diagram of Order Management System shows all the visual instrument of database tables and the relations between Order, update, Product, Product Quality etc. It used structure data...
Recruitment Officer System ER Diagram

Recruitment Officer System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Recruitment Officer System Entity. The entity-relationship diagram of Recruitment Officer System shows all the visual instrument of database tables and the relations between Users, Resumes, Placements, Registration etc. It used structure...
Shop Management System ER Diagram

Shop Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Shop Management System Entity. The entity-relationship diagram of Shop Management System shows all the visual instrument of database tables and the relations between Discounts, Sales, Payments, Inventory etc. It used structure data and...
Mobile Store System ER Diagram

Mobile Store System ER Diagram

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

Golf Scoring System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Golf Scoring System Entity. The entity-relationship diagram of Golf Scoring System shows all the visual instrument of database tables and the relations between Players, Sorts, Golf, Length etc. It used structure data and to define the...
Result Management System ER Diagram

Result Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Result Management System Entity. The entity-relationship diagram of Result Management System shows all the visual instrument of database tables and the relations between Class, Exam, Student, Teacher etc. It used structure data and to...
Car Sharing System ER Diagram

Car Sharing System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Car Sharing System Entity. The entity-relationship diagram of Car Sharing System shows all the visual instrument of database tables and the relations between Customer, Car History,, Booking, Memebership etc. It used structure data and to...
Insurace Policy Enquiry System ER Diagram

Insurace Policy Enquiry System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Insurace Policy Enquiry System Entity. The entity-relationship diagram of Insurace Policy Enquiry System shows all the visual instrument of database tables and the relations between Buyers, Payments, Insurance, User etc. It used...
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...
Call FreeProjectz WhatsApp FreeProjectz