JAYPEE INSTITUTE OF INFORMATION TECHNOLOGY

15B17CI372 Database Systems and Web

ODD 2024
SYNOPSIS
Healthcare Administration System (HAS)

Submitted to: Ms. Vartika Puri

Submitted by: Dushiyant Chaudhary- 9923103306
Sara Saini - 9923103309
Shikhar Misra - 9923103313
Uday Gangal - 9923103322
 INTRODUCTION
HEALTHCARE ADMINISTRATION MANAGEMENT
SYSTEM
THE HEALTHCARE ADMINISTRATION MANAGEMENT SYSTEM IS A COMPREHENSIVE
WEB-BASED SOLUTION DESIGNED TO EASE THE ADMINISTRATIVE PROCESS WITHIN
HEALTHCARE FACILITIES, SUCH AS HOSPITALS, CLINICS, AND MEDICAL PRACTICES.
IN THE RAPIDLY EVOLVING LANDSCAPE OF HEALTHCARE, THE NEED FOR EFFICIENT
MANAGEMENT OF PATIENT RECORDS, APPOINTMENTS, BILLING, STAFF AND
PRESCRIPTIONS HAS BECOME PARAMOUNT. HAMS AIMS TO ADDRESS THESE NEEDS
BY PROVIDING A CENTRALIZED PLATFORM THAT SIMPLIFIES ADMINISTRATIVE
WORKFLOWS, IMPROVES PATIENT CARE COORDINATION, AND ENHANCES OVERALL
OPERATIONAL EFFICIENCY.

KEY FEATURES:
● PATIENT MANAGEMENT
● APPOINTMENT SCHEDULING
● BILLING AND INVOICING
● STAFF MANAGEMENT
● PRESCRIPTION MANAGEMENT
● REPORTING AND ANALYTICS

WHAT IS WEB DEVELOPMENT?

WEB IMPROVEMENT ALLUDES TO THE MAKING, BUILDING, AND KEEPING UP OF
WEBSITES. IT INCORPORATES VIEWPOINTS SUCH AS WEB PLAN, WEB DISTRIBUTING,
WEB PROGRAMMING, AND DATABASE ADMINISTRATION. IT IS THE CREATION OF AN
APPLICATION THAT WORKS OVER THE WEB I.E. WEBSITES.

WEB ADVANCEMENT CAN BE CLASSIFIED INTO TWO WAYS:

• FRONTEND DEVELOPMENT
• BACKEND DEVELOPMENT

FRONTEND DEVELOPMENT:
THE PORTION OF A SITE WHERE THE CLIENT INTERATOMIC SPECIFICALLY IS NAMED
AS FRONT CONCLUSION. IT IS TOO ALLUDED TO AS THE ‘CLIENT SIDE’ OF THE
APPLICATION.

BACKEND DEVELOPMENT:
BACKEND IS THE SERVER SIDE OF A SITE. IT IS PORTION OF THE SITE THAT CLIENTS
CANNOT SEE AND CONNECTED WITH. IT IS THE PARCEL OF PROGRAM THAT DOES
NOT COME IN COORDINATE CONTACT WITH THE CLIENTS. IT IS UTILIZED TO STORE
AND ORGANIZE DATA.

WHAT IS DATABASE ADMINISTRATION

SYSTEM?
A DATABASE-MANAGEMENT FRAMEWORK IS A COLLECTION OF
INTERRELATED INFORMATION AND A SET OF PROGRAMS TO GET TO THOSE
INFORMATION. THIS IS A COLLECTION OF INTERRELATED INFORMATION WITH AN
CERTAIN MEANING AND CONSEQUENTLY IS A DATABASE. THE COLLECTION OF
INFORMATION, MORE OFTEN THAN NOT ALLUDED TO AS THE DATABASE, CONTAINS
DATA SIGNIFICANT TO AN VENTURE. THE ESSENTIAL OBJECTIVE OF A DBMS IS TO
GIVE A WAY TO STORE AND RECOVER DATABASE AND DATA THAT IS BOTH HELPFUL
AND EFFECTIVE. BY INFORMATION, WE CRUEL KNOWN REALITIES THAT CAN
RECORDED AND THAT HAVE CERTAIN MEANING.
DATABASES TOUCH ALL PERSPECTIVES OF OUR LIVES. A FEW OF THE MAJOR ZONES
OF APPLICATION ARE AS TAKES AFTER:

1. KEEPING MONEY
2. AIRLINES
3. UNIVERSITIES
4. FABRICATING AND SELLING
5. HUMAN RESOURCES
THIS PROJECT WILL BE DEVELOPED USING MODERN WEB TECHNOLOGIES SUCH AS
HTML, CSS, JAVSCRIPT, PHP AND MYSQL TO ENSURE A RESPONSIVE, USER-
FRIENDLY INTERFACE THAT IS ACCESSIBLE ACROSS DIFFERENT DEVICES. THE
BACKEND ARCHITECTURE IS DESIGNED TO HANDLE LARGE DATASETS, ENSURE DATA
SECURITY, AND PROVIDE SEAMLESS INTEGRATION BETWEEN DIFFERENT MODULES.
 Objective
The aim for this project is straight forward: design a Health Management
that can be practical but not complicated. The goal of this website is to
help doctors and patients, and admins too, by giving them secure tools
with which they will be able to manage medical records, set up
appointments, keep track of patient health information, and improve the
interaction of both sides.

Database Development:
1. We are going to establish an efficient database management system
that should be secure and capable of managing patient health records,
appointment schedules, and other relevant health care information.

2. To comply with the rules of healthcare, we will introduce tight

security.

3. We also want to make data searching/reporting tools more efficient to

aid healthcare practitioners in making informed decisions.

Web Development:
1. The web-based interface is user-friendly. That means any device,
whether desktop, tab, or phone, will be able to support it without any
hitch.
2. User login, patient portals, appointment booking, health monitoring
dashboards will be part of that.

3. We stitch it all together, ensuring seamless functionality of the front

end to the backend database so users get accurate and updated
information in real time
 METHODOLOGY

Planning of the Project & Requirement Gathering:

Feasibility Study:
This is followed by the feasibility study, where we check the technical
feasibility, operational feasibility, and financial feasibility. It is at this
stage that early identification of risks and strategizing on how to mitigate
them is done.

System Design:

1) Database Design:
Let us create an ER diagram that will represent how our database is set up
in its entirety. These key entities include but are not limited to patient
information, healthcare providers, appointments, and medical records. We
will also have to define the tables-it is all about their relationship and data
types involved. Proper normalization will help reduce data redundancy.

2) Web Interface Design:

We will create website, making it user-friendly and responsive.
Architecturally, it clearly denotes the front-end, back-end, and API layers.
It means this will make sure that interaction with the database is integrated
and continuous.

Let's also plan a simple navigation structure so that users can quickly reach
features like the patient portal or health dashboard.

Selection of Technology Stack:

1) Database: We would use one of the fine DBMSs, MySQL based on

the requirements for performance and data security.

2) Back-End Development: Now, when it comes to back-end

frameworks, Node.js is in the top category of trending ones.

3) Front-End Development: In the case of front-end development, we

have either html , CSS , PHP. They help in providing responsiveness for
the user experience.

Development:

Database Development:
We would initiate the development of the environment of the database
based on our design document. Stored procedures and triggers will be
prepared for performance optimization-the automation tips can make quite
a lot of difference.
CONCLUSION
BASICALLY, IT WOULD IMPLY MODERNIZING AND STREAMLINING ALMOST
EVERYTHING IN THE HEALTH ADMINISTRATIVE SYSTEM. SUCH SYSTEMS
ATTAIN EFFECTIVENESS THROUGH AUTOMATION OF ADMINISTRATIVE
DUTIES, IMPROVEMENT IN PATIENT CARE DUE TO EFFICIENCY IN
INFORMATION MANAGEMENT, AND MEETING REGULATORY DEMANDS.
THEY MAKE FOR MORE ACCURATE AND TIMELY DECISION-MAKING,
YIELDING BETTER PATIENT OUTCOMES AND OPERATIONAL EFFECTIVENESS.
THE COMPREHENSIVE HEALTH ADMINISTRATIVE SYSTEM WILL ENSURE
BETTER COORDINATION OF HEALTH, REDUCE THE THREAT OF ERRORS, AND
ENHANCE DATA-DRIVEN INSIGHT INTO STRATEGY AND POLICY MAKING.
LATER ON, AS MORE ADVANCED TECHNOLOGIES WITH A FOCUS ON USER
NEEDS ARE IMPLEMENTED, SUCH SYSTEMS WILL REALIZE FULL BENEFIT IN
A CONTINUOUS CHANGING LANDSCAPE OF HEALTHCARE.
 REFERENCE

1) LEARNING PHP, MYSQL & JAVASCRIPT:

WITH JQUERY, CSS & HTML5 BY ROBIN
NIXON

2) RAMAKRISHNAN, GEHRKE, DATABASE

MANAGEMENT SYSTEMS, MCGRAW-HILL, 3RD
EDITION, ADDISON-WESLEY,2006. DEFINITION OF
DATABASE

3) HTTPS://WWW.GEEKSFORGEEKS.ORG/
4) HTTPS://WWW.W3SCHOOLS.COM/