BETHANY NAVAJEEVAN SENIOR SECONDARY SCHOOL
Affiliated to CBSE Board, Affiliation No:1931074
BETHANY NAGAR, VENCODE
INFORMATION TECHNOLOGY(402)
A STUDY ON
THE TITLE “Hospital Management “
PROJECT REPORT
1
Submitted by
NAME OF THE CANDIDATE:J.Andro jamelin
ROLL NO:4
GRADE:X ROSE
BETHANY NAVAJEEVAN SENIOR SECONDARY SCHOOL
Affiliated to CBSE Board, Affiliation No:1931074
2
BETHANY NAGAR, VENCODE
DEPARTMENT OF COMPUTER SCIENCE
BONAFIDE CERTIFICATE
This is to certify that the project entitled
Is the bonafide record of project work done by
NAME OF THE CANDIDATE: J.Andro jamelin
REGISTER NO:
3
And submitted for the Central Board of Secondary Education during
the
Academic year 2023-2024.
PROJECT GUIDE
PRINCIPAL
4
ACKNOWLEDGEMENT
I extended my deep sense of gratitude and sincere
thanks to our Correspondent Fr. JOHN CHRISTOPHER OIC, Bethany
group of Institutions for giving me an opportunity to be a student of this
reputed institutions
I extend my respect to our Academic Mentor Mr. SIBIN JOSE S P M.
A.,B.Ed. for his valuable support in carrying my project work.
It is my privilege to thank our Head of the Department Mrs.
SATHIYAVATHY J M.Sc., B.Ed. for her support and guidance for doing
my project work.
I also express my sense of gratitude to my GUIDE Mrs. MERLIN
JOTHI J B. Tech., M.E., B.Ed. for her valuable suggestion and guidance
for doing this project.
I also express my gratitude to all the faculty members, parents and my
fellow mates who have helped me to carry out this work. Last but not
least, I thank my almighty God for His blessings showed me during this
period.
5
J.Andro
Jamelin
NAME OF THE CANDIDATE
CONTENT
S.no Topic Page no
1. Abstract 2
2. Introduction 3
3. Forms 4
4. Report 5
5. Layout view 6
6. Hospital 7
Management
7. Input 8
8. Output 9
9. Conclusion 10
6
ABSTRACT
Database management system is a system is a computer software program that is
designed as the means of managing all databases that are currently installed on a system
hard drive or network. Different types of database management systems exist, with some
of them designed for the and proper control of databases that are configured for specific
purposes. Here are some examples of the various incarnations of DBMS technology that
are currently in use, and some of the basic elements that are part of DBMS software
application.
7
INTRODUCTION
A Database Management System (DBMS) is a set of computer programs that controls the
creation, maintenance, and the use of a database. It allows organizations to place control
of database development in the hands of database administrators (DBAs) and other
specialists. A DBMS is a system software package that helps the use of integrated
collection of data records and files known as databases. It allows different user
application programs to easily access the same database. DBMSs may use any of a
variety of database models, such as the network model or relational model. In large
systems, a DBMS allows users and other software to store and retrieve data in a
structured way.fig 1.1 Instead of having to write computer programs to extract
information, user can ask simple questions in a query language. A database management
system (DBMS) is a software-defined system that manages databases, whereas database
management is a set of best practices. Users in this system have access to data in a
database and can read, update, create, and remove records as needed. A database
management system acts as an interface, allowing end-users to access their databases to
organize and access the information as needed.A database management system is in
charge of the data, the engine that allows users to access the data within the database, and
the database schema, which is the database’s organizational structure. A database
management system (DBMS) ensures data security and integrity, but some systems also
allow for automated rollbacks, restarts, logging, and auditing of database activities.
8
FORMS
A table is linked to a form. Using the form, you can add or edit one record at a time. It is
a convenient and interactive way of entering data, but not an appropriate tool for every
data entry. This is useful when you work with different users and do not want to expose
your confidential data to them .A form can have a different name than a table, yet it
manipulates the same information and data as the corresponding table. If you change a
record in a form, it will be reflected in the table also. Data can be inserted, updated, and
deleted from a table by using the Form object. Forms can be created in OpenOffice Base
using the Form Wizard and Design Mode.Access gives us a window into our database
data through an object called a form. Forms can be used to create user interfaces to either
enter data or to manipulate data. A ” bound” form is a form that is tied directly to a table
or query and can serve as a user interface into that data source. An “unbound” form does
not directly connect to a data source, but gives the user controls that can be used to run
the database application.Forms are important tools for usability of a database application.
Users do not have to be familiar with the internal structure of the database but instead can
take advantage of a form to ensure usability—even that they are entering information
correctly. There are two views in Access that can be used to modify forms and controls:
Layout view and Design view.
CREATING FORMS
1. Select New Form or New Quiz.
2. Type a title for your form. You can also provide an optional subtitle for it.
3. Select Add new to add a question. You can choose to add Choice, Text, Rating,
or Date questions. Select the drop-down list to see more question types, such ag
Ranking, Likert , File upload, Net Promoter Score, and Se etion.
9
REPORTS
Reports are generally prepared and presented in a hard copy if you need to share the
information fro your database with someone but do not want that person to actually work
with your database. Report also provide the facility to group and sort the data items, thus
making them more readable.We will then learn how to create reports using Access
wizards for users to consume data. A report is a document that presents information in an
organized format for a specific audience and purpose. Although summaries of reports
may be delivered orally, complete reports are almost always in the form of written
documents.In modern business scenario, reports play a major role in the progress of
business. Reports are the backbone to the thinking process of the establishment and they
are responsible, to a great extent, in evolving an efficient or inefficient work
environment.One of the most common formats for presenting reports is IMRAD—
introduction, methods, results, and discussion. This structure, standard for the genre,
mirrors traditional publication of scientific research and summons the ethos and
credibility of that discipline. Reports are not required to follow this pattern and may use
alternative methods such as the problem-solution format, wherein the author first lists an
issue and then details what must be done to fix the problem. Transparency and a focus on
quality are keys to writing a useful report. Accuracy is also important. Faulty numbers in
a financial report could lead to disastrous consequences.
CREATING REPORTS
1. Select the table or query you want to base the report on.
2. Click the create table on the ribbon button.
3. Click on the report button.
4. Click on the save button.
5. Give a name to the report and click on Ok.
10
LAYOUT VIEW
Using Layout view is the most comprehensive way to make changes to your form. Since
the form is actually live in Layout view, you can see the data as it will look when the
form is being used. When you make changes that will affect the appearance or usability
of the form, you will see those design changes reflected on the data.Although Layout
view supports most design changes, there are a few outside its purview.Layout view
Layout view is a more visually-oriented view than Design view. While viewing a form in
Layout view, each control displays real data. As a result, this is a very useful view for
setting the size of controls, or performing many other tasks that affect the visual
appearance and usability of the form.
11
HOSPITAL MANAGEMENT
Hospital management system is a computer system that helps manage the information
related to health care and aids in the job completion of health care providers effectively.
They manage the data related to all departments of healthcare such as, Clinical.
Financial.Hospital management accords in the coordination with medical professionals,
pharmacies, paramedical services, nurses, and other nonmedical staff who are related
with the hospital industry. Hospital management helps in the healthcare’s structured
functioning and makes the easy and smooth delivery of various servicesHospital
Management System (HMS) is essential to the delivery of modern healthcare. It can
boost patient outcomes, lower medical errors, and improve the overall quality of care. It
enables hospitals with a centralized platform to manage their operations, automate
mundane processes, and enhance communication.Hospital management system is a
computer system that helps manage the information related to health care and aids in the
job completion of health care providers effectively. They manage the data related to all
departments of healthcare .HMS was introduced to solve the complications coming from
managing all the paper works of every patient associated with the various departments of
hospitalization with confidentiality. HMS provides the ability to manage all the
paperwork in one place, reducing the work of staff in arranging and analyzing the
paperwork of the patients.
12
INPUT
13
OUTPUT
14
CONCLUSION
Relational database systems underpin the majority of the managed data storage in
computer systems. In this course we have considered database development as an
instance of the waterfall model of the software development life cycle. We have seen that
the same activities are required to develop and maintain databases that meet user . A
DBMS gives businesses a complete, clear picture of how data is exchanged, ensuring that
no duplicates are created. It's also worth noting that, like many other systems, a DBMS
would necessitate more memory and CPU, so businesses should consider whether they
can meet this requirement.
15
REFERENCE
https://support.microsoft.com/en-au/office/know-when-to-use-layout-view-in-
access-2010-5a331534-85eb-4e16-9acd-16324957491b
https://www.oracle.com/in/database/what-is-database/#:~:text=A
%20database%20is%20an%20organized,database%20management
%20system%20(DBMS).
https://www.atatus.com/glossary/database-management-system/amp/
https://www.karexpert.com/blogs/what-is-hospital-management-system/
16
