A
SYNOPSIS
“ONLINE ADMINISTRATIVE SUPPORT SYSTEM FOR MEDICAL INSTITUTION”
Under Supervision of
SUBMITTED BY
NAME:
ENROLMENT NO:
Submitted in partial fulfillment of the requirements of the degree of
“ONLINE ADMINISTRATIVE SUPPORT SYSTEM FOR MEDICAL INSTITUTION”
Under Supervision of :
Submitted By:
Name :
Programme :
Enrollment No. :
Study Centre Code :
- INTRODUCTION & OBJECTIVES OF THE PROJECT
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 Online Administrative Support System for Medical Institution s i.e. Hospitals, Clinics etc. research and development institutions and medical colleges. Thus the Health sector aims at providing the best medical facilities to the common man.
Online Administrative Support System for Medical Institution
Still being a developing nation India has seen a tremendous growth of the Health sector in the field of research as well as in the field of development of numerous large and small scale clinical institutions still lacking in inter-structure facilities. Government of India has still aimed at providing medical facilities by establishing hospital. The basic working of various hospitals in India is still on paper as compared to hospitals in European countries where computers have been put in to assist the hospital personals their work. The concept of automation of the administration and management of hospital is now being implemented in India also, with large hospitals like APPOLO and AIIMS in Delhi, ESCORTS in Chennai, having automated their existing system.
Our project is based on the above concept i.e. automation of Administration and Management of Hospital. The project has been developed keeping in-view the following aspects: –
- Working environment of the Hospital.
- The thought-process and attitude of Indian people.
- The Existing system, being used in the majority of Hospitals.
- The availability of Infra-structural facilities likes finance, skilled personals, and working environment.
- On Line Appointments for the Patients
a) Admission of New Patient
- Free Medical Advice For the Patients
- Discharge Patient Detail Functions
- Doctor Assigning related to Patient’s Disease
- Training Courses Provided by the Hospital
- Statement of Patient Details
a. Admitted Patient
b. Discharged Patient
c. Doctor Details
- Number of Patients admitted in the Hospital
- Doctors available in the Hospital
- Preventive Health Checkups
- Administrator Links
a. Login Form
b. To add new doctors in the site
c. List of patients
d. List of Doctors
- Searching or Enquiry about
Doctors
Patients
Rooms
Discharged Patients
- Password facility for multiple users and Administrator.
- Crystal Reports to print all the details of Patients, doctors, Online users (for free medical advice etc.) so that administrator can work.
- Business services
- Food suppliers
- Medical suppliers
- Other items suppliers
- Placement services
- Near by hotel accommodation for relatives of patients
2. ADVANTAGE
I have designed the given proposed system in the ASP.Net, C#, SQL Server And XML to automate the process of day to day activities of Medical Institutes like Room activities, Admission of New Patient, Discharge of Patient, Assign a Doctor, and finally compute the bill etc., online facilities to the multiple users etc.
The complete set of rules & procedures related to Medical Institute’s day to day activities and generating report is called “ONLINE MEDICAL CONSULATNCY”.
The following steps that give the detailed information of the need of proposed system are:
Performance: During past several decades, the hospital management system is supposed to maintain manual handling of all the hospital daily activities. The manual handling of the record is time consuming and highly prone to error. To improve the performance of the hospital management system, the computerized hospital management system is to be undertaken. The computerized hospital project is fully computerized and user friendly even that any of the hospital’s members can see the patient’s report and the doctor’s report.
Efficiency: The basic need of the project is efficiency. The project should be efficient so that whenever a new patient is admitted, and automatically a bed is assigned and also a doctor is assigned to the patient according to the patient’s disease. And if any patient is getting discharged, the bed assigned to him/her should automatically feed in the computer.
Control: The complete control of the project is under the hands of authorized person who has the password to access this project and illegal access is not supposed to deal with. All the control is under the administrator and the other members have the rights to just see the records not to change any transaction or entry.
Security: Security is the main criteria for the proposed system. Since illegal access may corrupt the database and it will affect not only the hospital but also it also affects the patient’s life. So security has to be given in this project.
3. TOOLS / ENVIRONMENT USED IN THE PROJECT
Tools/Platform used is:
v FRAMEWORK:- ASP.NET version 2 .0 with C#
v DATABASE:- SQL Server
v PLATFORM USED:- Windows XP
S/w Requirement specification:
v .NET framework 2.0
v Visual Studio.NET 2005
v ASP.NET
v ADO.NET
v SQL Server 2005
v Visual C#.NET
v HTML
v XML
v Internet Information Services (IIS) v 5.1
H/w Requirement specification:
v Pentium 3, 1.5 GHz and above
v 256 MB DDRAM or more
v 20 GB HDD
v Pen Drive 2Gb
FRONT END:
- ASP .NET is one of the platforms that are directed towards meeting the objectives of the .NET initiative of creating distributed applications.
- ASP .NET is a powerful object-oriented language that provides features such as abstraction, encapsulation, inheritance, and polymorphism.
Features of ASP.NET
- Some of the key features of Visual Basic .NET are as follows:
- Inheritance
- Constructors and destructors
- Overloading
- Overriding
- Structured exception handling
- Multithreading
BACK END
SQL SERVER
Microsoft SQL Server is an application used to create computer databases for the Microsoft Windows family of server operating systems. It provides an environment used to generate databases that can be accessed from workstations, the web, or other media such as a personal digital assistant (PDA). Microsoft SQL Server is probably the most accessible and the most documented enterprise database environment right now. This also means that you can learn it a little quicker than most other database environments on the market.
4. DATA FLOW DIAGRAM
Data flow diagrams are the most commonly used way of documenting the processing of the candidate system. As their name suggest they are a pictorial way of representing the flow of data into, around, and out of the system.
Context Level DFD
Medical Advice |
Carrier & Job Hospital |
PG Programmer |
Patient Status |
Patient Appointment |
Bill Payment |
ONLINE ADMINISTRATIVE SUPPORT SYSTEM FOR MEDICAL INSTITUTION |
DFD for Medical Advice
Patient |
1. Read the Data from patient |
2. Search for disease from Knowledge |
3. Copy Selected Record |
Output Unit |
Data base
DFD for patient Appointment
USER |
1. Read patient request |
2. Search from Doctor Data base |
3. Give the Time and Number |
Output UNIT |
Database
DFD FOR EYE DONATOR
User |
Screen Print |
Eye Bank |
ONLINE ADMINISTRATIVE SUPPORT SYSTEM FOR MEDICAL INSTITUTION |
Accept the user request for Eye donate |
Request for
Eye Donation
Acknowledge
Request No.
DFD FOR BLOOD DONATOR
User |
Screen Print |
Blood Bank |
ONLINE ADMINISTRATIVE SUPPORT SYSTEM FOR MEDICAL INSTITUTION |
Accept the user request for blood donate |
Request for
Blood Donation
Acknowledge
Request No.
DFD FOR KIDNEY DONATOR
User |
Screen Print |
Kidney Bank |
ONLINE ADMINISTRATIVE SUPPORT SYSTEM FOR MEDICAL INSTITUTION |
Accept the user request for kidney donate |
Request for
Kidney Donation
Acknowledge
Request No.
DFD for Patient Search
Patient |
1. Read the Data from patient |
2. Search the patient in patient-ID |
3. Copy Selected Record |
Output Unit |
Database
DFD for PG Course
Doctor |
1. Accept Data for specializing |
2. Search for Seat Availability |
3. Display the Admission status for PG Course |
Output Unit |
Database
DFD For Bill Payment
Accountant |
1. Read the Patient Data & Treatment |
2. Generate the bill |
Print Bill |
Output Device |
Patient |
DATABASE
DFD For Job Opportunity In hospital
User/
Doctor |
Search the web Site |
Apply Only |
Get Online Id |
Database
DFD For Online Searching For Patient
User |
Read
Patient Name |
Patient Data |
CRT |
Data base
DFD For Searching a Doctors
User |
Read the
Data of Doctor & Specialisation |
Doctor’s
With Specialties |
CRT |
Data Base
DFD Online Medical Advice
User |
Read Patient Data and Disease |
Display the Remedies & Treatments |
Output |
Data Base
DFD For Login Of User
User |
Read User Id & Password |
Authenticate User & Login |
Output |
Data Base
ER-DIAGRAM
5. MODULES
The limited time and resources have restricted us to incorporate, in this project, only the main activities that are performed in news sites, but utmost care has been taken to make the system efficient and user friendly.
For the optimum use of practical time it is necessary that every session is planned. Planning of this project will include the following things:
- Topic Understanding.
- Modular Break – Up of the System.
- Processor Logic for Each Module.
- Database Requirements.
Topic Understanding:
It is vital that the field of application as introduced in the project may be totally a new field. So as soon as the project was allocated to me, I carefully went through the project to identify the requirements of the project.
Modular Break –Up of the System:
- Identify The Various Modules In The System.
- List Them In The Right Hierarchy.
- Identify Their Priority Of Development
- Description Of The Modules:
Description of the Modules:
The basic objective of ONLINE ADMINISTRATIVE SUPPORT SYSTEM FOR MEDICAL INSTITUTION is A WEBSITE to generalize and simplify the monthly or day to day activities of Hospital like Admission of New Patient, Discharge of Patient, and Doctor Assigning related to particular disease of patient, Reports of Number of Patients and Discharged Patients etc. which has to be performed repeatedly on regular basis. To provide efficient, fast, reliable and user-friendly system is the basic motto behind this exercise.
Let us now discuss how different modules handle the structure and data files:
- Password Module
This module is used to login existed users. New users can also become members .Existed user can change the password. Any user can check login status, change his/her password and recover his password.
2. Admission_Patient Module
This module is used to admit a patient in our Hospital after entering his all personal details like Name, Address, Phone, Sex including his/her Disease .Patient can take online appointment
3. Discharge_Patient Module
This module is used to discharge the patient details from database. When the user inputs his bed number, the same patient id will be checked in the database, if the bed number is matched in the database, then the patient will be discharged from the database and transferred the record of the discharged patient to another table of database so that the Hospital Management has the record of discharged patients to fulfill his legal liabilities.
4. Doctors_Available Module
Using this Module we can get on line informations about the doctors available in our hospital.
5. Preeventive_Checkup Module
Sagar Apollo Hospital helps you in that right direction- a comprehensive and complete health check-up from the best available hands that will guide you to living a healthier life.
6. Display_Record Module
This module is used to display all the transaction including the patient name, address, phone, bed number, and doctor assigned to him/her in the screen. This is a global report to display all the transaction records in the screen.
7. Administrator Module
This module is for administrator. To generate
a. List of Patients.
b. List of Doctors.
c. To add New doctors in the site.
d. List of Patients interested in Free Medical Advice.
8. Training Courses Available
This module is for the information of the courses provided by the Hospitals, Mode of Payment for Courses.
9. Business Services
Tenders are collected for food supplier, Medicine suppliers and other items suppliers which was then finalized by the management
10. Donations
This module is related to Blood donation, Eye donation, Kidneys donation and donation of their body parts. The eye donators can pledge online for their eye donations before their death.
11..Placement Agency
This module deals with placement agencies for the placement of nurses, and other staff.
12. Near by Hotels
In this Module Hotel information are provided for the accommodation of relatives of the patients.
13. Report Generation
This module is important for management or administrator to generate report of patients who want free medical advice, appointments, doctors who want to work in this hospital, Patients in the Hospital etc.
14. Validations & Checks
This module is important for applying validations to the fields in each form.
Process Logic for Each Module:
Process Logic of Module is a tool that may be useful in planning and evaluating projects.
Our logic model contains four components with Inputs-Outputs-Outcomes being central to the built in response to the model:
- Situation: The context and need that gives rise to a project or initiative; logic modules are built in response to an existing situation.
- Inputs: The resources, contributions, and investments that are made in response to the situation. Inputs lead to Outputs.
- Outputs: The activities, products, methods, and services that reach people and users. Outputs lead to outcomes.
- Outcomes: The results and benefits for individuals, groups, agencies, communities and/or systems.
Report Generation
From above modules different reports are generated. ‘Crystal Reports’ is a popular third party package that is included with Visual Basic.NET, which allows you to create reports for your application. The package consists of a designer – where you can design and test the reports, Crystal Reports API calls and CrystalReportViewer control. Crystal Report generated in this website are about:
- Discharge Patient Detail
- Doctor Assigning related to Patient’s Disease
- Training Courses Provided by the Hospital
- Statement of Patient Details
a. Admitted Patient
b. Discharged Patient
c. Doctor Details
- Patients admitted in the Hospital
- Doctors available in the Hospital
- Preventive Health Checkups
- List of Doctors
- Searching or Enquiry about
Doctors
Patients
Rooms
Business services
Food suppliers
Medical suppliers
Other items suppliers
- Placement services
- Near by hotel accommodation for relatives of patients
DATA MODELING
Login Table
Field Name | Data Type | Constraints |
UserID | Varchar(10) | Primary key |
Password | Varchar(10) | Not null |
Clerk_id | Varchar(6) | Foreign key |
Administrator_Login Table
Field Name | Data Type | Constraints |
Username | Varchar(10) | Not Null |
Password | Varchar(10) | Not null |
Job_for_Doctors Table
Field Name | Data Type | Constraints |
Name | Char | Not Null |
Address | Char | Not null |
Phone No | Number | Not Null |
Char | Not Null | |
City | Char | Not null |
Pin | Number | Not Null |
Gender | Char | Not Null |
Degree | Char | Not null |
Specialty | Char | Not Null |
Availability | Char | Not Null |
States | Char | Not null |
Patient Table
Field Name | Data Type | Constraints |
Patient_ID | Char | Not Null |
Name | Char | Not null |
Address | Char | Not Null |
City | Char | Not Null |
State | Number | Not null |
Phone no | Char | Not Null |
Char | Not Null | |
Disease | Number | Not null |
Age | Char | Not Null |
Remark | Char | Not Null |
Patient Appointment Table
Field Name | Data Type | Constraints |
Name | Char | Not Null |
Address | Char | Not null |
City | Char | Not Null |
State | Char | Not Null |
Phone no | Number | Not null |
Char | Not Null | |
Disease | Char | Not Null |
Age | Number | Not null |
Remark | Char | Not Null |
Donators Table
Field Name | Data Type | Constraints |
Donator_ID | Char | Not Null |
Name | Char | Not null |
Address | Char | Not Null |
Phone no | Char | Not Null |
Number | Not null | |
Donating | Char | Not Null |
Stats | Char | Not Null |
Bill Table
Field Name | Data Type | Constraints |
Transaction_ID | Char | Not Null |
Patient Name | Char | Not null |
Disease | Number | Not Null |
Bill Amount | Number | Not Null |
Room no | Number | Not null |
Bed no | Char | Not Null |
Online_Medical_Advice Table
Field Name | Data Type | Constraints |
Name | Char | Not Null |
Phone no | Number | Not null |
Char | Not Null | |
Discuses | Char | Not Null |
Doctor_Available Table
Field Name | Data Type | Constraints |
Name | Char | Not Null |
Specialty | Char | Not null |
Timings | Char | Not Null |
Days | Char | Not Null |
Training_Courses_Available Table
Field Name | Data Type | Constraints |
Course_ID | Char | Not Null |
Course | Char | Not null |
Duration | Char | Not Null |
Fees | Char | Not Null |
Dischage_Patients Table
Field Name | Data Type | Constraints |
Name | Char | Not Null |
Address | Char | Not null |
Phone no | Number | Not Null |
Char | Not Null | |
Disease | Char | Not null |
Stats | Char | Not Null |
Room No | Number | Not Null |
Bed No | Number | Not null |
Charges Paid | Number | Not Null |
Room_Available Table
Field Name | Data Type | Constraints |
Room No. | Number | Not Null |
Room Status | Char | Not null |
Size | Char | Not Null |
Charges | Number | Not Null |
Payment Package Table
Field Name | Data Type | Constraints |
Package_Id | Char | Not Null |
Charges | Number | Not null |
Disease | Char | Not Null |
Remark | Char | Not Null |
6. SECURITY AND VALIDATION CHECKS
In this project we have used following validation checks.
- While entering the data into the form it will check for the fields is properly filled & it should not be null.
- Whenever we enter the data for the new entity, details will be automatically added in the database tables and also generate the id automatically.
- Entered text / number should not exceed the limit (width).
- Almost for all fields we have used the validation for example if name of the fields requires the text type of data then it will check for the string and if the data is numeric then it will check if the number entered is proper numeric or not.
ASP.NET Provides Security
- Evidence-based security (authentication)
- Based on user identity and code identity
- Configurable policies
- Imperative and declarative interfaces
Security system protects a system from external security branches and internal fraud. The resources invested in the system should however balance the sensitivity of the data being manipulate. In the Log-in-Menu, special security will be provided.
7. SCOPE OF FUTURE APPLICATION
This project can be used as Administrative support system for Medical Institutions with adding some more useful modules in the project.
Utmost care and back-up procedures must be established to ensure 100% successful implementation of the computerized system. In case of system failure, the organization should be in a position to process the transaction with another organization or if the worst comes to the worst, it should be in a position to complete it manually.
The limitations may be many and the magnitude of the influence of these limiting factors may have a bearing on the report, but it in no way alters the ultimate aim of the project and because it’s highly USER FRIENDLY, it would be the choice of all kinds of personnel.
8. CONCLUSION
This project is designed to meet the requirements of Medical Institutes. It provides the facilities for online donations of blood, eyes and kidneys, online appointments, online report collection placement agencies etc.. It has been developed in ASP.NET, keeping in mind the specifications of the system.
For designing the system we have used simple data flow diagrams.
Overall the project teaches us the essential skills like:
q Using system analysis and design techniques like data flow diagram in designing the system.
q Understanding the database handling and query processing using SQL Server.
9. BIBLIOGRAPHY
1. Senn James A: Analysis and Design of Information Systems, McGraw Hill, International Ed, 1989.
2. O’Brien Jamea A: Management Information Systems, Galgotia Publications Pvt Ltd, New Delhi, 1998.
3. Laudon & Laudon: Management Information Systems, Organisation and Technology, PHI, New Delhi, 1998.
4. Wetherebe James: Systems Analysis and Design, Galgotia Publications Pvt Ltd, New Delhi, 1990