Chapter 3 Database Design Flashcards
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.
must be a graduate student, an undergraduate, a special student or some other type of student
In the figure below, a student:A) must be a graduate student, an undergraduate, a special student or some other type of student.B) must be a graduate student or an undergraduate student.C) must be at least a special student.D) must be a doctoral student.
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
Part type - A Subtype Discriminator is an attribute of the Supertype that is used to "code" or denote which Subtype an entity is
The subtype discriminator in the figure below is:A) Part_Type.B) Part_No.C) Manufactured Part.D) Location.
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.
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.
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.
entity cluster. An entity cluster is a set of one or more entity types and associated relationships
The figure below is an example of a(n):A) supertype/subtype hierarchy.B) hierarchical data model.C) entity cluster.D) column cluster.
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.
Attributes are assigned at the highest logical level that is possible in the hierarchy. Forexample, in the following diagram, one would assign the name to the person supertype so that itcould be shared by as many subtypes as possible
Discuss how attributes are assigned in a supertype/subtype hierarchy.