Sudhir memorial inStitute

doltala, madhyamgram

Computer SCienCe SynopSiS projeCt

aiSSCe: -2024-25
name: - aditya mukherjee
ClaSS: - xii
SeCtion: - a
roll no: - 1
date of SubmiSSion: -
 CertifiCate
THIS IS TO CERTIFY THAT ADITYA MUKHERJEE OF CLASS XII HAS
SUCCESSFULLY COMPLETED HIS COMPUTER SCIENCE PROJECT
TITLED, “CHEMISTRY SCIENCE SYNOPSIS PROJECT”, UNDER THE
GUIDANCE OF MR. SUBHABRATA SARKAR FOR THE ACADEMIC YEAR,
2024-2025. THE CERTIFIED STUDENT HAS BEEN DEDICATED
THROUGHOUT HIS RESEARCH AND HAS COMPLETED HIS WORK
BEFORE THE GIVEN DEADLINE WITHOUT MISSING ANY IMPORTANT
DETAILS OF THE PROJECT. IT IS ALSO CERTIFIED THAT THIS PROJECT IS
THE INDIVIDUAL WORK OF THE STUDENT AND CAN BE SUBMITTED
FOR EVALUATION.

date teaCher’S Sign

 aCknoWledgement
I WOULD LIKE TO EXPRESS MY SINCERE GRATITUDE TO SEVERAL
INDIVIDUALS AND ORGANIZATION FOR SUPPORTING ME
THROUGHOUT THE COMPLETION OF MY PROJECT.
I WISH TO EXPRESS MY SINCERE GRATITUDE TO MY MENTOR MR.
SUBHABRATA SARKAR FOR HIS ENTHUSIASM PATIENCE, INSIGHTFUL
COMMENTS, HELPFUL INFORMATION, PRACTICAL ADVICE AND
UNCEASING IDEAS THAT HAVE HELPED ME TREMENDOUSLY AT ALL
TIMES IN MY PROJECT AND WRITING OF THESE THESIS. HIS IMMENSE
KNOWLEDGE, PROFOUND EXPERIENCE AND PROFESSIONAL EXPERTISE
IN BACKEND HAS ENABLED ME TO COMPLETE THIS PROJECT
SUCCESSFULLY. WITHOUT HIS SUPPORT AND GUIDANCE, THIS
PROJECT WOULD NOT HAVE BEEN POSSIBLE.
THANKS FOR ALL YOUR ENCOURAGEMENT!

date Student’S Sign

 table of Content

INTRODUCTION
1.1 OVERVIEW
1.2 OBJECTIVE
REQUIRMENT AND ANALISIS
2.1 SOFTWARE REQUIREMENTS SPECIFICATION(SRS)
2.1.1 DATA GATHERING
2.1.2 FESIBILITY STUDY
2.1.3 SOFTWARE PROCESS MODEL
2.2 HARDWARE REQUIREMENTS
2.3 SOFTWARE REQUIREMENTS
2.4 JUSTIFICATION OF SELECTION OF TECHNOLOGY
2.4.1 LANGUARE
2.4.2 WHY USING MY SQL
2.5 DATA FLOW(DFD)
2.6 ENTITY RELATIONSHIP DIAGRAM
2.6.1 ENTITY
2.6.2 RELATIONSHIP
2.6.3 ATTRIBUTE
2.7 FLOW CHART
 introduCtion
1.1 OVERVIEW: -
THE PROJECT HOSPITAL MANAGEMENT SYSTEM INCLUDES
REGISTRATION OF PATIENTS, STORING THEIR DETAILS INTO THE
SYSTEM, AND ALSO COMPUTERIZED BILLING IN THE PHARMACY, AND
LABS. THE SOFTWARE HAS THE FACILITY TO GIVE A UNIQUE ID FOR
EVERY PATIENT AND STORES THE DETAILS OF EVERY PATIENT AND
THE STAFF AUTOMATICALLY. IT INCLUDES A SEARCH FACILITY TO
KNOW THE CURRENT STATUS OF EACH ROOM. USER CAN SEARCH
AVAILABILITY OF A DOCTOR AND THE DETAILS OF A PATIENT USING
THE ID. THE HOSPITAL MANAGEMENT SYSTEM CAN BE ENTERED
USING A USERNAME AND PASSWORD. IT IS ACCESSIBLE EITHER BY AN
ADMINISTRATOR OR RECEPTIONIST. ONLY THEY CAN ADD DATA INTO
THE DATABASE. THE DATA CAN BE RETRIEVED EASILY. THE
INTERFACE IS VERY USER-FRIENDLY. THE DATA ARE WELL
PROTECTED FOR PERSONAL USE AND MAKES THE DATA PROCESSING
VERY FAST. HOSPITAL MANAGEMENT SYSTEM IS POWERFUL,
FLEXIBLE, AND EASY TO USE AND IS DESIGNED AND DEVELOPED TO
DELIVER REAL CONCEIVABLE BENEFITS TO HOSPITALS. HOSPITAL
MANAGEMENT SYSTEM IS DESIGNED FOR MULTISPECIALITY
HOSPITALS, TO COVER A WIDE RANGE OF HOSPITAL ADMINISTRATION
AND MANAGEMENT PROCESSES. IT IS AN INTEGRATED END-TO-END
HOSPITAL MANAGEMENT SYSTEM IS A SOFTWARE PRODUCT SUITE
DESIGNED TO IMPROVE THE QUALITY AND MANAGEMENT OF
HOSPITAL MANAGEMENT IN THE AREAS OF CLINICAL PROCESS
ANALYSIS AND ACTIVITY-BASED COSTING. HOSPITAL MANAGEMENT
SYSTEM ENABLES YOU TO DEVELOP YOUR ORGANIZATION AND
IMPROVE ITS EFFECTIVENESS AND QUALITY OF WORK. MANAGING
THE KEY PROCESSES EFFICIENTLY IS CRITICAL TO THE SUCCESS OF
THE HOSPITAL HELPS YOU MANAGE YOUR PROCESSES
1.2 OBJECTIVE: -
• DEFINE HOSPITAL
• RECORDING INFORMATION ABOUT THE PATIENTS THAT COME.
• GENERATING BILLS.
• RECORDING INFORMATION RELATED TO DIAGNOSIS GIVEN TO
PATIENTS.
• KEEPING RECORD OF THE BED PROVIDED TO
CHILDREN/PATIENTS.
 reQuirementS and analySiS

2.1 SOFTWARE REQUIREMENTS SPECIFICATION: -

A SOFTWARE REQUIREMENTS SPECIFICATION (SRS) IS A DETAILED
DESCRIPTION OF A SOFTWARE SYSTEM TO BE DEVELOPED WITH ITS
FUNCTIONAL AND NON-FUNCTIONAL REQUIREMENTS. THE SRS IS DEVELOPED
BASED THE AGREEMENT BETWEEN CUSTOMER AND CONTRACTORS. IT MAY
INCLUDE THE USE CASES OF HOW USER IS GOING TO INTERACT WITH
SOFTWARE SYSTEM.THE SOFTWARE REQUIREMENTS SPECIFICATION
DOCUMENT CONSISTS OF ALL NECESSARY REQUIREMENTS REQUIRED FOR
PROJECT DEVELOPMENT. TO DEVELOP THE SOFTWARE SYSTEM, WE SHOULD
HAVE CLEAR UNDERSTANDING OF SOFTWARE SYSTEM. TO ACHIEVE THIS WE
NEED TO CONTINUOUS COMMUNICATION WITH CUSTOMER TO GATHER ALL
REQUIREMENTS.

2.1.1 DATA GATHERING: -

DATA GATHERING IS THE PROCESS OF GATHERING AND MEASURING
INFORMATION ON VARIABLES OF INTEREST, IN AN ESTABLISHED SYSTEMATIC
FASHION THAT ENABLES ONE TO ANSWER STATED RESEARCH QUESTION,
TEST HYPOTHESES, AND EVALUATE OUTCOMES. THE DATA COLLECTION
COMPONENT OF RESEARCH IS COMMON TO ALL FIELDS OF STUDY INCLUDING
PHYSICAL AND SOCIAL SCIENCE, HUMANITIES, BUSINESS, ETC. DATA
GATHERING TECHNIQUES USED IN THE (SOFTWARE DEVELOPED LIFECYCLE)
SDLC.
2.1.2 FEASIBILITY STUDY: -
THE MEASURE OF HOW BENEFICIAL OR PRACTICAL THE DEVELOPMENT OF
INFORMATION SYSTEM WILL BE TO AN ORGANIZATION. ALONG THIS TOPIC
FEASIBILITY IS MEASURED. SO FAR TAKING THE FEASIBILITY STUDY AND
FEASIBILITY ANALYSIS DURING THE DEVELOPMENT OF THE PROJECT E-
COMMERCE WEBSITE WE HAVE STUDIED ON THE FOLLOWING FOUR MAJOR
CATEGORIES OF FEASIBILITY STUDY.

• OPERATIONAL FEASIBILITY: OPERATIONAL FEASIBILITY IS THE

MEASURE OF HOW WELL A PROPOSED SYSTEM SOLVE THE PROBLEMS. AND
TAKES ADVANTAGE OF THE OPPORTUNITY IDENTIFIED DURING SCOPE
DEFINITION AND HOW IT SATISFIES THE REQUIREMENTS IDENTIFIED IN THE
REQUIREMENTS ANALYSIS PHASE OF SYSTEM DEVELOPMENT.

• TECHNICAL FEASIBILITY: A TECHNICAL FEASIBILITY STUDY ASSESSES

THE DETAILS OF HOW YOU INTEND TO DELIVER A PRODUCT OR SERVICES TO
CUSTOMER. THINK MATERIALS LABOUR, TRANSPORTATION, WHERE YOUR
BUSINESS WILL BE LOCATED AND THE TECHNOLOGY THAT WILL BE
NECESSARY TO BRING ALL THIS TOGETHER.

• ECONOMIC FEASIBILITY: THE DEGREE TO WHICH THE ECONOMIC

ADVANTAGE OF SOMETHING TO BE MADE, DONE, OR FEASIBILITY OF A
SINGLE-PAYER HEALTH SYSTEM. DURING THE DEVELOPMENT OF HOSPITAL
MANAGEMENT SYSTEM WEBSITE. WE HAVE TRIED TO ADDRESS ALL THESE
FEASIBILITY ANALYSIS PHASES SERIOUSLY. THAT’S WHY WE THINK, OUR
PROJECT WILL SUCCEED PROPERLY.
2.1.3 SOFTWARE PROCESS MODEL: -
A WATERFALL UNDER THE SOFTWARE DEVELOPMENT LIFE CYCLE (SDLC) IS
THE METHODOLOGY USED TO PRODUCE ECOMMERCE WEBSITE AND THE
CUSTOMER SELF SHOPPING SYSTEM. IT IS USED BY SYSTEM DEVELOPERS TO
PRODUCE OR ALTER INFORMATION SYSTEMS OR SOFTWARE. IT DIVIDES THE
DEVELOPMENT PROCESS INTO SEVERAL STAGES OR PROCESS. AFTER THE
COMPLETION OF ONE STAGE. IT WILL LOGICALLY MOVE TO ANOTHER STAGE.
SOMETIMES MOVING BACK TO THE PREVIOUS STAGE IS NECESSARY DUE TO
FAILURE THAT OCCURS IN CURRENT STAGE.

REQUIRMENT

ANALYSIS

DESIGN

TESTING

OPERATION
2.2 HARDWARE REQUIREMENT
• PROCESSOR: 2.00 GHZ OR FASTER
• DISK SPACE: 4GB OF AVAILABLE HARD DISK
• RAM: 2GB
• DISPLAY – 1028 X 720 OR HIGHER RESOLUTION
2.3 SOFTWARE REQUIREMENT
• OPERATING SYSTEM: WINDOWS 10 PRO
• WEB BROWSER: GOOGLE CHROME MICROSOFT EDGE
• XAMPP
2.4 JUSTIFICATION OF SELECTION OF TECHNOLOGY
XAMPP IS A FREE AND OPEN-SOURCE CROSS- PLATFORM WEB SERVER
SOLUTION STACK PACKAGE DEVELOPED BY APACHE FRIENDS, CONSISTING
MAINLY OF THE APACHE HTTP SERVER, MARIADB DATABASE, AND
INTERPRETERS FOR SCRIPTS WRITTEN IN THE PHP AND PERL PROGRAMMING
LANGUAGES. IN THIS PROPOSED SYSTEM WE ARE MAINTAINING ALL THE
BASIC FEATURES REQUIRED IN THIS PROJECT.
2.4.2 LANGUAGE
CSS: CASCADING STYLE SHEETS (CSS) IS STYLE SHEET LANGUAGE USED FOR
DESCRIBING THE PRESENTATION
OF A DOCUMENT WRITTEN IN A MARKUP LANGUAGE LIKE HTML. CSS IS A
CORNERSTONE TECHNOLOGY OF
THE WORLD WIDE WEB, ALONGSIDE HTML AND JAVASCRIPT.
BOOTSTRAP: - BOOTSTRAP IS A FREE AND OPEN-SOURCE CSS FRAMEWORK
DIRECTED AT RESPONSIVE,
MOBILE- FIRST FRONT-END WEB DEVELOPMENT. IT CONTAINS CSS AND
JAVASCRIPT BASED DESIGN TEMPLATES
FOR TYPOGRAPHY, FORMS, BUTTONS, MODALS NAVIGATION, AND OTHER
INTERFACE COMPONENTS.

PYTHON: - PYTHON CAN BE USED ON A SERVER TO CREATE WEB

APPLICATIONS. PYTHON CAN BE USED ALONGSIDE SOFTWARE TO CREATE
WORKFLOWS.PYTHON CAN CONNECT TO DATABASE SYSTEMS. IT CAN ALSO
READ AND MODIFY FILES.PYTHON CAN BE USED TO HANDLE BIG DATA AND
PERFORM COMPLEX MATHEMATICS.PYTHON CAN BE USED FOR RAPID
PROTOTYPING, OR FOR PRODUCTION-READY SOFTWARE DEVELOPMENT.

PHP: -PHP IS A SERVER-SIDE SCRIPTING LANGUAGE. THAT IS USED TO

DEVELOP STATIC WEBSITES OR DYNAMIC WEBSITES OR WEB APPLICATION.
PHP SCRIPTS CAN ONLY BE INTERPRETED ON A SERVER THAT HAS PHP
INSTALLED.
2.4.3 DATABASE – MYSQL
MYSQL IS AN OPEN-SOURCE RELATIONAL DATABASE MANAGEMENT
SYSTEM (RDBMS). ITS NAME IS A COMBINATION OF "MY", THE NAME
OF CO-FOUNDER MICHAEL WIDENIUS'S DAUGHTER, AND "SQL", THE
ABBREVIATION FOR STRUCTURED QUERY LANGUAGE. A RELATIONAL
DATABASE ORGANIZES DATA INTO ONE OR MORE DATA TABLES IN
WHICH DATA TYPES MAY BE RELATED TO EACH OTHER; THESE
RELATIONS HELP STRUCTURE THE DATA. SQL IS A LANGUAGE
PROGRAMMER USE TO CREATE, MODIFY AND EXTRACT DATA FROM
THE RELATIONAL DATABASE, AS WELL AS CONTROL USER ACCESS TO
THE DATABASE. IN ADDITION TO RELATIONAL DATABASES AND SQL,
AN RDBMS LIKE MYSQL WORKS WITH AN OPERATING SYSTEM TO
IMPLEMENT A RELATIONAL DATABASE IN A COMPUTER'S STORAGE
SYSTEM, MANAGES USERS, ALLOWS FOR NETWORK ACCESS AND
FACILITATES TESTING DATABASE INTEGRITY AND CREATION
OFBACKUPS.
2.5 data floW diagram (dfd)
DFD IS AN IMPORTANT TOOL USED BY SYSTEM ANALYSIS. A DATA FLOW
DIAGRAM MODEL, A SYSTEM USING EXTERNAL ENTITIES FROM WHICH DATA
FLOWS TO A PROCESS WHICH TRANSFORMS THE DATA AND CREATE OUTPUT
DATA TRANSFORMS WHICH GO TO OTHER PROCESSES OR EXTERNAL ENTITIES
SUCH AS FILES. THE MAIN MERIT OF DFD IS THAT IT CAN PROVIDE AN
OVERVIEW OF WHAT DATA A SYSTEM WOULD PROCESS.
SYMBOLS
A CIRCLE REPRESENTS A PROCESS THAT
TRANSFORMS INCOMING DATA FLOW INTO
OUTGOING DATA FLOWS.

A SQUARE DEFINES A SOURCE OR

DESTINATION OF SYSTEM DATA.

AN ARROW IDENTIFIES DATA FLOW

DIRECTION. IT IS THE PIPELINE THROUGH
WHICH THE INFORMATION FLOWS.

AN OPEN RECTANGLE IS A DATA STORE, DATA

AT REST OR A TEMPORARY REPOSITORY OF DATA.
 0-LEVEL DFD:
IT IS ALSO KNOWN AS A CONTEXT DIAGRAM. IT’S DESIGNED TO BE AN
ABSTRACTION VIEW, SHOWING THE SYSTEM AS A SINGLE PROCESS WITH ITS
RELATIONSHIP TO EXTERNAL ENTITIES. IT REPRESENTS THE ENTIRE SYSTEM
AS A SINGLE BUBBLE WITH INPUT AND OUTPUT DATA INDICATED BY
INCOMING/OUTGOING ARROWS.
CONTEXT LEVEL DFD-0 LEVEL: -

Context leVel diagram

RECEIVER
INFORMATION
DOCTOR/PATIENTDETAILS
HOSPITAL
REQUIST MANAGEMENT ADMIN
DOCTOR/PATI SYSTEM
APPOINTMENT
ENT

CLAIM CONFIRMATION CONFIRM DETAILS

ADMIN SIDE DFD – LEVEL1: -

PATIENT LEVEL 1
DOCTOR LEVEL 1

DOCTOR LEVEL 2
LEVEL 2- ADMIN

PATIENT LEVEL2
2.6 ENTITY RELATIONSHIP DIAGRAM: -
AN ENTITY RELATIONSHIP DIAGRAM (ERD) IS A TYPE OF DIAGRAM THAT LETS
YOU SEE HOW DIFFERENT ENTITIES (E.G., PEOPLE, CUSTOMERS, OR OTHER
OBJECTS) RELATE TO EACH OTHER IN AN APPLICATION OR A DATABASE. THEY
ARE CREATED WHEN A NEW SYSTEM IS BEING DESIGNED SO THAT THE
DEVELOPMENT TEAM CAN UNDERSTAND HOW TO STRUCTURE THE
DATABASE. THEY CAN ALSO BE CREATED ON AN EXISTING SYSTEM TO HELP
THE TEAM UNDERSTAND HOW THE SYSTEM WORKS AND TO FIND AND
RESOLVE ANY ISSUES. ENTITY RELATIONSHIP DIAGRAMS USE A SPECIFIC SET
OF SYMBOLS, SUCH AS SHAPES AND ARROWS, TO DEPICT THE SYSTEM AND
DATABASE. AN ENTITY RELATIONSHIP DIAGRAM IS MADE UP OF MANY
DIFFERENT COMPONENTS:
● ENTITY
● RELATIONSHIP
● ATTRIBUTE
2.6.1 ENTITY
AN ENTITY IS A THING THAT CAN HAVE DATA STORED ABOUT IT. IT CAN BE A
PHYSICAL OBJECT (E.G., CAR, PERSON), A CONCEPT (E.G., ADDRESS) OR AN
EVENT (E.G. STUDENT ENROLMENT IN A COURSE). THEY REPRESENT NOUNS.
THEY ARE USUALLY REPRESENTED AS RECTANGLES ON AN ERD WITH THE
ENTITY NAME INSIDE THE RECTANGLE
2.6.2 RELATIONSHIP
A RELATIONSHIP IN AN ERD DEFINES HOW TWO ENTITIES ARE RELATED TO
EACH OTHER. THEY CAN BE DERIVED FROM VERBS WHEN SPEAKING ABOUT A
DATABASE OR A SET OF ENTITIES. RELATIONSHIPS IN ERDS ARE REPRESENTED
AS LINES BETWEEN TWO ENTITIES, AND OFTEN HAVE A LABEL ON THE LINE
TO FURTHER DESCRIBE THE RELATIONSHIP (SUCH AS “ENROLS”, “REGISTERS”,
“COMPLETES”).
2.6.3 ATTRIBUTE
AN ATTRIBUTE IS A PROPERTY OF AN ENTITY OR SOMETHING THAT CAN BE
USED TO DESCRIBE AN ENTITY. THEY ARE OFTEN REPRESENTED AS OVALS, OR
AS ENTRIES INSIDE AN ENTITY. THERE ARE SEVERAL DIFFERENT TYPES OF
ATTRIBUTES REPRESENTED ON AN ERD:
• SIMPLE: AN ATTRIBUTE THAT CANNOT BE SPLIT INTO OTHER ATTRIBUTES,
SUCH AS A FIRST NAME.22
● COMPOSITE: AN ATTRIBUTE THAT CAN BE SPLIT INTO OTHER ATTRIBUTES,
SUCH AS NAME BEING SPLIT INTO FIRST, MIDDLE, AND LAST NAME.
● DERIVED: AN ATTRIBUTE THAT IS CALCULATED OR DETERMINED FROM
ANOTHER ATTRIBUTE, SUCH AS THE AGE OF RECORD BEING CALCULATED
FROM THE CREATED DATE
 START

HMS

NO
ADMIN
DOCTOR
PATIENT
LOGI
N

NO NO
REG LOGI
LOGI
N
N

VIEW DOCTOR

VIEW PATIENT
MANAGE MANAGE
APPOINTMENT APPOINTMENT
APP.DETAIL T

MANAGE
MANAGE
BILL
MANAGE PRESCRIPTION
DOCTOR

VIEW
PRESCRIPTION

LOGOUT

END
 ConCluSion
IN CONCLUSION, THE HOSPITAL BED MANAGEMENT SYSTEM PROJECT IS
DESIGNED TO OPTIMIZE THE ALLOCATION AND UTILIZATION OF HOSPITAL
BEDS, THEREBY ENHANCING PATIENT CARE AND OPERATIONAL EFFICIENCY.
BY IMPLEMENTING THIS SYSTEM, HOSPITALS CAN ACHIEVE REAL-TIME
TRACKING OF BED AVAILABILITY, STREAMLINE THE ADMISSION AND
DISCHARGE PROCESSES, AND ENSURE BETTER COORDINATION AMONG
MEDICAL STAFF.
THE SYSTEM’S ABILITY TO PROVIDE ACCURATE AND TIMELY INFORMATION
WILL SIGNIFICANTLY REDUCE WAITING TIMES FOR PATIENTS AND IMPROVE
OVERALL HOSPITAL WORKFLOW. ADDITIONALLY, THE INTEGRATION OF DATA
ANALYTICS WILL ENABLE HOSPITAL ADMINISTRATORS TO MAKE INFORMED
DECISIONS REGARDING RESOURCE ALLOCATION AND FUTURE PLANNING.
ULTIMATELY, THE SUCCESSFUL DEPLOYMENT OF THIS PROJECT WILL LEAD
TO IMPROVED PATIENT SATISFACTION, REDUCED OPERATIONAL COSTS, AND
A MORE EFFICIENT HEALTHCARE DELIVERY SYSTEM. AS THE HEALTHCARE
INDUSTRY CONTINUES TO FACE CHALLENGES, THIS INNOVATIVE SOLUTION
WILL POSITION HOSPITALS TO BETTER MEET THE NEEDS OF THEIR PATIENTS
AND ADAPT TO CHANGING DEMANDS.