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)

KBC Quiz System ER Diagram

KBC Quiz System ER Diagram

This ER (Entity Relationship) Diagram represents the model of KBC Quiz System Entity. The entity-relationship diagram of KBC Quiz System shows all the visual instrument of database tables and the relations between Answers, Participants, Questions, Level etc. It used structure data and to define the...
Mobile Phone Billing System ER Diagram

Mobile Phone Billing System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Mobile Phone Billing System Entity. The entity-relationship diagram of Mobile Phone Billing System shows all the visual instrument of database tables and the relations between Customers, Tarrifs, Bills, Payments etc. It used structure...
University Admission Management System ER Diagram

University Admission Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of University Admission Management System Entity. The entity-relationship diagram of University Admission Management System shows all the visual instrument of database tables and the relations between Admission, Subject, University, Degree...
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...
Garment Inventory System ER Diagram

Garment Inventory System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Garment Inventory System Entity. The entity-relationship diagram of Garment Inventory System shows all the visual instrument of database tables and the relations between Inventory, Garments, Brands, Customers etc. It used structure data...
Railway Reservation System ER Diagram

Railway Reservation System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Railway Reservation System Entity. The entity-relationship diagram of Railway Reservation System shows all the visual instrument of database tables and the relations between Ticket, Customer, Train, Train Route etc. It used structure...
Distributed Account Management System ER Diagram

Distributed Account Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Distributed Account Management System Entity. The entity-relationship diagram of Distributed Account Management System shows all the visual instrument of database tables and the relations between Outlet, Credit Report, Transaction, User...
Resume Builder ER Diagram

Resume Builder ER Diagram

This ER (Entity Relationship) Diagram represents the model of Resume Builder Entity. The entity-relationship diagram of Resume Builder shows all the visual instrument of database tables and the relations between Skills, Question, Resume, Salary etc. It used structure data and to define the...
Car Service Center Management System ER Diagram

Car Service Center Management System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Car Service Center Management System Entity. The entity-relationship diagram of Car Service Center Management System shows all the visual instrument of database tables and the relations between Booking, Insurance, Car, Payment etc. It...
Library Information System ER Diagram

Library Information System ER Diagram

This ER (Entity Relationship) Diagram represents the model of Library Information System Entity. The entity-relationship diagram of Library Information System shows all the visual instrument of database tables and the relations between Book Maintenance, Membership Management, Student, Member etc....
Call FreeProjectz WhatsApp FreeProjectz