BIS 245 CASE STUDY GUIDE | Small Surgery Center |
DeVry University Chicago | Complete Solutions |
Verified Answers | Pass Guaranteed - A+ Graded
Part One: Database Design & Entity-Relationship (ER) Modeling
(12 Questions)
Q1: You're working with the surgery center's office manager to design a database for
tracking daily operations. She mentions they need to record patients, the surgeons
who operate on them, the specific procedures performed, and the equipment used in
each operating room. How many distinct entities would you identify from this
description?
A. Three entities: patients, surgeons, and procedures only
B. Four entities: patients, surgeons, procedures, and operating rooms only
C. Five entities: patients, surgeons, procedures, equipment, and operating rooms
[CORRECT]
D. Six entities by splitting patients into inpatients and outpatients separately
Correct Answer: C
Rationale: The description explicitly mentions five distinct business objects that need
independent tracking: patients, surgeons, procedures, equipment, and operating
rooms. Each becomes its own entity in the database. Option A misses equipment and
rooms. Option B misses equipment. Option D creates unnecessary entity splitting—
patient type would be an attribute, not a separate entity.
,Q2: During your initial interview with the surgery center staff, the billing coordinator
explains that each surgery generates one bill, but a single patient might have
multiple surgeries over time, each with its own bill. What type of relationship exists
between Patient and Billing in this scenario?
A. One-to-one, because each patient has exactly one bill
B. One-to-many from Billing to Patient, since one bill can list multiple patients
C. One-to-many from Patient to Billing, because one patient can have multiple bills
[CORRECT]
D. Many-to-many, because bills can be split across multiple payment sources
Correct Answer: C
Rationale: One patient can have multiple bills (one per surgery), making this a one-
to-many relationship from Patient to Billing. The "one" side is Patient, and the
"many" side is Billing. Option A ignores multiple surgeries per patient. Option B
reverses the relationship. Option D confuses payment sources with the patient-billing
relationship itself.
Q3: The OR scheduler tells you that a single surgery might require multiple pieces of
equipment—a laparoscope, an electrocautery unit, and a suction device. Conversely,
the same piece of equipment gets used across many different surgeries. What
cardinality would you draw between the Surgery and Equipment entities?
A. One-to-many from Surgery to Equipment, since one surgery uses many items
B. One-to-many from Equipment to Surgery, since one item gets used many times
C. Many-to-many, because surgeries use multiple equipment items and equipment is
reused across surgeries [CORRECT]
D. One-to-one, because each surgery gets assigned one primary piece of equipment
Correct Answer: C
Rationale: When both sides of a relationship can have multiple instances, it's many-
to-many. One surgery uses many equipment items, and one equipment item appears
, in many surgeries. This requires a junction/associative table in the physical design.
Options A and B only capture half the relationship. Option D is factually incorrect
based on the scenario.
Q4: You're sketching an ER diagram for the surgery center. The anesthesiologist
mentions that every surgery has exactly one assigned anesthesiologist, but each
anesthesiologist works multiple surgeries per day. Between Surgery and
Anesthesiologist, what crow's foot notation would you place?
A. A single line on the Surgery side and a crow's foot on the Anesthesiologist side
B. A crow's foot on the Surgery side and a single line on the Anesthesiologist side
[CORRECT]
C. Crow's feet on both sides of the relationship line
D. A single line on both sides with a circle indicating optional participation
Correct Answer: B
Rationale: One anesthesiologist works many surgeries, so the "many" side (crow's
foot) goes on Surgery, and the "one" side (single line) goes on Anesthesiologist.
Option A reverses the notation. Option C would indicate many-to-many. Option D
indicates optional one-to-one, which doesn't match the described business rule.
Q5: The surgery center's patient intake form currently lists the patient's name,
address, phone number, and insurance information all in one large text block. Your
database professor would point out this form violates which normal form?
A. First normal form (1NF), because data isn't separated into distinct fields [CORRECT]
B. Second normal form (2NF), because there's no composite key to create partial
dependency
C. Third normal form (3NF), because insurance information might depend on the
insurance company, not just the patient
DeVry University Chicago | Complete Solutions |
Verified Answers | Pass Guaranteed - A+ Graded
Part One: Database Design & Entity-Relationship (ER) Modeling
(12 Questions)
Q1: You're working with the surgery center's office manager to design a database for
tracking daily operations. She mentions they need to record patients, the surgeons
who operate on them, the specific procedures performed, and the equipment used in
each operating room. How many distinct entities would you identify from this
description?
A. Three entities: patients, surgeons, and procedures only
B. Four entities: patients, surgeons, procedures, and operating rooms only
C. Five entities: patients, surgeons, procedures, equipment, and operating rooms
[CORRECT]
D. Six entities by splitting patients into inpatients and outpatients separately
Correct Answer: C
Rationale: The description explicitly mentions five distinct business objects that need
independent tracking: patients, surgeons, procedures, equipment, and operating
rooms. Each becomes its own entity in the database. Option A misses equipment and
rooms. Option B misses equipment. Option D creates unnecessary entity splitting—
patient type would be an attribute, not a separate entity.
,Q2: During your initial interview with the surgery center staff, the billing coordinator
explains that each surgery generates one bill, but a single patient might have
multiple surgeries over time, each with its own bill. What type of relationship exists
between Patient and Billing in this scenario?
A. One-to-one, because each patient has exactly one bill
B. One-to-many from Billing to Patient, since one bill can list multiple patients
C. One-to-many from Patient to Billing, because one patient can have multiple bills
[CORRECT]
D. Many-to-many, because bills can be split across multiple payment sources
Correct Answer: C
Rationale: One patient can have multiple bills (one per surgery), making this a one-
to-many relationship from Patient to Billing. The "one" side is Patient, and the
"many" side is Billing. Option A ignores multiple surgeries per patient. Option B
reverses the relationship. Option D confuses payment sources with the patient-billing
relationship itself.
Q3: The OR scheduler tells you that a single surgery might require multiple pieces of
equipment—a laparoscope, an electrocautery unit, and a suction device. Conversely,
the same piece of equipment gets used across many different surgeries. What
cardinality would you draw between the Surgery and Equipment entities?
A. One-to-many from Surgery to Equipment, since one surgery uses many items
B. One-to-many from Equipment to Surgery, since one item gets used many times
C. Many-to-many, because surgeries use multiple equipment items and equipment is
reused across surgeries [CORRECT]
D. One-to-one, because each surgery gets assigned one primary piece of equipment
Correct Answer: C
Rationale: When both sides of a relationship can have multiple instances, it's many-
to-many. One surgery uses many equipment items, and one equipment item appears
, in many surgeries. This requires a junction/associative table in the physical design.
Options A and B only capture half the relationship. Option D is factually incorrect
based on the scenario.
Q4: You're sketching an ER diagram for the surgery center. The anesthesiologist
mentions that every surgery has exactly one assigned anesthesiologist, but each
anesthesiologist works multiple surgeries per day. Between Surgery and
Anesthesiologist, what crow's foot notation would you place?
A. A single line on the Surgery side and a crow's foot on the Anesthesiologist side
B. A crow's foot on the Surgery side and a single line on the Anesthesiologist side
[CORRECT]
C. Crow's feet on both sides of the relationship line
D. A single line on both sides with a circle indicating optional participation
Correct Answer: B
Rationale: One anesthesiologist works many surgeries, so the "many" side (crow's
foot) goes on Surgery, and the "one" side (single line) goes on Anesthesiologist.
Option A reverses the notation. Option C would indicate many-to-many. Option D
indicates optional one-to-one, which doesn't match the described business rule.
Q5: The surgery center's patient intake form currently lists the patient's name,
address, phone number, and insurance information all in one large text block. Your
database professor would point out this form violates which normal form?
A. First normal form (1NF), because data isn't separated into distinct fields [CORRECT]
B. Second normal form (2NF), because there's no composite key to create partial
dependency
C. Third normal form (3NF), because insurance information might depend on the
insurance company, not just the patient
