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.