Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

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) A) and B)
F) C) and D)

Question 4

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

A)   packaged data model.
B)   universal data model.
C)   enterprise data model.
D)   collection data model.E) None of the above
F) C) and D)

Question 5

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) All of the above

Question 6

An entity cluster is:

Accepted Answer

A)   a formal method for specifying attributes of related entities.
B)   a set of one or more entity types and associated relationships grouped into a single abstract entity type.
C)   a useful way to present data for a small and fairly simple organization.
D)   a way of developing more granular views of the data model.E) B) and D)
F) A) and B)

Question 7

Data models of an existing database are harder for data modelers to read.

Accepted Answer

A) True 
 B)False

Question 8

Describe how subtype discriminators are used when we have overlapping subtypes.

Accepted Answer

When we have overlapping subty...

Question 9

The subtype discriminator in the figure below is:

Accepted Answer

A)   Part_Type.
B)   Part_No.
C)   Manufactured Part.
D)   Location.E) A) and C)
F) A) and D)

Question 10

The following figure is an example of:

Accepted Answer

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

Question 11

In the figure shown below, a rental unit can be both an apartment and a house but must be at least one.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)   hierarchy reception.
B)   class management.
C)   attribute inheritance.
D)   generalization.E) A) and B)
F) A) and C)

Question 13

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 14

Mapping existing data to new data in a packaged data model is useful for developing migration plans.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A)   Checkback_Date
B)   Date_Discharged
C)   Patient_Name
D)   XMLE) A) and B)
F) A) and C)

Question 16

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) None of the above
F) A) and B)

Question 17

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) C) and D)
F) A) and C)

Question 18

Why are packaged data models gaining popularity?

Accepted Answer

Most organizations can no longer afford ...

Question 19

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 B)
F) A) and C)

Question 20

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)

Exam 3: The Enhanced E-R Model

In the figure shown below, a rental unit can be both an apartment and a house but must be at least one.

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 most important challenge of customizing a purchased data model is:

Correct AnswerverifiedShow Answer

The following figure is an example of:

Correct AnswerverifiedShow Answer

Why are packaged data models gaining popularity?

Correct AnswerverifiedMost organizations can no longer afford ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

Subtypes should be used when:

Correct AnswerverifiedShow Answer

Describe how subtype discriminators are used when we have overlapping subtypes.

Correct AnswerverifiedWhen we have overlapping subty...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

Data models of an existing database are harder for data modelers to read.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The subtype discriminator in the figure below is:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Mapping existing data to new data in a packaged data model is useful for developing migration plans.

Correct AnswerverifiedShow Answer

An entity cluster is:

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Most organizations can no longer afford ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
When we have overlapping subty...
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