Question 1

How is the data modeling process different when starting with a purchased solution?

Accepted Answer

A packaged data model is quite extensive...

Question 2

In the figure shown below, a rental unit has to be either a house or an apartment.

Accepted Answer

A) True 
 B)False

Question 3

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

Question 4

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

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

Entity clustering is a methodology for grouping one or more entity types and associated relationships into a single abstract entity type.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A)   partial specialization; disjoint
B)   total specialization; disjoint
C)   total specialization; overlap
D)   partial specialization; overlapE) None of the above
F) All of the above

Question 8

The following figure is an example of total specialization.

Accepted Answer

A) True 
 B)False

Question 9

Contrast the overlap rule to the disjoint rule.

Accepted Answer

The disjoint rule is used when you wish ...

Question 10

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

Question 11

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

Accepted Answer

A)   Outpatient
B)   Physician
C)   Bed
D)   Date_HiredE) None of the above
F) B) and D)

Question 12

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

Accepted Answer

A)   identify the parts of the data model that apply to your data modeling situation.
B)   utilize all business rules that come with the packaged data model.
C)   rename the identified data elements.
D)   map data to be used in packages with existing data in the current databases.E) A) and B)
F) A) and C)

Question 13

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

Accepted Answer

A)   semi-specialization
B)   total specialization
C)   partial specialization
D)   disjointednessE) B) and C)
F) None of the above

Question 14

Explain why the E-R model needed to be expanded into the enhanced E-R model.

Accepted Answer

The business environment has drastically...

Question 15

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

Accepted Answer

A)   rename identified data elements.
B)   rename relationships.
C)   map data to be used from package to data in current databases.
D)   interview users.E) B) and C)
F) None of the above

Question 16

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

Accepted Answer

A)   disjoint
B)   overlap
C)   partial specialization
D)   total specializationE) A) and B)
F) B) and C)

Question 17

In the figure shown below, there could be an instance of a rental unit that is neither an apartment nor a house.

Accepted Answer

A) True 
 B)False

Question 18

Adapting a packaged data model from your DBMS vendor makes it difficult for the application to work with other applications from the same vendor.

Accepted Answer

A) True 
 B)False

Question 19

Generalization is a top-down process.

Accepted Answer

A) True 
 B)False

Question 20

You will never need to map data in current databases to data in a packaged data model.

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

You will never need to map data in current databases to data in a packaged data model.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In the figure shown below, a rental unit has to be either a house or an apartment.

Correct AnswerverifiedShow Answer

How is the data modeling process different when starting with a purchased solution?

Correct AnswerverifiedA packaged data model is quite extensive...View AnswerShow Answer

Adapting a packaged data model from your DBMS vendor makes it difficult for the application to work with other applications from the same vendor.

Correct AnswerverifiedShow Answer

Contrast the overlap rule to the disjoint rule.

Correct AnswerverifiedThe disjoint rule is used when you wish ...View AnswerShow Answer

Generalization is a top-down process.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

In the figure shown below, there could be an instance of a rental unit that is neither an apartment nor a house.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Explain why the E-R model needed to be expanded into the enhanced E-R model.

Correct AnswerverifiedThe business environment has drastically...View AnswerShow Answer

Entity clustering is a methodology for grouping one or more entity types and associated relationships into a single abstract entity type.

Correct AnswerverifiedShow Answer

In the figure below, a student:

Correct AnswerverifiedShow Answer

The following figure is an example of total specialization.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A packaged data model is quite extensive...
View Answer

Correct Answer
verified

Correct Answer
verified
The disjoint rule is used when you wish ...
View Answer

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The business environment has drastically...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified