Question 1

A binary relationship is a relationship between two or more entities.

Accepted Answer

A) True 
 B)False

Question 2

An ID-dependent entity is an entity whose identifier includes the identifier of another entity.

Accepted Answer

A) True 
 B)False

Question 3

For a relationship to be considered a binary relationship it must satisfy which of the following conditions?

Accepted Answer

A)  It must involve exactly two entity classes.
B)  It must have a maximum cardinality of 1:1.
C)  It must have a maximum cardinality of 1:N.
D)  A and B
E)  A and C

Question 4

To represent an archetype/instance pattern in an E-R model,________.

Accepted Answer

A)  create a new ID-dependent entity with a 1:N relationship
B)  create a new weak,but not ID-dependent entity with a 1:N relationship
C)  create a new strong entity with a 1:1 relationship
D)  create a new ID-dependent entity with a 1:1 relationship
E)  create a new weak,but not ID-dependent entity with a 1:1 relationship

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

Relationships among instances of a single entity class are called redundant relationships.

Accepted Answer

A) True 
 B)False

Question 9

Distinguish between an entity class and an entity instance.

Accepted Answer

An entity class is the collection of all...

Question 10

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 11

Entities of a given type are grouped into an ________.

Accepted Answer

A)  entity class
B)  entity relationship
C)  entity instance
D)  entity attribute
E)  None of the above.

Question 12

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 13

A binary relationship is a relationship based on numerical entity instance identifiers.

Accepted Answer

A) True 
 B)False

Question 14

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 15

Subtypes can be exclusive or inclusive.

Accepted Answer

A) True 
 B)False

Question 16

Discriminators can be ________.

Accepted Answer

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

Question 17

A weak entity is an entity that cannot exist in the database without (and is logically dependent upon)another type of entity also existing in the database.

Accepted Answer

A) True 
 B)False

Question 18

An entity that holds specialized attributes that distinguish it from one or more other similar entities is a ________.

Accepted Answer

A)  supertype
B)  subtype
C)  discriminator
D)  A and C
E)  B and C

Question 19

One example of a database design using an ID-dependent relationship is the association pattern.

Accepted Answer

A) True 
 B)False

Question 20

Recursive relationships only exist for one-to-one relationships.

Accepted Answer

A) True 
 B)False

Exam 5: Data Modeling With the Entity-Relationship Model

Recursive relationships can have which of the following maximum cardinalities?

Correct AnswerverifiedShow Answer

Recursive relationships only exist for one-to-one relationships.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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 entity that holds specialized attributes that distinguish it from one or more other similar entities is a ________.

Correct AnswerverifiedShow Answer

For a relationship to be considered a binary relationship it must satisfy which of the following conditions?

Correct AnswerverifiedShow Answer

Subtypes can be exclusive or inclusive.

Correct AnswerverifiedShow Answer

A binary relationship is a relationship based on numerical entity instance identifiers.

Correct AnswerverifiedShow Answer

Which of the following is not true about subtype entities?

Correct AnswerverifiedShow Answer

Discriminators can be ________.

Correct AnswerverifiedShow Answer

One example of a database design using an ID-dependent relationship is the association pattern.

Correct AnswerverifiedShow Answer

A binary relationship is a relationship between two or more entities.

Correct AnswerverifiedShow Answer

Relationships among instances of a single entity class are called redundant relationships.

Correct AnswerverifiedShow Answer

A weak entity is an entity that cannot exist in the database without (and is logically dependent upon)another type of entity also existing in the database.

Correct AnswerverifiedShow Answer

An ID-dependent entity is an entity whose identifier includes the identifier of another entity.

Correct AnswerverifiedShow Answer

Distinguish between an entity class and an entity instance.

Correct AnswerverifiedAn entity class is the collection of all...View AnswerShow Answer

Entities of a given type are grouped into an ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

To represent an archetype/instance pattern in an E-R model,________.

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
An entity class is the collection of all...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified