HOSPITAL MANAGEMET

Developed by Name : KHAN KAMRAN SUFIYAN AND SHANAWAZ SHAIKH Reg. No. : Reg. No. :

NIIT
HOSPITAL MANAGEMET
Batch Code Start Date Name of the Coordinator Name of the Developer : B100139 : : Priya Madam : Kamran Khan And Shanawaz Shaikh End Date:

Date of Submission: 9th September 2011

NIIT
CERTIFICATE
This is to certify that this report , titled Hospital Management, embodies the original work done by Shanawaz Shaikh and Kamran Khan in partial fulfillment of there course requirement at NIIT Kalina.

Coordinator:

Formatted: Left

ACKNOWLEDGEMENT
We wish to express our deep sense of gratitude to my project Guide, Priya (faculty), for her guidance and useful suggestions, which helped us in completing the project work, in time. Finally I would also like to thank our NIIT staff for their great support that they have given during the development of the project.

1. ADO.NET
ADO.NET is a set of computer software components that programmers can use to access data and data services. It is a part of the base class library that is included with the Microsoft .NET Framework. It is commonly used by programmers to access and modify data stored in relational database systems, though it can also access data in non-relational sources. ADO.NET is sometimes considered an evolution of ActiveX Data Objects (ADO) technology, but was changed so extensively that it can be considered an entirely new product. ADO.NET and Visual Studio: - Functionality exists in the Visual Studio IDE to create specialized subclasses of the Dataset classes for a particular database schema, allowing convenient access to each field through strongly-typed properties. This helps catch more programming errors at compile-time and makes the IDE's Intelligence feature more beneficial. ADO.NET is a set of classes that expose data access services to the .NET programmer. ADO.NET provides functionality to developers writing managed code similar to the functionality provided to native COM developers by ADO. ADO.NET provides consistent access to data sources such as Microsoft SQL Server, as well as data sources exposed through OLE DB and XML. Data-sharing consumer applications can use ADO.NET to connect to these data sources and retrieve, manipulate, and update data. ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational data, XML, and application data. ADO.NET supports a variety of development needs, including the creation of front-end database clients and middle-tier business objects used by applications, tools, languages, or Internet browsers

2. SYNOPSIS
The system is developed for Life Line Hospital. The current system that is implemented is not efficient for all the processes that take place in it This system focuses on automation of some processes that take place in Life Line Hospital. The system is a Windows based application developed in ado.net using C# language. It provides various Forms for entering data about the various transactions that take place in each of the events that takes place in the Life Line unit. The system also provide scope for the generation of various reports that are maintained in the database .The system also provide data security .Separate roles are assigned to each individuals in the unit to interact with the system based on their designation. The system focuses on

providing user friendly environment for the employees to interact with the system. The reports can be generated as and when required by the department in proper format.

TABLE OF CONTENTS
SR.NO. 1 2 3 4 5 TOPIC PAGE NO. 1 2 3 4 5

Ado.net Description Synopsis ER Diagram Data Flow Diagram (Level 0,Level 1,Level 2) Database Tables

Details of Hardware and Software Used For Development

CONCLUSION

8 9 10 11 12 13 14

BIBLIOGRAPHY

3. ER Diagram:Address OP ID DocID P ID Address First Name Name P ID Phone No

Patient
Last Name Phone No Gender

has

Medical History

Pre_hos

Pre_doc Medical History

has

Report id

User Name DocID

Treatdetails

Login
P ID

Password

Treatment
Role

OP ID

First Name

Last Name

Gender

Doctor

Address

Phone No

Time Duration Speciality

DocID Charge Catogary

4. DATA FLOW DIAGRAM Level 0:-

Patient

Patient Details

Patient

Previous Hospital Details

Doctor

Doctor Details

Hospital Management

Life Line Hospital

Treatment Details Patient

Patient

Bill Payment Details

Level 1:-

Patient

New Entry 1.0 Managing Patient Details Previous Details D1 Patient Details

Patient

Patient Patient Report

2.0 Details Doctor Managing Doctor Details D2 Doctor Details

Level 2:-

Patient

New Entry 1.0 Managing Patient Details Previous Details D1 Patient Details

Patient

Patient Patient Report

2.0 Details Doctor Managing Doctor Details D2 Doctor Details

5. DATABASE TABLES:Patient Column PID first_name last_name address gender phone_no appoinment_time report_id Op_id doc_id Treatment Data type varchar(10) char(30) char(30) varchar(40) char(10) numeric(15,0) varchar(30) varchar(10) varchar(10) varchar(10) char(30) Constraints PK__patient Not null Description Unique Identifier for Patient Patients First Name Patients Last Name Address of Pateint Gender of Pateint Phone Number of Patient Appoint_time Of Pateint Unique Report id for Patient Unique out id for Patient Doctor id for patient Treatment Details for Patient

Not null Not null Not null

Login:Column Username Password Role Patient History:Column pid name Address Phone_no Prev_hosp Prev_doc Medical_history Data type varchar(10) char(30) varchar(50) Numeric(15) char(50) char(18) char(30) Constraints Pk Description Unique Identifier for Patient Patient Name Address of the patient Phone number of the patient Previous Hospital of the patient Previous Doctor name Previous Disease of patient Data type varchar(50) varchar(50) Varchar(50) Constraints Pk Not Null Not Null Description User Name for Login Password Role of the User

Doctor:Column Doc_id First_name last_name address phone_no gender Data type varchar(10) char(30) char(30) varchar(50) numeric (15) char(10) Constraints Pk Description Doctor Id of the Doctor Doctors First Name Doctors Last Name Address of Doctor Phone number of the Doctor Gender of the the Doctor

time_duration specialty category

varchar(30) char(30) char(30)

Time on which the doctor will be available Specialty of the Doctor Category of Doctor whether Visiting or Regular

Treatment:Column pid Op_id Doc_id treatmentDetails Data type varchar(10) varchar(10) varchar(10) Char(30) Constraints FK Description Patient ID Unique Out Id of Patient Doctor Id for Patient Treatment Details of Patient

LIST OF ABBREVIATION
ERD:- Entity Relationship Diagram PK:- Primary Key FK:- Foreign Key GB:- Giga Bytes MB:- Mega Bytes SP:- Service Pack XML:- Extensible Markup Language CSS:- Cascade Style Sheet ADO:- Activex Data Object SQL:- Structured Query Language IDE:-Integrated Development Environment CPU:- Central Processing Unit RAM :- Random Access Memory RPM:- Revolutions Per Minute OOA:- Object-Oriented Analysis OOD:-Object-Oriented Design OOP:-Object-Oriented-Programming OOT:-Object-Oriented Testing

6. Details of Hardware and Software Used For Development

9.3.1 Details of SOFTWARE and SOFTWARE LANGUAGE Used: Front end Data Access Back end Operating system Language Web languages Application Framework : : : : : : : : Windows application Ado.Net Microsoft SQL Server 2005 Windows XP SP 2 or above C# HTML, XSLT,XML Microsoft Visual Studio 2005 Microsoft .NET Framework 2.0

9.3.2 Hardware Requirements:-

Minimum: 1.6 GHz CPU, 384 MB RAM, 1024x768 display, 5400 RPM hard disk Recommended: 2.2 GHz or higher CPU, 1024 MB or more RAM, 1280x1024 display, 7200 RPM or higher hard disk

9.3.3 Software Requirements: Microsoft SQL Server Management Studio professional Microsoft Visual Studio professional

or Express

or Express

7. CONCLUSION

Our project is only a humble venture to satisfy the Life line Hospital. Several user friendly coding have also adopted. This package shall prove to be a powerful package in satisfying all the requirements of the organization. The Life Line Hospital Management System (HMS) is a great improvement over the manual system using case fields and paper. The computerization of the system has speed up the process. The Life Line hospital Management System was thoroughly checked and tested with dummy data and thus is found to be very reliable.

8. BIBLIOGRAPHY
BOOKS: Object Oriented programming using C# Part I and II, Student Guide GUI Application Development Using .NET Framework, Student Guide Querying And Managing Data Using SQL Server 2005 ,Student Guide Extensible Markup Language, Student Guide Developing Database Application using ADO.NET and XML,Student Guide Murach's SQL Server 2008 for developers ISBN 978-1-89-077451-6 Bryan syverson and Joel murach SQL The Complete Reference, Third Edition ISBN: 978-0-07-159256-7 Paul Weinberg, James Groff,Andrew Oppel WEB SITES: http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson01.aspx msdn.microsoft.com www.codeguru.com www.c-sharpcorner.com www.w3schools.com www.msdn.microsoft.com www.dotnetspider.com www.homeandlearn.co.uk www.codeproject.com www.wikipedia.org http://www.techtutorials.net/tutorials/databases/crystal_reports.html http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-tutorial.htm http://www.developers.net/tsearch?searchkeys=crystal+reports+tutorial http://www.codekicks.com/2006/09/step-by-step-tutorial-for-creating.html