Enterprise Rules - Hospital Management System

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

HOSPITAL MANAGEMENT SYTEM
1
Table of Contents
Enterprise Rules - Hospital management system............................................................................2
Conceptual Enhanced Entity Relationship Diagram.......................................................................3
Logical Enhanced Entity Relationship Diagram.............................................................................4
Tables...............................................................................................................................................4
Data Population.............................................................................................................................12
Indexes...........................................................................................................................................15
Query.............................................................................................................................................16
Bibliography..................................................................................................................................21

HOSPITAL MANAGEMENT SYTEM
2
Enterprise Rules - Hospital management system
Enterprise rules or Business rules defines the functionality and the process of the system.
It manly helps in identifying the objects participating in the process, their relationship and the
attributes related to it.
 Each employees are whether nurse, doctor or other staff and identified by their employee
id.
 A patient (identified by patient id) is assigned to a room in the hospital by other staff
(Receptionist, warden etc.) identified by the Room no and their floor and features.
 Each patient is assigned to a doctor for checkup and appointments.
 Each doctor can be scheduled for one or more patient.
 Each nurse can govern one or more than one room.
 Each room has one or more nurses.
 Each Patient pays their bills.
 Each patient can make one or more payment identified by payment id.
 Each patient have their test and test details recorded in the system.
 Test record is identified by the patient id, hence it is the weak entity here.

HOSPITAL MANAGEMENT SYTEM
3
Conceptual Enhanced Entity Relationship Diagram
Figure 1: Conceptual Enhance Entity Relationship Diagram
Source: Created by author

HOSPITAL MANAGEMENT SYTEM
4
Logical Enhanced Entity Relationship Diagram
Figure 2: Logical Entity Relationship Diagram
Source: Created by author
Tables
P2512513Doctor
create table P2512513Doctor (DoctorID int primary key, Speciality varchar(50), LicenseNo int);

HOSPITAL MANAGEMENT SYTEM
5
Alter table P2512513Doctor
add constraint fk_emp_doc
foreign key (DoctorID)
references P2512513Employee(EmployeeID);
P2512513Employee
create table P2512513Employee (EmployeeID int primary key, FName varchar(25), LName
Varchar(25), Street varchar(10), city varchar(25), country varchar(25), Contact int, Email
varchar(25), Salary decimal(6,2));