In the figure below, which of the following apply to both outpatients and resident_patients?

Chapter 3 Database Design Flashcards ionicons-v5-c

Patient_Name

In the figure below, which of the following apply to both OUTPATIENTs andRESIDENT_PATIENTs?A) Checkback_DateB) Date_DischargedC) Patient_NameD) XML

Outpatient

In the figure below, which of the following is a subtype of patient?A)OutpatientB) PhysicianC) BedD) Date_Hired

Vehicle

In the figure below, to which of the following entities are the entities "CAR" and "TRUCK"generalized?A) MakeB) VehicleC) ModelD) Price

total specialization.

The following figure is an example of:A) partial specialization.B) completeness.C) total specialization.D) disjointness

partial specialization.

The following figure is an example of:A) partial specialization.B) disjoint completeness.C) total specialization.D) transunion constraint.

disjoint

In the figure below, the patient must be either an outpatient or a resident patient. This is anexample of the ________ rule.A) disjointB) specializationC) generalizationD) overlap

subtype discriminator

The following diagram shows:A) total specialization.B) partial specialization.C) the overlap rule.D) subtype discriminator

the overlap rule.

The following figure shows an example of:A) the disjoint rule.B) the completeness rule.C) the underdog rule.D) the overlap rule

A rental unit can be an apartment, house or just a rental unit; it may not be more than one atthe same time.

Which of the following statements is true about the figure shown below?A) A rental unit must be either an apartment or a house, and cannot be both at the same time.B) A rental unit can be an apartment, house or just a rental unit; it may not be more than one atthe same time.C) A rental unit must be either an apartment or a house, and could be both.D) A rental unit can be an apartment, a house or just a rental unit. It could be both an apartmentand a house at the same time

A rental unit must be either an apartment or a house, and could be both.

Which of the following statements is true about the figure shown below?A) A rental unit must be either an apartment or a house, and cannot be both at the same time.B) A rental unit can be an apartment, house or just a rental unit; it may not be more than one atthe same time.C) A rental unit must be either an apartment or a house, and could be both.D) A rental unit can be an apartment, a house or just a rental unit. It could be both an apartmentand a house at the same time.

supertype/subtype hierarchy.

The following figure shows a:A) disjoint constraint.B) completeness constraint.C) supertype/subtype hierarchy.D) spindle constraint

A person can only be a faculty, student or staff

Which statement is true about the following diagram?A) A person can only be a faculty, student or staff.B) A student can be both an undergraduate and a graduate student at the same time.C) All attributes of person and student are inherited by undergraduate.D) All attributes of graduate are inherited by person.

FALSE

The following figure is an example of total specialization.

FALSE

The following figure is an example of the overlap rule

TRUE

There are three separate discriminators in the following diagram because of the overlap rule.