Quiz about Topic 3

Question 1

The property by which subtype entities possess the values of all attributes of a supertype is called:

Accepted Answer

attribute inheritance.

Answer

hierarchy reception.

Answer

class management.

Answer

multiple inheritance.

Question 2

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

Accepted Answer

Supertype

Answer

Megatype

Answer

Subgroup

Answer

Class

Question 3

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

Accepted Answer

Define one vehicle entity type to hold all entities.

Answer

Define a separate entity type for each entity.

Answer

Define a supertype called vehicle and make each of the entities subtypes.

Answer

Keep only the Truck entity type.

Question 4

Subtypes should be used when:

Accepted Answer

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

Answer

supertypes relate to objects outside the business.

Answer

the instances of a subtype do not participate in a relationship that is unique to that subtype.

Answer

a recursive relationship is needed.

Question 5

In the figure below, which of the following apply to both OUTPATIENTs and RESIDENT_PATIENTs?

Accepted Answer

Patient_Name

Answer

Checkback_Date

Answer

Date_Discharged

Answer

XML

Question 6

In the figure below, which of the following is a subtype of patient?

Accepted Answer

Outpatient

Answer

Physician

Answer

Bed

Answer

Date_Hired

Question 7

The process of defining one or more subtypes of a supertype and forming relationships is called:

Accepted Answer

specialization.

Answer

generalization.

Answer

creating discord.

Answer

selecting classes.

Question 8

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

Accepted Answer

Vehicle

Answer

Make

Answer

Model

Answer

Price

Question 9

The process of defining a more general entity type from a set of more specialized entity types is called:

Accepted Answer

generalization.

Answer

specialization.

Answer

normalization.

Answer

extrapolation.

Question 10

The following figure is an example of:

Accepted Answer

total specialization.

Answer

partial specialization.

Answer

completeness.

Answer

disjointness.

Question 11

The ________ rule specifies that an entity instance of a supertype is allowed not to belong to any subtype.

Accepted Answer

partial specialization

Answer

semi-specialization

Answer

total specialization

Answer

disjointness

Question 12

The ________ rule specifies that each entity instance of the supertype must be a member of some subtype in the relationship.

Accepted Answer

total specialization

Answer

semi-specialization

Answer

partial specialization

Answer

total convergence

Question 13

Which of the following is a completeness constraint?

Accepted Answer

Total specialization

Answer

Partial generalization

Answer

Total recall

Answer

Partial hybridization

Question 14

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.

Accepted Answer

completeness

Answer

disjoint

Answer

overlap

Answer

weak

Question 15

In the figure below, a student:

Accepted Answer

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

Answer

must be a graduate student or an undergraduate student.

Answer

must be at least a special student.

Answer

must be a doctoral student.

Question 16

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

Accepted Answer

disjoint

Answer

exclusion

Answer

removal

Answer

inclusion

Question 17

A ________ addresses whether an instance of a supertype may simultaneously be a member of two or more subtypes.

Accepted Answer

disjointness constraint

Answer

disjoint rule

Answer

partial specialization

Answer

total specialization

Question 18

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

Accepted Answer

disjoint

Answer

specialization

Answer

generalization

Answer

overlap

Question 19

An attribute of the supertype that determines the target subtype(s) is called the:

Accepted Answer

subtype discriminator.

Answer

determinant.

Answer

subtype decision.

Answer

disjoint indicator.

Question 20

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

Accepted Answer

overlap

Answer

disjoint

Answer

partial specialization

Answer

total specialization

Question 21

The following diagram shows:

Accepted Answer

subtype discriminator.

Answer

total specialization.

Answer

partial specialization.

Answer

the overlap rule.

Question 22

The subtype discriminator in the figure below is:

Accepted Answer

Part_Type.

Answer

Part_No.

Answer

Manufactured Part.

Answer

Location.

Question 23

The subtype discriminator is a composite attribute when there is a(n):

Accepted Answer

overlap rule.

Answer

disjoint rule.

Answer

partial specialization.

Answer

full specialization.

Question 24

The following figure shows an example of:

Accepted Answer

the overlap rule.

Answer

the disjoint rule.

Answer

the completeness rule.

Answer

the underdog rule.

Question 25

In a supertype/subtype hierarchy, each subtype has:

Accepted Answer

only one supertype.

Answer

many supertypes.

Answer

at most two supertypes.

Answer

at least one subtype.

Question 26

Which of the following statements is true about the figure shown below?

Accepted Answer

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

Answer

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

Answer

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

Answer

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.

Question 27

Which of the following statements is true about the figure shown below?

Accepted Answer

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

Answer

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

Answer

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

Answer

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.

Question 28

Which of the following statements is true about the figure shown below?

Accepted Answer

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

Answer

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

Answer

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

Answer

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.

Question 29

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.

Accepted Answer

supertypes

Answer

subtypes

Answer

constraints

Answer

dimensions

Question 30

The following figure shows a:

Accepted Answer

supertype/subtype hierarchy.

Answer

disjoint constraint.

Answer

completeness constraint.

Answer

spindle constraint.

Question 31

Which statement is true about the following diagram?

Accepted Answer

A person can only be a faculty, student, or staff.

Answer

A student can be both an undergraduate and a graduate student at the same time.

Answer

All attributes of person and student are inherited by undergraduate.

Answer

All attributes of graduate are inherited by person.

Question 32

An entity cluster is:

Accepted Answer

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

Answer

a formal method for specifying attributes of related entities.

Answer

a useful way to present data for a small and fairly simple organization.

Answer

a way of developing more granular views of the data model.

Question 33

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

Accepted Answer

entity cluster.

Answer

supertype/subtype hierarchy.

Answer

hierarchical data model.

Answer

column cluster.

Question 34

An entity cluster can be formed by:

Accepted Answer

combining a strong entity and its weak entities.

Answer

deleting a supertype and its subtype.

Answer

combining metadata.

Answer

deleting metadata.

Question 35

Packaged data models:

Accepted Answer

require customization.

Answer

are ready to use right out of the box.

Answer

allow partial specialization.

Answer

cannot be used for most applications.

Question 36

Which of the following is true of packaged data models?

Accepted Answer

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

Answer

All subtype/supertype relationships follow the total specialization and disjoint rules.

Answer

No entities on the many sides of a relationship can be weak.

Answer

All weak entities are considered strong.

Question 37

A generic or template data model that can be reused as a starting point for a data modeling project is called a(n):

Accepted Answer

universal data model.

Answer

packaged data model.

Answer

enterprise data model.

Answer

collection data model.

Question 38

Using a packaged data model, projects take less time and cost because:

Accepted Answer

essential components and structures are already defined.

Answer

less personnel are required.

Answer

there is more time taken to model the enterprise.

Answer

packaged data models only run in Oracle.

Question 39

All of the following are advantages of packaged data models EXCEPT:

Accepted Answer

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

Answer

packaged data models can be built using proven components evolved from cumulative experiences.

Answer

projects take less time and cost less.

Answer

the data model is easier to evolve.

Question 40

All of the following are steps to using a packaged data model EXCEPT:

Accepted Answer

utilize all business rules that come with the packaged data model.

Answer

identify the parts of the data model that apply to your data modeling situation.

Answer

rename the identified data elements.

Answer

map data to be used in packages with existing data in the current databases.

Question 41

When identifying the parts of the packaged data model that apply to your organization, one should first start with:

Accepted Answer

entities.

Answer

attributes.

Answer

primary keys.

Answer

relationships.

Question 42

The third step in the data modeling process with a packaged data model is:

Accepted Answer

map data to be used from package to data in current databases.

Answer

rename identified data elements.

Answer

rename relationships.

Answer

interview users.

Question 43

A good method for identifying inconsistencies and finding hidden meaning in the customized purchased data model is:

Accepted Answer

data profiling.

Answer

data analysis.

Answer

data volume usage analysis.

Answer

user interviews.

Question 44

The most important challenge of customizing a purchased data model is:

Accepted Answer

determining the business rules that will be established through the data model.

Answer

getting user buy-in.

Answer

implementation.

Answer

user training.

Question 45

In packaged data models, strong entities always have ________ between them.

Accepted Answer

M:N relationships

Answer

weak entities

Answer

1:1 relationships

Answer

1:M relationships

Question 46

In packaged data models, all subtype/supertype relationships follow the ________ and ________ rules.

Accepted Answer

total specialization; overlap

Answer

partial specialization; disjoint

Answer

total specialization; disjoint

Answer

partial specialization; overlap

Question 47

A subtype is a generic entity that has a relationship with one or more entities at a lower level.

Accepted Answer

False

Answer

True

Question 48

An entity instance of a subtype represents the same entity instance of the supertype.

Accepted Answer

True

Answer

False

Question 49

A member of a subtype does NOT necessarily have to be a member of the supertype.

Accepted Answer

False

Answer

True

Question 50

Supertype/subtype relationships should not be used when the instances of a subtype participate in no relationships which are unique to that subtype.

Accepted Answer

True

Answer

False

Question 51

One of the major challenges in data modeling is to recognize and clearly represent entities that are almost the same.

Accepted Answer

True

Answer

False

Question 52

The following figure is an example of total specialization.

Accepted Answer

False

Answer

True

Question 53

Specialization is the reverse of generalization.

Accepted Answer

True

Answer

False

Question 54

The total specialization rule states that an entity instance of a supertype is allowed not to belong to any subtype.

Accepted Answer

False

Answer

True

Question 55

Generalization is a top-down process.

Accepted Answer

False

Answer

True

Question 56

A completeness constraint may specify that each entity of the supertype must be a member of some subtype in the relationship.

Accepted Answer

True

Answer

False

Question 57

When the total specialization rule is set for a supertype/subtype relationship, one could roughly compare the supertype to an abstract class in object-oriented programming.

Accepted Answer

False

Answer

True

Question 58

The disjoint rule specifies that if an entity instance of the supertype is a member of one subtype, it MUST simultaneously be a member of another subtype.

Accepted Answer

False

Answer

True

Question 59

The overlap rule specifies that if an entity instance of the supertype is a member of one subtype, it can simultaneously be a member of two (or more) subtypes.

Accepted Answer

True

Answer

False

Question 60

The following figure is an example of the overlap rule.

Accepted Answer

False

Answer

True

Question 61

When subtypes are overlapping, an additional field must be added to the supertype to act as a discriminator.

Accepted Answer

False

Answer

True

Question 62

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

Accepted Answer

True

Answer

False

Question 63

A subtype can become a supertype if the subtype has other subtypes beneath it.

Accepted Answer

True

Answer

False

Question 64

The following diagram is an example of a supertype/subtype hierarchy.

Accepted Answer

True

Answer

False

Topic 3

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Science