A

Project Report on

MEDICAL ADMISSSION AND REVENUE SYSTEM

Submitted in partial fulfilment of the requirements for

The Award of the Degree of

BACHELOR OF TECHNOLOGY
In
COMPUTER SCIENCE AND ENGINEERING
By
V.SAI AKSHITHA -23K81A05K0
Under the esteemed guidance of

Mrs. K. BHARGAVI
ACADEMIC YEAR : 2024-
25 ASSISTANT PROFESSOR
DEPARTMENT OF CSE

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

St. MARTIN’S ENGINEERING COLLEGE

UGC AUTONOMOUS
NBA & NAAC A+ Accredited
Dhulapally, Secunderabad – 500
100
 St. MARTIN'S ENGINEERING COLLEGE
UGC Autonomous

Accredited by NBA & NAAC A+

Dhulapally, Secunderabad-500 100
www.smec.ac.in

Certificate

This is to certify that the project entitled "MEDICAL ADMISSSION AND REVENUE

SYSTEM " is being submitted by “V. SAI AKSHITHA (23K81A05K0)” in fulfilment of the

requirement for the award of degree of BACHELOR OF TECHNOLOGY IN

COMPUTER SCIENCE AND ENGINEERING is recorded bonafide work carried out by

them. The result embodied in this report have been verified and found satisfactory.

Project Internal Examiner Signature of HOD

Mrs K. BHARGAVI Dr. R. SANTHOSH KUMAR
Assistant Professor Professor and Head of Department of CSE
Department of CSE
 St. MARTIN'S ENGINEERING COLLEGE
UGC Autonomous

Accredited by NBA & NAAC A+

Dhulapally, Secunderabad-500
100 www.smec.ac.in

DEPARTMENT OF COMPUTER SCIENCE AND

ENGINEERING

DECLARATION

I, the student of “Bachelor of Technology in Department of Computer Science and

Engineering”, session: 2023 - 2027, St. Martin’s Engineering College, Dhulapally,
Kompally, Secunderabad, here by declare that the work presented in this project work
entitled “MEDICAL ADMISSSION AND REVENUE SYSTEM” is the outcome of my
own bonafide work and is correct to the best of my knowledge and this work has been
undertaken taking care of Engineering Ethics. This result embodied in this project report
has not been

V. SAI AKSHITHA -23K81A05K0

 ACKNOWLEDGEMENT

The satisfaction and euphoria that accompanies the successful completion of any task would
be incomplete without the mention of the people who made it possible and whose
encouragement and guidance have crowded my efforts with success.
First and foremost, I would like to express my deep sense of gratitude and indebtedness to my
College Management for their kind support and permission to use the facilities available in
the Institute.

I especially would like to express my deep sense of gratitude and in debtedness to

Dr.P.SANTOSH KUMAR PATRA, Group Director, St. Martin’s Engineering College
Dhulapally, for permittingus to undertake this project.

I wish to record my profound gratitude to Dr.M. SREENIVAS RAO, Principal, St. Martin’s
Engineering College, for his motivation and encouragement.

I am also thankful to Dr. R. SATHOSH KUMAR Head of the Department, Computer

Science and Engineering, St.Martin’s Engineering College,Dhulapally, Secunderabad for his
support and guidance through out my project.

I would like to express my sincere gratitude and indebtedness to my project supervisor

Mrs K. BHARGAVI, Assistant Professor, Department of Computer Science and Engineering,
St.Martin’s Engineering College, Dhulapally, for his support and guidance throughout my
project.

Finally, I express thanks to all those who have helped me successfully completing this
project. Furthermore, I would like to thank my family and friends for their moral support and
encouragement. I express thanks to all those who have helped me in successfully completing
the project.

V. SAI AKSHITHA -23K81A05K0

 CONTENTS

CHAPTER 1-ABSTRACT 6

CHAPTER 2- INTRODUCTION 7

CHAPTER 3-SYSTEM ANALYSIS 8

CHAPTER 4- REQUIREMENT SPECIFICATION 10

CHAPTER 5-ER DIAGRAM. 11

CHAPTER 6- ALGORITHM 12
CHAPTER 7-SOURCE CODE 14
CHAPTER 8-EXPERIMENTAL RESULTS 17

CHAPTER 9- CONCLUSION 18

CHAPTER 10-FUTURE ENHANCEMENTS 19

CHAPTER 11-REFERENCES 20

v
 1. ABSTRACT

Hospital Registration and Billing Management System (HRBMS) is a comprehensive

software solution designed to streamline and automate the processes related to patient
registration, appointment scheduling, and billing within a hospital setting. This system
aims to enhance efficiency, accuracy, and patient satisfaction by integrating various
functionalities into a unified platform.

Key features of HRBMS include:

1. Patient Registration:Facilitates easy registration of patients upon their

arrival at the hospital, capturing essential details such as personal
information, medical history, and insurance details.

2. Appointment Scheduling:Enables patients to schedule appointments

with doctors or specialists based on their availability and the patient’s
convenience. It also allows for the rescheduling or cancellation of
appointments as needed.

3. Billing and Invoicing:Automates the generation of bills for services

rendered to patients, including consultations, treatments, and
procedures. It supports integration with insurance providers for
seamless claims processing.

4. Medical Records Management:Maintains electronic health records

(HER) securely, ensuring accessibility to authorized healthcare
providers while adhering to data privacy regulations.
 5. Reporting and Analytics:Provides insights through comprehensive reports and
analytics on patient flow, revenue generation, and operational efficiency,
aiding in strategic decision-making and resource allocation.

6. Integration and Scalability: Designed to integrate with existing hospital

management systems and scalable to accommodate future expansions or
modifications in healthcare services.

HRBMS aims to reduce administrative overheads, minimize errors in patient

data management, and improve overall operational efficiency within hospital
administrations. By leveraging technology, it facilitates better patient care and ensures
a seamless healthcare experience for both patients and healthcare providers.
 2. INTRODUCTION

The database Is practically applicable in the real time for hospitals which are
likely to implement an integrated account of patient’s expenses within a single
account.With some facts and researches, the project “Hospital’s Registration and
Billing Management System” is an integrated management system that helps to
record the patient’s expenses on different heads from three different expense
points, namely pharmacy, cafeteria and tests, of a hospital. It is not in use in real
time as a whole, but different parts of this system comprise the current practices
in three existing Hospitals; OM Hospital, Chabahil, Teaching Hospital,
Maharajgunj, and Shivatara Hospital, Mahalaxmisthan. This project tired to
combine the bills of a patient in a single database, such that the necessary data
can be easily accessed from the database.

In the realm of database management systems (DBMS), a Hospital’s Registration

and Billing n.Management System plays a pivotal role in ensuring efficient
healthcare service delivery and financial operations. This system integrates
various functionalities crucial for managing patient registrations, medical records,
and billing processes within a hospital or healthcare facility.

The Database consists of 7 tables; employee, patient, doctor, check, pharmacy,

caféteria and tests. The table ‘employee’ consists of the information regarding the
employee who had registered the patient. ‘patient’ consists of the basic data about
the patient. ‘doctor’ consists of the information about doctor. ‘check’ consists
information on which doctor checked which patient on which date. ‘pharmacy’
consists of data about the pharmaceuticals purchased on patient’s account.
‘cafeteria’ consists of data about the orders of food and drinks made on patient’s
account. And finally, ‘tests’ table records the data about the test hired by the
patient. In this way the entire billing system is integrated within a single database.
Database Design Considerations:

Entity-Relationship Model (ERM): Defines entities like patients, doctors,

appointments, and payments, along with their relationships.
Normalization: Ensures data is organized efficiently to minimize redundancy and
dependency issues.
Data Integrity: Implements constraints and validation rules to maintain accurate
and reliable data. Security: Implements access controls to protect sensitive patient
information from unauthorized access.
 3. SYSTEM ANALYSIS

System analysis in the context of a Hospital’s Registration and Billing Management

System involves a comprehensive assessment and understanding of the system’s
requirements, processes, and functionalities. Here’s how system analysis is approached
in DBMS:

1. Requirement Gathering:

- Stakeholder Interviews:Engage with hospital administrators, healthcare providers,

billing staff, and IT personnel to identify their needs and expectations from the system.
- Documentation Review: Study existing procedures, forms, and workflows related to
patient registration, billing, and financial management.
- Use Case Analysis:Identify typical scenarios and interactions within the system (e.g.,
patient registration, appointment scheduling, billing process).

2. Data Analysis:

- Data Modeling:Develop an Entity-Relationship Diagram (ERD) to depict entities (e.g.,

patients, doctors, appointments), their attributes, and relationships.
- Normalization:Analyze data to ensure it is structured efficiently (1st to 3rd normal forms)
to minimize redundancy and dependency issues.
- Data Integrity:Define integrity constraints (e.g., primary keys, foreign keys) to maintain
accuracy and consistency of data.

3. Functional Requirements:

- Feature Identification:List down core features such as patient registration,

appointment scheduling, billing, insurance management, and reporting.
- User Interface Design:Define user interfaces for different user roles (administrators,
doctors, billing staff) ensuring usability and accessibility.
 4. Non-Functional Requirements:

- Performance:Specify requirements for response times, system availability, and

scalability to handle peak loads.
- Security:Define access controls, encryption standards, and audit trails to protect
patient information and comply with regulatory requirements (e.g., HIPAA).
- Reliability:Ensure system reliability through backup strategies, disaster recovery
plans, and fault tolerance measures.

5. System Design
- Architecture Selection:Choose an appropriate architecture (e.g., client-server, cloud-
based) based onscalability and performance requirements.

- Database Design:Implement the database schema based on the ERD, ensuring

efficient data retrieval and manipulation.
- Integration:Plan integration with other systems such as Electronic Health
Records (EHR) and financial systems for seamless data exchange.

6. Implementation and Deployment:

- Deployment Strategy:Plan for phased or full deployment ensuring minimal

disruption to hospital operations.
- Training:Conduct training sessions for users to familiarize them with the new system.

- Transition Planning:Develop a transition plan from existing systems to the new system.

7. Maintenance and Support:

- Monitoring and Optimization:Monitor system performance and optimize

database queries and processes.
- Bug Fixes and Updates:Address issues reported by users and implement system
updates as needed.
- *User Support:Provide ongoing support to users and administrators for
system inquiries and assistance.

By conducting thorough system analysis in DBMS, hospitals can ensure the

Registration and Billing Management System meets operational needs, enhances
efficiency, and improves patient care and financial management.
 4. REQUIREMENT SPECIFICATIONS

4.1 Hardware Requirements:

Hard Disk – 80 GB

Memory – 128 MB of RAM Processor – Intel Pentium

CPU – 1.72 GHz

Front End – PHP5.4.16 Back

4.2 Software Requirements

End -MySQL 8.0.20
Operating System – Windows XP, any Compatible OS
4. ER DIAGRAM
 5. ALGORITHM

Here’s a concise algorithm outline for a hospital registration and billing

management system (HRBMS) in a Database Management System
(DBMS):

User Registration and Login

Function registerUser(username, password, role) {

// Hash the password

// Store the user credentials and role in the database

Function loginUser(username, password) {

// Retrieve the user record from the database
// Verify the password

// Create a session if authentication is successful

Patient Registration
Function registerPatient(name, age, gender, contact_information,
address, emergency_contact) {

// Insert patient details into the Patients table

// Return the patient ID

}
 Appointment Scheduling

Function scheduleAppointment(patient_id, doctor_id, appointment_date,

appointment_time, reason_for_visit) {

// Check if the doctor is available at the given time

// Insert appointment details into the Appointments table

Billing and Payments

Function generateBill(patient_id, services, amount) {

// Insert bill details into the Billing table

Function processPayment(bill_id, payment_date, amount, payment_method) {

// Insert payment details into the Payments table

// Update the payment status in the Billing table

 6. SOURCE CODE

Creating Tables

CREATE DATABASE HospitalDB;

USE HospitalDB;

■P
atients Table
CREATE
TABLE
Patients (
Patient_id INT AUTO_INCREMENT
PRIMARY KEY, Name VARCHAR(100)
NOT NULL,
Age INT NOT NULL,

Gender ENUM(‘Male’, ‘Female’,

‘Other’) NOT NULL,
Contact_information VARCHAR(100)
NOT NULL, Address
VARCHAR(255) NOT NULL,
Emergency_contact VARCHAR(100) NOT NULL
);
■D
octors Table
CREATE
TABLE
Doctors (
Doctor_id INT AUTO_INCREMENT
 PRIMARY KEY, Name VARCHAR(100)
NOT NULL,
Specialty VARCHAR(100) NOT NULL,

Contact_information VARCHAR(100) NOT NULL

);

■A
ppointments Table
CREATE TABLE
Appointments (
Appointment_id INT
AUTO_INCREMENT PRIMARY KEY,
Patient_id INT,
Doctor_id INT,

Appointment_date
DATE NOT NULL,
Appointment_time
TIME NOT NULL,
Reason_for_visit
VARCHAR(255),
FOREIGN KEY (patient_id) REFERENCES
Patients(patient_id), FOREIGN KEY (doctor_id)
REFERENCES Doctors(doctor_id)
)
 Billing Table
CREATE TABLE Billing (
Bill_id INT AUTO_INCREMENT PRIMARY KEY,

Patient_id INT,

Services TEXT NOT NULL,

Amount DECIMAL(10, 2) NOT NULL,

Billing_date DATE NOT NULL,

Payment_status ENUM(‘Paid’, ‘Unpaid’)

NOT NULL, FOREIGN KEY (patient_id)
REFERENCES Patients(patient_id)
);
■P
ayments Table
CREATE
TABLE
Payments (
Payment_id INT AUTO_INCREMENT PRIMARY KEY,

Bill_id INT,

Payment_date DATE
NOT NULL, Amount
DECIMAL(10, 2) NOT
NULL,
Payment_method VARCHAR(50)
NOT NULL, FOREIGN KEY (bill_id)
REFERENCES Billing(bill_id)
);
 Inserting Sample Data
■ Inserting sample data into Patients Table

INSERT INTO Patients (name, age, gender, contact_information, address,

emergency_contact) VALUES
(‘John Doe’, 30, ‘Male’, ‘123-456-7890’, ‘123 Main St, Anytown, USA’,
‘Jane Doe’), (‘Mary Smith’, 25, ‘Female’, ‘987-654-3210’, ‘456 Elm St,
Anytown, USA’, ‘John Smith’);

■ Inserting sample data into Doctors Table

INSERT INTO Doctors (name, specialty,
contact_information) VALUES (‘Dr. Alice Johnson’,
‘Cardiology’, ‘555-123-4567’),
(‘Dr. Bob Brown’, ‘Dermatology’, ‘555-987-6543’);

■ Inserting sample data into Appointments Table

INSERT INTO Appointments (patient_id, doctor_id, appointment_date,
appointment_time, reason_for_visit) VALUES
(1, 1, ‘2024-07-01’, ’10:00:00’, ‘Regular Checkup’),

(2, 2, ‘2024-07-02’, ’11:00:00’, ‘Skin Rash’);

■ Inserting sample data into MedicalRecords Table

INSERT INTO MedicalRecords (patient_id, doctor_id, diagnosis, treatment,

prescription) VALUES (1, 1, ‘Hypertension’, ‘Lifestyle changes, Medication’,
‘Lisinopril’),
(2, 2, ‘Eczema’, ‘Topical cream, Antihistamines’, ‘Hydrocortisone cream’);

■ Inserting sample data into Billing Table

INSERT INTO Billing (patient_id, services, amount,

billing_date,
payment_status) VALUES (1, ‘Consultation, Blood Test’, 150.00, ‘2024-07-
01’, ‘Unpaid’),
(2, ‘Consultation, Skin Test’, 200.00, ‘2024-07-02’, ‘Paid’);

■ Inserting sample data into Payments Table

INSERT INTO Payments (bill_id, payment_date, amount,

payment_method) VALUES (2, ‘2024-07-02’, 200.00, ‘Credit Card’);

Retrieve all patients information

SELECT * FROM Patients;

Retrieve all appointments for a

specific doctor SELECT * FROM
Appointments WHERE doctor_id = 1;
Retrieve medical records for a
specific patient
SELECT * FROM MedicalRecords WHERE patient_id = 1;

Generate a bill for a specific patient

SELECT * FROM Billing WHERE patient_id = 1;

Update payment status for a bill

UPDATE Billing SET payment_status = ‘Paid’ WHERE bill_id = 1;

 7. EXPERIMENTAL RESULTS

Retrieve all patients’ information:

Patient_id. name age gender . contact information. address.

emergency_contact

1 John Doe 30 Male 123-456-7890 . 123 Main St, Anytown,

USA Jane Doe

2 Mary Smith. 25 Female 987-654-3210 456 Elm St, Anytown,

USA. John Smith
 8. CONCLUSION

This document outlines the detailed requirements for the Hospital Registration
and Billing Management System. The implementation of this system will enhance
the efficiency of hospital operations and improve patient care through streamlined
processes and secure management of information.The project is focused towards
creating an integrated billing system for hospital’s patient. It is partially used in
different hospitals right at now, but the combined / integrating database system
has not be fully developed. It is not imaginary project and holds real value if
developed sincerely. In our country where database system is at it’s infant phase,
projects as such is a good sign of striving to move forward. The use of database at
hospitals, especially in the government hospitals will surely make it more
efficient and minimizes the errors that occur from traditional papering system. It
is also a research tool for researchers, and it also helps to identify the subtle health
epidemics.

In conclusion, a Hospital’s Registration and Billing Management System is

essential for modern healthcare facilities to deliver quality care while managing
administrative and financial operations effectively. Proper design and
implementation of the DBMS are crucial for achieving these goals and ensuring
seamless healthcare service delivery.
 9. FUTURE ENHANCEMENTS

Advanced Features

1.1 Integration with Electronic Health Records (HER)

1.2 Description: Integrate with HER systems to provide comprehensive patient

medical histories, lab results, and other critical health data.
Benefits: Enhances the quality of patient care by providing doctors with complete
health information.

1.3 Telemedicine Support

1.4 Description: Implement features for telemedicine consultations,

including video calls, remote monitoring, and virtual
appointments.
Benefits: Increases accessibility for patients, particularly those in remote areas or
with mobility issues.

1.3 Mobile Application

Description: Develop a mobile app for patients and doctors to access

the system on-the-go. Benefits: Improves user convenience and
engagement by allowing easy access to appointments, medical records,
and billing information from mobile devices.
Enhanced Usability
2.1 User Interface Improvements

Description: Revamp the user interface to be more user-friendly,

intuitive, and accessible. Benefits: Reduces training time for staff and
improves overall user satisfaction.
2.2 Multilingual Support

Description: Add support for multiple languages in the system to accommodate

a diverse patient and staff population.
Benefits: Enhances accessibility for non-English-speaking users.
 Data Analytics and Reporting

3.1 Advanced Reporting and Analytics

Description: Implement advanced reporting and analytics features to provide

insights into patient demographics, treatment outcomes, financial performance,
and more.
Benefits: Supports data-driven decision-making and strategic planning for hospital
management.

3.2 Predictive Analytics

Description: Use machine learning algorithms to predict patient outcomes,

hospital readmissions, and resource needs.
Benefits: Proactively improves patient care and resource allocation.

System Integration

4.1 Integration with Insurance Providers

Description: Integrate with insurance provider systems for real-time claim

processing and verification. Benefits: Streamlines the billing process and reduces
delays in payment.
 10.REFERENCES

● https://www.academia.edu/11584015/Hospitals_Registration_and_Billing_
Management_System_ MIS
_Project_with_DFD_

● https://www.geeksforgeeks.org/hospital-management-system-project-in-
software-development/

● https://www.bajajfinserv.in/insights/the-a-z-guide-of-hospital-management-
and-billing-software

● https://mybillbook.in/s/hospital-billing-software/

● https://www.irjmets.com/uploadedfiles/paper//issue_6_june_2023/41592/fi
nal/fin_irjmets168611 9225
.pdf

● https://www.slideshare.net/slideshow/hospital-management-system-project-
report-pdf/267927517

● https://www.bdtask.com/blog/billing-system-in-hospital

● https://www.jain.software/hospital-billing-management-software-hosbill

● https://www.getapp.com/healthcare-
pharmaceuticals-software/hospital-
management/f/billing- invoicing/

● https://kindgeek.com/blog/post/how-to-develop-a-hospital-management-
system