Question 1

In a minimum cardinality,minimums are generally stated as ________.

Accepted Answer

A)  0
B)  1
C)  N
D)  A or B
E)  A,B,or C

Question 2

Attributes may be ________.

Accepted Answer

A)  composite
B)  element
C)  multivalued
D)  A and C
E)  B and C

Question 3

Which of the following is not a key element of an E-R model?

Accepted Answer

A)  Identifiers
B)  Entities
C)  Objects
D)  Attributes
E)  Relationships

Question 4

To represent an association pattern in an E-R model,________.

Accepted Answer

A)  create a new ID-dependent entity with a 1:1 relationship to one other entity
B)  create a new weak,but not ID-dependent entity with a 1:1 relationship to one other entity
C)  create a new strong entity with a 1:1 relationship to one other entity
D)  create a new ID-dependent entity with a 1:N relationship to one of two parent entities
E)  create a new weak,but not ID-dependent entity with a 1:N relationship to one of two parent entities

Question 5

A hash mark 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. D

Question 6

How is minimum cardinality expressed in IE Crow's Foot E-R diagrams?

Accepted Answer

The Crow's Foot E-R diagram notation uses a circle to indicate a minimum cardinality of zero (or "optional")and a hash mark to indicate a minimum cardinality of one (or "mandatory").Each symbol is placed on the relationship line just beyond the symbol indicating maximum cardinality.

Question 7

A relationship's minimum cardinality indicates the number of entity instances that must participate in the relationship.

Accepted Answer

A) True 
 B)False  True

Question 8

In a 1:N relationship,the parent entity is on the one side of the relationship,and the child entity is on the many side of the relationship.

Accepted Answer

A) True 
 B)False

Question 9

E-R modeling recognizes both relationship classes and relationship instances.

Accepted Answer

A) True 
 B)False

Question 10

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 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above.What does the symbol next to the ORDER 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 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

An entity is something that users want to track.

Accepted Answer

A) True 
 B)False

Question 17

An entity instance is the occurrence of a particular entity.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

Entities containing optional sets of attributes are often represented using subtypes.

Accepted Answer

A) True 
 B)False

Question 20

The occurrence of a particular entity is called an ________.

Accepted Answer

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

Exam 5: Data Modeling With the Entity-Relationship Model

In a minimum cardinality,minimums are generally stated as ________.

Correct Answer
verified

Attributes may be ________.

Correct Answer
verified

Which of the following is not a key element of an E-R model?

Correct Answer
verified

To represent an association pattern in an E-R model,________.

Correct Answer
verified

A hash mark across the relationship line near an entity indicates ________.

Correct Answer
verified
D

How is minimum cardinality expressed in IE Crow's Foot E-R diagrams?

A relationship's minimum cardinality indicates the number of entity instances that must participate in the relationship.

Correct Answer
verified
True

In a 1:N relationship,the parent entity is on the one side of the relationship,and the child entity is on the many side of the relationship.

Correct Answer
verified

E-R modeling recognizes both relationship classes and relationship instances.

Correct Answer
verified

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 Answer
verified

Maximum cardinality refers to ________.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

An entity is something that users want to track.

Correct Answer
verified

An entity instance is the occurrence of a particular entity.

Correct Answer
verified

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

Correct Answer
verified

Entities containing optional sets of attributes are often represented using subtypes.

Correct Answer
verified

The occurrence of a particular entity is called an ________.

Correct Answer
verified

Exam 5: Data Modeling With the Entity-Relationship Model

In a minimum cardinality,minimums are generally stated as ________.

Correct AnswerverifiedShow Answer

Attributes may be ________.

Correct AnswerverifiedShow Answer

Which of the following is not a key element of an E-R model?

Correct AnswerverifiedShow Answer

To represent an association pattern in an E-R model,________.

Correct AnswerverifiedShow Answer

A hash mark across the relationship line near an entity indicates ________.

Correct AnswerverifiedD

How is minimum cardinality expressed in IE Crow's Foot E-R diagrams?

A relationship's minimum cardinality indicates the number of entity instances that must participate in the relationship.

Correct AnswerverifiedTrue

In a 1:N relationship,the parent entity is on the one side of the relationship,and the child entity is on the many side of the relationship.

Correct AnswerverifiedShow Answer

E-R modeling recognizes both relationship classes and relationship instances.

Correct AnswerverifiedShow Answer

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

Maximum cardinality refers to ________.

Correct AnswerverifiedShow Answer

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

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 ORDER entity indicate?

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

An entity is something that users want to track.

Correct AnswerverifiedShow Answer

An entity instance is the occurrence of a particular entity.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Entities containing optional sets of attributes are often represented using subtypes.

Correct AnswerverifiedShow Answer

The occurrence of a particular entity is called an ________.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified
True

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