Table of Contents

CERTIFICATION.. ii

DECLARATION.. iii

APPROVAL PAGE. iv

DEDICATION.. v

ACKNOWLEDMENT. vi

ABSTRACT. vii

LIST OF FIGURES. viii

Figure 1.0: List of Figure. viii

ABBREVIATIONS & ACRONYMS. ix

CHAPTER ONE: 1

INTRODUCTION.. 1

1.0 Introduction. 1

1.1 Background of the Study. 1

1.2 Problem Statement 2

1.3 Aim and Objective. 2

1.3.1 Aim: 2

1.3.2 Objectives: 2

1.4 Scope and Limitation. 3

1.4.1 Scope: 3

1.4.2 Limitations: 3

1.5 Significance of the Study. 3

1.6 Definition of Term.. 5

1.7 Gantt Chart (9‑Week Plan). 5

CHAPTER TWO: 6

LITERATURE REVIEW... 6

2.0 Overview.. 6

2.1 Related Literature Review.. 6

2.1.1 Overview of the Related Work (System). 7

2.1.2 Concept of Patient Record Systems for Shirbaline. 8

2.1.3 Comparison of Techniques. 9

2.1.4 Gaps in Existing Work (System). 10

CHAPTER THREE: 12

METHODOLOGY. 12

3.0 Overview.. 12

3.1 Method and Analysis of Existing System.. 13

3.2 Tools Requirement for the Development of the New System.. 13

3.2.1 Software Requirement (VB.Net Version). 13

3.2.2 Hardware Requirement 15

3.3 Software Process Model 15

3.3.1 Why Agile suits VB.NET projects: 16

3.4 Input Specification. 17

3.5 Output Specification. 18

3.5.1 Database Design (Entity Relationship Diagram -ERD). 19

3.6 Use Case Diagram.. 19

Here Is the Complete Use Case Diagram.. 20

3.7 User Interface. 21

CHAPTER FOUR: 23

SYSTEM IMPLEMENTATION.. 23

4.0 Overview.. 23

4.1 Testing Strategies. 24

4.1.1 Unit Testing. 24

4.1.2 System Testing. 25

4.2 System Snapshot 25

4.3 System Maintenance. 30

4.3.1 Maintenance Schedule Summary. 31

4.4 Documentation. 31

4.4.1 Hardware Specification. 31

4.4.2 Software Specification. 32

4.4.3 User Documentation. 32

CHAPTER FIVE: 33

SUMMARY, CONCLUSION AND RECOMMENDATION.. 33

5.0 Summary. 33

5.1 Conclusion. 33

5.2 Recommendation. 33

5.2.1 Lessons Learned. 33

5.2.2 Future Work. 33

REFERENCES. 34

APPENDIX A.. 35

APPENDIX B

CHAPTER ONE:

INTRODUCTION

1.0 Introduction

The project focuses on developing a digital system to manage patient records in Shirbaline Health Care Services, replacing manual documentation with a computerized solution. Healthcare delivery is one of the most data-intensive industries. Every patient encounter produces information such as demographic details, symptoms, diagnoses, prescriptions, laboratory investigations, and billing records. In many developing regions, including Nigeria, these records are predominantly managed manually using paper-based systems. While simple, such systems are inefficient and struggle to keep pace with the growing demand for healthcare services.

Shirbaline Health Care Services, Dutse LGA, Jigawa State, provides critical outpatient and inpatient services to a diverse patient population. As the facility grows, the limitations of paper-based systems have become increasingly evident: files get misplaced, searching for past records takes significant time, and generating summary reports for management is often laborious. Furthermore, confidentiality and data security are compromised because physical files can be accessed by unauthorized individuals.

A Patient Record Management System (PRMS) addresses these challenges by offering a computerized platform for capturing, storing, processing, and retrieving patient records. The adoption of such a system enhances clinical decision-making, ensures data integrity, and reduces duplication of tests and diagnoses. More importantly, the PRMS provides accurate and timely information for administrators, thereby supporting better planning and resource allocation.

The introduction of this project therefore lays the foundation for a transition from a paper-driven system to a digital framework at Shirbaline Health Care Services. It positions the facility in line with global healthcare trends where digitization is not merely an option but a necessity for delivering quality, efficient, and sustainable healthcare.

1.1 Background of the Study

Manual patient registers and disparate notebooks lead to missing files, duplicate numbers, delayed retrieval, and weak analytics. A centralized digital PRMS supports clinical workflows (triage → consultation → labs/imaging → pharmacy → billing), administrative reporting, and compliance (confidentiality, access control, backups).

In modern healthcare, efficient and accurate management of patient records is crucial for quality service delivery. Manual record-keeping systems often lead to misplaced files, duplication of records, and errors that can compromise patient care. The integration of digital solutions in healthcare facilities has become necessary to ensure data accuracy, secure storage, timely access/faster retrieval to medical history, better management of patient information, and proper coordination among healthcare professionals. A Patient Record Management System (PRMS) can streamline administrative processes, reduce paperwork, and improve data retrieval and analysis for better decision-making.

1.2 Problem Statement

a)   Clearly define the problem we are solving:

Shirbaline Health Care still relies on paper-based record systems, which are prone to data loss, inefficiencies, and human error. Our goals are to create systems that make it difficult for retrieve patient histories quickly and can hinder coordination between departments.

b)   Why is this problem significant (real-world)?

Poor record management in Shirbaline Health Care Services can result in misdiagnosis, delays in treatment, and loss of critical information, thereby affecting patient outcomes and overall healthcare efficiency.

c)    Existing methods or baselines:

Some clinics use spreadsheets or local databases with limited functionality, lacking centralized access, backup, and automation features.

1.3 Aim and Objective

1.3.1 Aim:

To develop a centralized Patient Record Management System that enables secure, efficient, and accessible storage and retrieval of patient data.

1.3.2 Objectives:

1.    To design a system for storing and managing patient records digitally

2.    To ensure secure access to patient data based on roles (e.g., doctors, Patients, admin).

3.    To enable quick retrieval of patient history, prescriptions, and visit records.

4.    To ensure data integrity, privacy, and confidentiality of user capability.

1.4 Scope and Limitation

1.4.1 Scope:

The project is focuses on the design and implementation of a Patient Record Management System (PRMS) specifically tailored for Shirbaline Health Care Services, Dutse LGA Jigawa State. The Scope Include:

1. Patient Registration and Record Management:

Capturing and storing patient demographic information such as name, age, gender, address, phone number, and next of kin.

2. Consultation and Clinical Documentation:

Allowing doctors and nurses to maintain electronic records of encounters for continuity of care

3. Security and User Management:

Enforcing role-based access control (RBAC) so that each staff category (Doctor, Admin and Paitent) can only access relevant modules.

1.4.2 Limitations:

a.      No integration with external hospital systems.

b.      No real-time collaboration or mobile app version.

c.       Designed for small- to medium-sized clinics.

d.      Not a system for sending and receiving money, or something else.

1.5 Significance of the Study

The significance of this study lies in its contribution to improving healthcare service delivery at Shirbaline Health Care Services, Dutse LGA, Jigawa State, and by extension, similar healthcare facilities in Nigeria that face challenges associated with manual record-keeping. The following key points highlight the importance of the project:

1. Improved Efficiency and Speed of Service Delivery:

The computerized PRMS reduces the time spent on patient registration, record retrieval, and billing. Instead of searching through stacks of files, staff can retrieve patient data instantly, thereby reducing patient waiting time and improving overall satisfaction.

2. Enhanced Accuracy and Data Integrity:

Manual records are prone to duplication, misplacement, and human error. The PRMS ensures that each patient is assigned a unique hospital number, and information is stored consistently in a database. This improves the reliability of clinical decisions and reduces the risk of medical errors.

3. Support for Clinical Decision-Making:

With complete patient histories available in a centralized system, doctors can make better-informed decisions regarding diagnosis and treatment. This continuity of care is particularly critical for patients with chronic conditions who require frequent visits.

4. Strengthening of Financial Management:

The integration of billing and payment modules enables accurate tracking of services rendered, drugs dispensed, and payments received. This not only reduces revenue leakages but also provides transparency in financial management.

5. Improved Data Security and Confidentiality:

Healthcare data is highly sensitive and requires strict confidentiality. Unlike paper files that can easily be accessed by unauthorized persons, the PRMS uses role-based access control (RBAC) and audit trails to ensure that only authorized staff can access specific data. This aligns with ethical and legal standards of patient privacy.

6. Better Administrative Reporting and Planning:

The system generates real-time reports on patient attendance, disease patterns, laboratory utilization, pharmacy stock levels, and revenue. These reports are essential for management decision-making, resource allocation, and planning future healthcare interventions.

7. Scalability and Future Growth:

As Shirbaline continues to expand its services, the PRMS provides a scalable foundation that can be upgraded to include mobile access, web integration, or even interoperability with national health systems in the future.

In summary, the study is significant because it bridges the gap between manual healthcare records and modern digital solutions, thereby improving patient care, operational efficiency, and administrative oversight.

1.6 Definition of Term

        i.            Billing: Process of calculating and recording payments for services rendered.

      ii.            PRMS:  Patient Record Management System for Shirbaline Health Care Services.

    iii.            HER:  Electronic Health Record for clear documenting.

    iv.            User Roles: Different system access levels based on job roles.

      v.            Data Integrity – Ensuring the accuracy and consistency of data over its lifecycle.

    vi.            Encryption: Technique used to secure data and protect it from unauthorized access.

             1.7 Gantt Chart (9‑Week Plan)

Figure 1.1: Gantt Chart