Question 1

Packaged data models are as flexible as possible, because all supertype/subtype relationships allow the total specialization and overlap rules.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)   getting user buy-in.
B)   determining the business rules that will be established through the data model.
C)   implementation.
D)   user training.E) A) and D)
F) A) and C)

Question 3

An entity cluster should focus on some area of interest to some community of users, developers, or managers.

Accepted Answer

A) True 
 B)False

Question 4

Generalization is a top-down process.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A)   disjoint
B)   specialization
C)   generalization
D)   overlapE) B) and C)
F) All of the above

Question 7

In the figure below, a student:

Accepted Answer

A)   must be a graduate student, an undergraduate, a special student or some other type of student.
B)   must be a graduate student or an undergraduate student.
C)   must be at least a special student.
D)   must be a doctoral student.E) A) and B)
F) B) and C)

Question 8

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

Accepted Answer

A)   less personnel are required.
B)   essential components and structures are already defined.
C)   there is more time taken to model the enterprise.
D)   packaged data models only run in Oracle.E) B) and D)
F) C) and D)

Question 9

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

Accepted Answer

A)   Make
B)   Vehicle
C)   Model
D)   PriceE) A) and B)
F) A) and C)

Question 10

Subtypes should be used when:

Accepted Answer

A)   there are attributes that apply to some but not all instances of an entity type.
B)   supertypes relate to objects outside the business.
C)   the instances of a subtype do not participate in a relationship that is unique to that subtype.
D)   a recursive relationship is needed.E) A) and B)
F) C) and D)

Question 11

The most important challenge of customizing a purchased data model is determining the business rules that will be established through the data model.

Accepted Answer

A) True 
 B)False

Question 12

The subtype discriminator in the figure below is:

Accepted Answer

A)   Part_Type.
B)   Part_No.
C)   Manufactured Part.
D)   Location.E) A) and B)
F) All of the above

Question 13

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

A)   disjoint
B)   overlap
C)   completeness
D)   weakE) A) and D)
F) None of the above

Question 14

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

Accepted Answer

A)   semi-specialization
B)   total specialization
C)   partial specialization
D)   total convergenceE) B) and D)
F) C) and D)

Question 15

The following figure is an example of:

Accepted Answer

A)   partial specialization.
B)   completeness.
C)   total specialization.
D)   disjointness.E) A) and D)
F) A) and C)

Question 16

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

Accepted Answer

A)   specialization.
B)   generalization.
C)   creating discord.
D)   selecting classes.E) B) and C)
F) A) and D)

Question 17

Which statement is true about the following diagram?

Accepted Answer

A)   A person can only be a faculty, student, or staff.
B)   A student can be both an undergraduate and a graduate student at the same time.
C)   All attributes of person and student are inherited by undergraduate.
D)   All attributes of graduate are inherited by person.E) A) and D)
F) None of the above

Question 18

It is easy to miss the opportunity to visualize future requirements shown in the full data model when using a packaged data model.

Accepted Answer

A) True 
 B)False

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

Regardless of the business situation, a member of the supertype is always a member of more than one subtype.

Accepted Answer

A) True 
 B)False

Exam 3: The Enhanced E-R Model

Regardless of the business situation, a member of the supertype is always a member of more than one subtype.

Correct AnswerverifiedShow Answer

An entity cluster should focus on some area of interest to some community of users, developers, or managers.

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

Generalization is a top-down process.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The subtype discriminator in the figure below is:

Correct AnswerverifiedShow Answer

Subtypes should be used when:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

It is easy to miss the opportunity to visualize future requirements shown in the full data model when using a packaged data model.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The most important challenge of customizing a purchased data model is determining the business rules that will be established through the data model.

Correct AnswerverifiedShow Answer

In the figure below, a student:

Correct AnswerverifiedShow Answer

The following figure is an example of:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which statement is true about the following diagram?

Correct AnswerverifiedShow Answer

Packaged data models are as flexible as possible, because all supertype/subtype relationships allow the total specialization and overlap rules.

Correct AnswerverifiedShow Answer

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified