Electronic Health Records (EHR) System for Improved Patient Data Management 1. Introduction Electronic Health Records (EHR) systems are digital versions of patients’ paper charts. They make information available instantly and securely to authorized users. In many healthcare facilities, paper-based systems lead to inefficiencies such as data duplication, difficulty in record retrieval, and loss of important information. This project aims to design a simple EHR system that securely stores and retrieves patient data, ensuring accuracy and easy accessibility. 2. Objectives • Digitize patient records for easy access and update. • Improve accuracy in patient information handling. • Enhance data security and reduce duplication. • Enable quick retrieval of medical history. 3. System Design a. Database Design The EHR system is designed around a relational database that stores and manages patient, visit, doctor, and medication information. Below are the main tables included in the system: • Patients (PatientID, Name, DOB, Gender, ContactInfo) • Visits (VisitID, PatientID, Date, Diagnosis, Treatment) • Doctors (DoctorID, Name, Specialty) • Medications (MedicationID, Name, Dosage, Frequency) b. Relationships • One patient can have many visits. • One doctor can attend to many visits. • Each visit can include multiple medications. 4. Tools and Technologies • SQL Server / MS Access for database creation. • Power BI or Excel for visualization. • Microsoft Word for documentation. • Python or ODK for data entry form simulation (optional). 5. Data Security • Password-protected system access. • Role-based access control (Admin, Doctor, Clerk). • Regular data backups (weekly incremental backups). 6. Expected Outcome • Easier patient record retrieval. • Reduced duplication of data. • Enhanced reporting and analysis of patient trends. 7. Conclusion The proposed EHR system provides an efficient and secure way to manage patient data. By transitioning from paper to digital records, healthcare facilities can improve accuracy, enhance data security, and ensure timely access to patient information, ultimately leading to better healthcare outcomes.