Database Question Answer the following questions about the Healthcare ERD in Fig
ID: 3673535 • Letter: D
Question
Database Question
Answer the following questions about the Healthcare ERD in Figure 1. Briefly justify your answer using a complete sentence (no credit will be given for “yes” or “no” answers without correct explanations.)
a. Can the date-diagnosed attribute for the Primary relationship be moved to either Patient or Condition and capture the same information?
b. Can the date-diagnosed attribute for the Secondary relationship be moved to either Patient or Condition and capture the same information?
c. Do medications have 0, 1, or many names? (circle all that apply)
d. Do medications have 0, 1, or many active ingredients (active-ing)? (circle all that apply)
e. Can a patient have 0, 1, or many primary conditions? (circle all that apply)
f. Can a patient have the same conditions diagnosed on different days?
h. Can a doctor treat a condition where he or she is not a top specialist?
date-diagnosed atient ID 1cdscode Primary Patient 1 Condition Iti Secondary Top-specialist date-diagnosed fi hame active-ing freated-by Medication Doctor Prescription Figure 1 Healthcare Entity Relationship Diagram (ERD) mi interferes-with hysID fieldExplanation / Answer
Answers:
A) No, because a patient can have multiple date-diagnosed on the contrary the condition can only have one date-diagnosed.
B)Yes, because a patient can have multiple date-diagnosed and also the condition can have multiple date-diagnosed.
C) These have one (1) name, so they are primary key, relationship 1:1
D) Have many active ingredients (active-ing), relationship 1:M
E)The patient can only have one, relationship 1:1
F)Yes, because if the symptom persists and continues recording it can have the same symptom days
H)No, because it is not a top specialist in that subject.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.