Question 1

When an entity has a relationship to itself,we have a(n) ________.

Accepted Answer

A)  supertype/subtype relationship
B)  archetype/instance relationship
C)  recursive relationship
D)  A or C
E)  B or C

Question 2

An entity that represents something that can exist on its own is called a strong entity.

Accepted Answer

A) True 
 B)False

Question 3

Maximum cardinality refers to ________.

Accepted Answer

A)  the most instances of one entity class that can be involved in a relationship instance with another entity class
B)  the minimum number of entity classes involved in a relationship
C)  whether or not an instance of one entity class is required to be related to an instance of another entity class
D)  whether or not an entity is a weak entity
E)  None of the above.

Question 4

The characteristics of a thing are described by its ________.

Accepted Answer

A)  identifiers
B)  entities
C)  objects
D)  attributes
E)  relationships

Question 5

In an E-R model,the three types of maximum cardinality are 1:1,1:N and N:M.

Accepted Answer

A) True 
 B)False

Question 6

The method of constructing data models used in the text is the extended entity-relationship (E-R)model.

Accepted Answer

A) True 
 B)False

Question 7

Recursive relationships can have which of the following maximum cardinalities?

Accepted Answer

A)  1:1
B)  1:N
C)  N:M
D)  A or B
E)  A,B or C

Question 8

A circle across the relationship line near an entity indicates ________.

Accepted Answer

A)  a maximum cardinality of "zero"
B)  a maximum cardinality of "one"
C)  a minimum cardinality of "optional"
D)  a minimum cardinality of "required"
E)  None of the above.

Question 9

An identifier of an entity instance must consist of one and only one attribute.

Accepted Answer

A) True 
 B)False

Question 10

In E-R modeling,entities within an entity class may have different attributes.

Accepted Answer

A) True 
 B)False

Question 11

-You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above.What does the symbol next to the CUSTOMER entity indicate?

Accepted Answer

A)  A maximum cardinality of "zero"
B)  A maximum cardinality of "one"
C)  A minimum cardinality of "optional"
D)  A minimum cardinality of "required"
E)  None of the above.

Question 12

A composite identifier is defined as a composite attribute that is an identifier.

Accepted Answer

A) True 
 B)False

Question 13

In E-R modeling,an attribute describes the characteristics of an entity.

Accepted Answer

A) True 
 B)False

Question 14

An entity whose existence depends on the presence of another entity,but whose identifier does not include the identifier of the other entity is a(n) ________.

Accepted Answer

A)  strong entity
B)  weak entity
C)  ID-dependent entity
D)  A and C
E)  B and C

Question 15

Data modelers agree that weak,non-ID-dependent entities exist and are important.

Accepted Answer

A) True 
 B)False

Question 16

An exclusive subtype pattern has one supertype entity that relates to one or more subtype entities.

Accepted Answer

A) True 
 B)False

Question 17

An identifier of an entity instance is one or more attributes that name or identify entity instances.

Accepted Answer

A) True 
 B)False

Question 18

In a 1:N relationship,the term parent refers to the N side of the relationship.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is not true about subtype entities?

Accepted Answer

A)  Subtypes may be exclusive.
B)  The supertype and subtypes will have the same identifier.
C)  Subtypes are used to avoid a situation in which some attributes are required to be null.
D)  Subtypes have attributes that are required by the supertype.
E)  Subtypes can produce a closer-fitting data model.

Question 20

Discriminators can be ________.

Accepted Answer

A)  exclusive only
B)  inclusive only
C)  decisive only
D)  A or B
E)  B or C

Exam 5: Data Modeling With the Entity-Relationship Model

An entity whose existence depends on the presence of another entity,but whose identifier does not include the identifier of the other entity is a(n) ________.

Correct AnswerverifiedShow Answer

In E-R modeling,an attribute describes the characteristics of an entity.

Correct AnswerverifiedShow Answer

An entity that represents something that can exist on its own is called a strong entity.

Correct AnswerverifiedShow Answer

An identifier of an entity instance must consist of one and only one attribute.

Correct AnswerverifiedShow Answer

A circle across the relationship line near an entity indicates ________.

Correct AnswerverifiedShow Answer

In E-R modeling,entities within an entity class may have different attributes.

Correct AnswerverifiedShow Answer

Maximum cardinality refers to ________.

Correct AnswerverifiedShow Answer

Data modelers agree that weak,non-ID-dependent entities exist and are important.

Correct AnswerverifiedShow Answer

In an E-R model,the three types of maximum cardinality are 1:1,1:N and N:M.

Correct AnswerverifiedShow Answer

In a 1:N relationship,the term parent refers to the N side of the relationship.

Correct AnswerverifiedShow Answer

Which of the following is not true about subtype entities?

Correct AnswerverifiedShow Answer

When an entity has a relationship to itself,we have a(n) ________.

Correct AnswerverifiedShow Answer

Recursive relationships can have which of the following maximum cardinalities?

Correct AnswerverifiedShow Answer

A composite identifier is defined as a composite attribute that is an identifier.

Correct AnswerverifiedShow Answer

An identifier of an entity instance is one or more attributes that name or identify entity instances.

Correct AnswerverifiedShow Answer

-You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above.What does the symbol next to the CUSTOMER entity indicate?

Correct AnswerverifiedShow Answer

An exclusive subtype pattern has one supertype entity that relates to one or more subtype entities.

Correct AnswerverifiedShow Answer

Discriminators can be ________.

Correct AnswerverifiedShow Answer

The method of constructing data models used in the text is the extended entity-relationship (E-R)model.

Correct AnswerverifiedShow Answer

The characteristics of a thing are described by its ________.

Correct AnswerverifiedShow 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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified