Below is a description of the business process of a hospital. After reading the business process below, provide an ERD showing the primary key, all attributes, relationships, and cardinalities as in the sample ERD. When developing ERD, you must use a diagramming tool. Using an ERD tool is a part of diagram drawing, so hand-drawn ERD will not be accepted. While various free ERD drawing tools are available on the web, some tools may require you to pay depending on the tool and the plan you select. You may refer to this list https://clickup.com/blog/erd-tools/ and select a tool you want. However, the tools you may select are not limited to the list in the link. Once you have completed your diagram, print it as a PDF file and submit it to CougarVIEW dropbox. If you need multiple pages to include all your tables, print it in multiple pages. Description of business process 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 (out patient department) 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

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

. Below is a description of the business process of a hospital.
After reading the business process below, provide an ERD showing the primary key, all attributes,
relationships, and cardinalities as in the sample ERD.

When developing ERD, you must use a diagramming tool. Using an ERD tool is a part of diagram
drawing, so hand-drawn ERD will not be accepted. While various free ERD drawing tools are
available on the web, some tools may require you to pay depending on the tool and the plan you select.
You may refer to this list https://clickup.com/blog/erd-tools/ and select a tool you want. However, the
tools you may select are not limited to the list in the link.
Once you have completed your diagram, print it as a PDF file and submit it to CougarVIEW dropbox.
If you need multiple pages to include all your tables, print it in multiple pages.
Description of business process
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 (out patient
department) 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.

2. Task #2 - Development of Complete ERD
We learned about how to extract tables and how to make relationships. In this task, we will practice
the entire process of developing an ERD. Below is a description of the business process of a hospital.
After reading the business process below, provide an ERD showing the primary key, all attributes,
relationships, and cardinalities as in the sample ERD.
Sample ERD:
SEMINAR
Seminar D
SeminarDate
SeminarTime
Location
SeminarTitle
INVOICE
InvoiceNumber
InvoiceDate
Payment Type
Subtotal
Shipping
Tax
Total
(D) version WIL LINE_IICM
CONTACT
CustomerlD
ContactNumber
ContactDate
Contact Type
LINE_ITEM
InvoiceNumber
LineNumber
Quantity
UnitPrice
Total
CUSTOMER
Customer D
LastName
FirstName
EmailAddress
Encrypted Password
Phone
StreetAddress
City
State
ZIP
PRODUCT
ProductNumber
Product Type
O--- Product Description
UnitPrice
QuantityOnHand

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions