Database chp3 - test
The following diagram shows:
None of these.
The most important challenge of customizing a purchased data model is:
determining the business rules that will be established through the data model.
In the figure below, the patient must be either an outpatient or a resident patient. This is an example of the ________ rule.
disjoint
The ________ rule specifies that an entity can be a member of only one subtype at a time.
disjoint
A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes.
disjointedness constraint
Packaged data models:
require customization.
The process of defining one or more subtypes of a supertype and forming relationships is called:
specialization
In a supertype/subtype hierarchy, subtypes that are lower in the hierarchy inherit attributes from not only their immediate supertype but from all ________ in the hierarchy.
supertypes
The following figure shows an example of: the overlap rule.
the overlap rule.
The following figure is an example of:
total specialization.
The ________ rule states that an entity instance can simultaneously be a member of two (or more) subtypes.
overlap
The subtype discriminator is a composite attribute when there is a(n):
overlap rule.
The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype.
partial specialization
The following figure is an example of:
partial specialization.
Which of the following statements is true about the figure shown below? A rental unit must be either an apartment or a house and cannot be both at the same time.
A rental unit must be either an apartment or a house and cannot be both at the same time.
Which of the following statements is true about the figure shown below? A rental unit must be either an apartment or a house and could be both.
A rental unit must be either an apartment or a house and could be both.
An attribute of the supertype that determines the target subtype(s) is called the:
None of these.
In the figure below, which of the following are subtypes of patient?
Outpatient
The subtype discriminator in the figure below is:
Part_Type
Which of the following is a generic entity type that has a relationship with one or more subtypes?
Supertype
Which of the following is a completeness constraint?
Total specialization
n the figure below, to which of the following entities are the entities "CAR" and "TRUCK" generalized?
Vehicle
Which statement is true about the following diagram? all attributes of person and student are inherited by undergraduate.
all attributes of person and student are inherited by undergraduate.
The property by which subtype entities possess the values of all attributes of a supertype is called:
attribute inheritance.
A(n) ________ constraint is a type of constraint that addresses whether an instance of a supertype must also be an instance of at least one subtype.
completeness
A good method for identifying inconsistencies and finding hidden meaning in the customized purchased data model is:
data profiling.
All of the following are steps to using a packaged data model EXCEPT:
utilize all business rules that come with the packaged data model.
When identifying with the parts of the packaged data model that apply to your organization, you should first start with:
entities
The process of defining a more general entity type from a set of more specialized entity types is called:
generalization
The third step in the data modeling process with a packaged data model is:
map data to be used from package to data in current databases.
All of the following are advantages of packaged data models EXCEPT:
more one-to-one relationships give the data model more flexibility.
In a supertype/subtype hierarchy, each subtype has:
only one supertype.
Which of the following statements is true about the figure shown below? A rental unit can be an apartment, a house or just a rental unit. It could be both an apartment and 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 apartment and a house at the same time.
Which of the following statements is true about the figure shown below? A rental unit can be an apartment, a house or just a rental unit; it may not be more than one at the same time.
A rental unit can be an apartment, a house or just a rental unit; it may not be more than one at the same time.
given the following entities, which of the choices below would be the most complicated? Automobile: VIN, EngineSize, NumberOfDoors, NumberOfPassengers, FuelType, TransmissionSUV: VIN, EngineSize, NumberOfPassengers, NoWheelDrive, FuelType, TransmissionTruck: VIN, EngineSize, NoWheelDrive, FuelType, Transmission, Payload
Define one vehicle entity type to hold all entities.
Subtypes should be used when:
there are attributes that apply to some but not all instances of an entity type.
The ________ rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship.
total specialization
A generic or template data model that can be reused as a starting point for a data modeling project is called a(n):
universal data model.
