Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)   exclusion
B)   disjoint
C)   removal
D)   inclusionE) None of the above
F) A) and B)

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

Discuss the reasoning behind using supertype/subtype relationships.

Accepted Answer

It is best to use a supertype/subtype hi...

Question 5

Packaged data models use an entity type to store union data.

Accepted Answer

A) True 
 B)False

Question 6

Discuss how attributes are assigned in a supertype/subtype hierarchy.

Accepted Answer

Attributes are assigned at the highest l...

Question 7

Which of the following is true of packaged data models?

Accepted Answer

A)   Relationships are connected to the highest-level entity type in an order that makes sense.
B)   All subtype/supertype relationships follow the total specialization and disjoint rules.
C)   No entities on the many sides of a relationship can be weak.
D)   All weak entities are considered strong.E) A) and D)
F) B) and C)

Question 8

Packaged data models can be developed using proven components.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Compare and contrast generalization and specialization.

Accepted Answer

Generalization is the process of definin...

Question 11

Because a purchased data model is extensive, you begin by identifying the parts of the data model that apply to your data modeling situation.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)   determinant.
B)   subtype decision.
C)   disjoint indicator.
D)   subtype discriminator.E) All of the above
F) None of the above

Question 13

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

Accepted Answer

A)   disjointedness constraint
B)   disjoint rule
C)   partial specialization
D)   total specializationE) A) and B)
F) None of the above

Question 14

Packaged data models are meant to be customized.

Accepted Answer

A) True 
 B)False

Question 15

The following diagram shows:

Accepted Answer

A)   total specialization.
B)   partial specialization.
C)   the overlap rule.
D)   subtype discriminator.E) C) and D)
F) B) and C)

Question 16

The following figure shows an example of:

Accepted Answer

A)   the disjoint rule.
B)   the completeness rule.
C)   the underdog rule.
D)   the overlap rule.E) A) and D)
F) A) and C)

Question 17

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

Accepted Answer

A)   overlap rule.
B)   disjoint rule.
C)   partial specialization.
D)   full specialization.E) C) and D)
F) A) and B)

Question 18

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

Accepted Answer

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 at the 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 apartment and a house at the same time.E) A) and B)
F) B) and C)

Question 19

Discuss when one would use total specialization and when one would use partial specialization.

Accepted Answer

Total specialization would be used when ...

Question 20

The following figure is an example of the overlap rule.

Accepted Answer

A) True 
 B)False

Exam 3: The Enhanced E-R Model

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

Correct AnswerverifiedShow Answer

Packaged data models use an entity type to store union data.

Correct AnswerverifiedShow Answer

Discuss the reasoning behind using supertype/subtype relationships.

Correct AnswerverifiedIt is best to use a supertype/subtype hi...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

Discuss how attributes are assigned in a supertype/subtype hierarchy.

Correct AnswerverifiedAttributes are assigned at the highest l...View AnswerShow Answer

Compare and contrast generalization and specialization.

Correct AnswerverifiedGeneralization is the process of definin...View AnswerShow Answer

Packaged data models can be developed using proven components.

Correct AnswerverifiedShow Answer

The following figure is an example of the overlap rule.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Discuss when one would use total specialization and when one would use partial specialization.

Correct AnswerverifiedTotal specialization would be used when ...View AnswerShow Answer

The following diagram shows:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Packaged data models are meant to be customized.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Because a purchased data model is extensive, you begin by identifying the parts of the data model that apply to your data modeling situation.

Correct AnswerverifiedShow Answer

Which of the following is true of packaged data models?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The following figure shows an example of:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
It is best to use a supertype/subtype hi...
View Answer

Correct Answer
verified

Correct Answer
verified
Attributes are assigned at the highest l...
View Answer

Correct Answer
verified
Generalization is the process of definin...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Total specialization would be used when ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified