Question 1 What are the supertypes? ____________________________________________

Question

Question 1

What are the supertypes?   __________________________________________________

How do you know? ________________________________________________________

Question 2

What are the subtypes?   ____________________________________________________

How do you know? ________________________________________________________

Question 3

Must an Item be a Truck, Computer, or Furniture?   _______________

How do you know? ________________________________________________________

Question 4

Can an Item be both a Truck and a Computer or Furniture?   _______________

How do you know? ________________________________________________________

Question 5

What field in Items is the discriminator?   _______________

Consider the ER diagram in Figure 2. It represents a database for patients in a hospital.

Question 6

What are the supertypes?   __________________________________________________

How do you know? ________________________________________________________

Question 7

What are the subtypes?   ____________________________________________________

How do you know? ________________________________________________________

Question 8

Must a Patient be a Resident or Outpatient?   _______________

How do you know? ________________________________________________________

Question 9

Can a Patient be both a Resident and an Outpatient?   _______________

How do you know? ________________________________________________________

Figure 1

Explanation / Answer

Your first Image in not visible clearly so i am provding you answers from part6 to part9. Please do let me know if you have any doubt. Post the first 5 parts again with good image.

Please give the thumbs up, if it is helpful for you. Thank you!!

Question 6
What are the supertypes?
patient

How do you know?
Because patient has got parent child relatioship with subtypes(OutPatient and Resident)

Question 7
What are the subtypes?   
OutPatient and Resident

How do you know?
Because these are subgroups of the supertype entity and have unique attributes,
and they are different from each other.

Question 8
Must a Patient be a Resident or Outpatient?
Yes

How do you know?
If the patient discharged then he will be Outpatient otherwise Resident.

Question 9
Can a Patient be both a Resident and an Outpatient?   
No

How do you know?

If the patient discharged then he will be Outpatient otherwise Resident.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.