Hospital Assesment And Review Management

Running head: HOSPITAL MANAGEMENT
HOSPITAL MANAGEMENT
Name of the Student
Name of the University
Author Note

HOSPITAL MANAGEMENT
1
Table of Contents
Stage 1: Scenario and Conceptual Database Design..................................................................2
Task 1.1: A Case study of the hospital management system:................................................2
Task 1.2: Conceptual database design:..................................................................................3
Stage 2: Logical Database Design and Oracle SQL Implementation/querying.........................4
Task 2.1: Logical Database Design:.......................................................................................4
Task 2.2: Creating tables using Oracle DBMS......................................................................5
Task 2.3: Creating the four most useful indexes..................................................................13
Task 2.4: SQL Query writing...............................................................................................15
Bibliography:............................................................................................................................19

HOSPITAL MANAGEMENT
2
Stage 1: Scenario and Conceptual Database Design
Task 1.1: A Case study of the hospital management system:
As XYZ hospital has many advanced technologies, the patient rate is increasing day
by day. The old database is unable to handle the workflow and store every information. The
old system is maintained manually. Maintaining a manual database is hard and time-
consuming. So they are appointing a software analyst to create a reliable database for XYZ
hospital. They need an advanced computerized database system that can store every detail
and any hospital admin can maintain this database system.
In the XYZ hospital database, doctors, patients, nurses and hospital employees are the
entities in this database. It is very hard to store and maintain this information manually. This
database can store all the necessary information for the organization. Many patients can visit
the hospital but they need to fix an appointment before admit. A doctor, nurse or any official
staff of the hospital is an employee. A patient needs to pay the full amount of money before
they discharged from the XYZ hospital. Every department has several rooms and each doctor
is assigned to a particular patient. This database is beneficial for the XYZ hospital.

HOSPITAL MANAGEMENT
3
Task 1.2: Conceptual database design:
Figure 1: Conceptual data model of Hospital management
(Source: created by author)