CIS 305 Chapter 3 Quiz

disjointedness constraint

A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes. partial specialization disjoint rule disjointedness constraint total specialization

completeness

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. disjoint weak completeness overlap

more one-to-one relationships give the data model more flexibility.

All of the following are advantages of packaged data models EXCEPT: packaged data models can be built using proven components evolved from cumulative experiences. the data model is easier to evolve. projects take less time and cost less. more one-to-one relationships give the data model more flexibility.

Define one vehicle entity type to hold all entities.

Given the following entities, which of the choices below would be the most complicated? Automobile: VIN, EngineSize, NumberOfDoors, NumberOfPassengers, FuelType, Transmission SUV: VIN, EngineSize, NumberOfPassengers, NoWheelDrive, FuelType, Transmission Truck: VIN, EngineSize, NoWheelDrive, FuelType, Transmission, Payload Define one vehicle entity type to hold all entities. Define a separate entity type for each entity. Define a supertype called vehicle and make each of the entities subtypes. Keep only the Truck entity type.

must be a graduate student, an undergraduate, a special student or some other type of student.

In the figure below, a student: must be a doctoral student. must be at least a special student. must be a graduate student or an undergraduate student. must be a graduate student, an undergraduate, a special student or some other type of student.

disjoint

In the figure below, the patient must be either an outpatient or a resident patient. This is an example of the ________ rule. specialization disjoint overlap generalization

Vehicle

In the figure below, to which of the following entities are the entities "CAR" and "TRUCK" generalized? Price Model Vehicle Make

disjoint

The ________ rule specifies that an entity can be a member of only one subtype at a time. removal disjoint exclusion inclusion

partial specialization

The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype. semi-specialization total specialization partial specialization disjointedness

total specialization

The ________ rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship. total convergence partial specialization total specialization semi-specialization

overlap

The ________ rule states that an entity instance can simultaneously be a member of two (or more) subtypes. disjoint overlap total specialization partial specialization

partial specialization

The following diagram shows: subtype discriminator. total specialization. partial specialization. the overlap rule.

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 cannot be both at the same time. A rental unit can be an apartment, house or just a rental unit; it may not be more than one at the same time. A rental unit must be either an apartment or a house, and could be both. 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.

All attributes of person and student are inherited by undergraduate.

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

entity cluster. supertype/subtype hierarchy. hierarchical data model. column cluster.

he figure below is an example of a(n):

subtype discriminator

An attribute of the supertype that determines the target subtype(s) is called the: subtype decision. disjoint indicator. subtype discriminator. determinant.

combining a strong entity and its weak entities

An entity cluster can be formed by: combining metadata. deleting a supertype and its subtype. deleting metadata. combining a strong entity and its weak entities.

a set of one or more entity types and associated relationships grouped into a single abstract entity type.

An entity cluster is: a formal method for specifying attributes of related entities. a useful way to present data for a small and fairly simple organization. a way of developing more granular views of the data model. a set of one or more entity types and associated relationships grouped into a single abstract entity type.

only one supertype.

In a supertype/subtype hierarchy, each subtype has: at least one subtype. only one supertype. at most two supertypes. many supertypes.

supertypes

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 subtypes dimensions constraints

Patient_Name

In the figure below, which of the following apply to both OUTPATIENTs and RESIDENT_PATIENTs? Checkback_Date Date_Discharged Patient_Name XML

Outpatient

In the figure below, which of the following is a subtype of patient? Bed Date_Hired Physician Outpatient

require customization

Packaged data models: allow partial specialization. cannot be used for most applications. require customization. are ready to use right out of the box.

there are attributes that apply to some but not all instances of an entity type.

Subtypes should be used when: the instances of a subtype do not participate in a relationship that is unique to that subtype. a recursive relationship is needed. supertypes relate to objects outside the business. there are attributes that apply to some but not all instances of an entity type.

total specialization

The following figure is an example of: total specialization. completeness. disjointness. partial specialization.

total specialization

The following figure is an example of: transunion constraint. total specialization. disjoint completeness. partial specialization.

supertype/subtype hierarchy.

The following figure shows a: supertype/subtype hierarchy. disjoint constraint. completeness constraint. spindle constraint.

the overlap rule.

The following figure shows an example of: the disjoint rule. the underdog rule. the completeness rule. the overlap rule.

generalization

The process of defining a more general entity type from a set of more specialized entity types is called: generalization. specialization. extrapulation. normalization.

Specialization

The process of defining one or more subtypes of a supertype and forming relationships is called: specialization. generalization. creating discord. selecting classes.

attribute inheritance

The property by which subtype entities possess the values of all attributes of a supertype is called: hierarchy reception. generalization. attribute inheritance. class management.

Part_Type.

The subtype discriminator in the figure below is: Part_No. Manufactured Part. Part_Type. Location.

essential components and structures are already defined.

Using a packaged data model, projects take less time and cost because: there is more time taken to model the enterprise. packaged data models only run in Oracle. essential components and structures are already defined. less personnel are required.

Total specialization

Which of the following is a completeness constraint? Total recall Total specialization Partial generalization Partial hybridization

Supertype

Which of the following is a generic entity type that has a relationship with one or more subtypes? Subgroup Megatype Class Supertype

Relationships are connected to the highest-level entity type in an order that makes sense.

Which of the following is true of packaged data models? Relationships are connected to the highest-level entity type in an order that makes sense. All weak entities are considered strong. All subtype/supertype relationships follow the total specialization and disjoint rules. No entities on the many sides of a relationship can be weak.