CIS 305 Chapter 3 Quiz

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.

A rental unit must be either an apartment or a house, and cannot be both at the same time.

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.

All attributes of person and student are inherited by undergraduate.

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.

Define one vehicle entity type to hold all entities.

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

Outpatient

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

Part_Type.

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

Patient_Name

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.

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

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

Specialization

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

Supertype

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

Total specialization

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

Vehicle

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.

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

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

attribute inheritance

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.

combining a strong entity and its weak entities

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

completeness

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

disjoint

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

disjoint

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

disjointedness constraint

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

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

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.

essential components and structures are already defined.

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

generalization

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.

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

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.

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

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

only one supertype.

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

overlap

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

partial specialization

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

partial specialization

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

require customization

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

subtype discriminator

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

supertype/subtype hierarchy.

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

supertypes

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

the overlap rule.

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.

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 convergence partial specialization total specialization semi-specialization

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.

total specialization