V-:IJI-"'""'
' '
, ,
[
lnstitu-le of
Tlld1ook>gy
fm;rcd 1,1 A· b1 NAAC
Assignment 2
Class SE CMPN Vertical_Basket PC_PCC
Course Code PCCEOST Course Data Base Management
Systems
Announcement 21'1 July 2025 Submission 26th July 2025
Date Date
Self-Dedaration
It took me hour(s) and _ _ _minute(s) to solve the assignment, ensuring accuracy,
completeness, and adherence to professional and ethical standards.
Roll Name Sign
No. 24102B0046 Jeet Mane
Assessment
Farulty Signature
Question 1: Consider the following ER Diagram and Convert it to relational schema.
Note : TT and PP Indicates Roles. Attribute eel of Weak Entity set C Is discriminative attribute
V-:IJI-"'""'
' • ,
, ,
[
A~•d lt:2 A· b1 NAAC
lnstiti.t:e of
Tlld1ook>gy
Question 2: Consider the following specifications and propose a conceptual solution in form of ER
Diagram.
Case Study
Hospital Management System
Alm: 't:fZ hospital is a multi specialty hospital that includes several departments, rooms,
doctors, nurses, compounders, and other staff working in the hospital. Patients having different
kinds of ailments come to the hospital and get checkup done from the concerned doctors. If
required they are admitted in the hospital and discharged after treatment.
The aim of this case study is to design and develop a database for the hospital to maintain the
records of various departments, rooms, and doctors in the hospital. It also maintains records of
the regular patients, patients admitted in the hospital, the check up of patients done by the
doctors, the patients that have been operated, and patients discharged from the hospital.
Description: In hospital, there are many departments like Orthopedic, Pathology, Emergency,
Dental, Gynecology, Anesthetics, I.C.U., Blood Bank, Operation Theater, Laboratory, M.R.I.,
Neurology, Cardiology, Cancer Department, Corpse, etc. There is an OPD where patients come
and get a card (that is, entry card of the patient) for check up from the concerned doctor. After
making entry in the card, they go to the concerned doctor's room and the doctor checks up
their ailments. According to the ailments, the doctor either prescribes medicine or admits the
patient in the concerned department. The patient may choose either private or general room
according to his/her need. But before getting admission in the hospital, the patient has to fulfill
certain formalities of the hospital like room charges, etc. After the treatment is completed, the
doctor discharges the patient. Before discharging from the hospital, the patient again has to
complete certain formalities of the hospital like balance charges, test charges, operation
charges (if any), blood charges, doctors' charges, etc.
Next we talk about the doctors of the hospital. There are two types of the doctors in the
hospital, namely, regular doctors and call on doctors. Regular doctors are those doctors who
come to the hospital daily. Calls on doctors are those doctors who are called by the hospital if
the concerned doctor is not available.
:::>0~1~ IPage No.
Date / /
~--------+----------------------------
-
-'
•
s
• G c.c1.
"...~ - - + - - - - - ! ~ ~ ~ ~ ~ 0 - - - - - - - - : - - - - - - - - - - - - - - -
• R1. cr1.- T, o1 - rP
• 2 ➔ tJo ru..J.
:
I I
