CHAPTER-1: PROBLEM DEFINITION
SYSTEM OBJECTIVES & NEEDS:
The project Family Hospital includes registration of patients, storing their details into the
system, and manual of treatment . The software has the facility to give a unique id for every
patient and stores the details of every patient and the staff automatically. In this site user can
get details of doctor with their spacility. The Family Hospital can be entered using a
username and password.
Traditionally, it was done manually. The main function of the system is to register and store
patient details and doctor details and retrieve these details as and when required, and also to
manipulate these details meaningfully System input contains patient details, diagnosis details;
while system output is to get these details on to the CRT screen.
Human Body is a very complex and sophisticated structure and comprises of millions of
functions. All these complicated functions have been understood by man him, part-by-part
their research and experiments. As science and technology progressed, medicine became an
integral part of the research. Gradually, medical science became an entirely new branch of
science. As of today, the Health Sector comprises of Medical institutions i.e. Hospitals,
HOSPITALs etc. research and development institutions and medical colleges. Thus the
Health sector aims at providing the best medical facilities to the common man.
ADVANTAGES
It is fast, efficient and reliable
Avoids data redundancy and inconsistency
Very user-friendly
Easy accessibility of data
Number of personnel required is considerably less
Provides more security and integrity to data
Our Objectives
l. Doctor Details: The new proposed system stores and maintains all the details of doctor
details.
2. Calculations: The new proposed system calculates salary and income tax automatically
and it is very fast and accurate.
3. Registers: in this website , patient can register himself with giving his full details.
4. Speed: The new proposed system is very fast with 100% accuracy and saves time.
5. Manpower: The new proposed system needs less manpower. Less people can do the
large work.
6. Efficiency: The new proposed systems complete the work of many salesperson in less
time.
7. Past details: The new proposed system contains the details of every past doctor and
patients for future assistance.
8. Reduces redundancy: The most important benefit of this system is that it reduces the
redundancy of data within the data.
9. Work load: Reduces the work load of the data store by helping in easy updates of the
products and providing them with the necessary details together with financial transactions
management.
10. Easy statements: Month-end and day-end statement easily taken out without getting
headaches on browsing through the day end statements.
DATA COLLECTION:
Secondary Data
The Secondary data will be mainly collected from different books, magazines, Journals,
companys Literature, Newspapers, Internet and from the company personnel.
As the datas will be of various types such as comparing based on value as well as the relative
comparison, hence both the tools are to be use for the proper analysis of the datas.
MAGAZINES, JOURNALS AND NEWSPAPERS:
Journals published by business, Annual Report
INTERNET:
[Link]
[Link]
[Link]
[Link]
Chapter-2
System Analysis & Design
(a) Overall Design of the System:
Runni
ng
Proce
ss
User
Report
Details
Hospital Details
Family
Hospital
Family Hospital
with Details
Family Hospital
Database
Services
Process
Enquiry
Details
Contact
Reportin
g
Family
Hospital
Customer
Details
Customer
Maintenan
ce
Customer with
Details
Customer
Enquiry
Record
Database
Enquiry with
Details
(b) Physical Design:
Site Map
Family Hospital
Home
Home
Services
About us
Hospital Facility
Registrati
on
Doctor Details
Send feedback
Infrastructure
details
Treatment Process
(c)
Webpage(s) design for data entry
Doctor Details
Fields
Data Type
Size
Constraints
Doctor Id
Integer
10
Foreign key
name
Varchar2
20
Primary key
Date of Birth
Date
20
Not null
Speciality
Varchar2
30
Not null
Contact No.
Integer
10
Not null
Email Id
Varchar2
10
Not null
Experience
Integer
10
Not null
Enquiry Details
Fields
Data Type
Size
Constraints
Enquiry Id
Integer
10
Foreign key
Patient name
Varchar2
20
Primary key
Enquiry Date
Date
20
Not null
Enquiry For
Varchar2
30
Not null
Date of birth
Date
10
Not null
Address
Varchar2
10
Not null
Contact Details
Integer
10
Not null
User Account Details
Fields
Data Type
Size
Constraints
User_id
Varchar2
10
Foreign key
User_name
Varchar2
20
Primary key
Password
Varchar2
20
Not null
Name
Varchar2
30
Not null
Gender
Varchar2
10
Not null
Dob
Date
Mob no
Varchar2
10
Not null
Address
Varchar2
20
Not null
Not null
(d) Logical Design of Proposed Website:
What is a Flowchart?
According to the Dictionary of Business Charts & Graphs a Flowchart is a visual
representation of the sequence of steps and decisions needed to perform a process.
Each step in the sequence is noted within a diagram shape. Steps are linked by connecting
lines and directional arrows. This allows anyone to view the flowchart and logically follow
the process from beginning to end. Some of the ways to use flowcharts include:
Project planning
Program or system design
Process documentation
Audit a process for inefficiencies or malfunctions
Map computer algorithm etc.
Flowchart Symbols
Flowcharts use special shapes to represent different types of actions or steps in a process.
Lines and arrows show the sequence of the steps, and the relationships among them. These
are known as flowchart symbols. The type of diagram dictates the flowchart symbols that are
used. For most flowcharts, these five basic symbols are always needed:
Some Additional Flowchart Symbols
Symbol
Name
Function
Document
A printed document or report.
Connector
Indicates that the flow continues where a
matching symbol (containing the same letter)
has been placed.
Database
Display
Indicates a list of information with a
standard structure that allows for searching
and sorting.
Indicates a step that displays information.
Flow charts enable groups to clearly define, communicate, and monitor multi-step processes.
Key
Flow Chart
Beginning
Family Hospital
Start
Task Box
Decision
Home
Contact Us
Sign Up
Our Services
Enter Our
Application
Logout
YES
NO
