Consider the ER diagram in Figure 1. It represents a database for tracking lease

Question

Consider the ER diagram in Figure 1. It represents a database for tracking leases and the items being leased.

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

Figure 2

Explanation / Answer

No Figures : Figure1 And Figure 2 Is Present in The Question.Please put the images by editing the question and revert me back in comment section

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

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