Question 1

An attribute that determines which subtype should be used is a(n) ________.

Accepted Answer

A)  supertype
B)  subtype
C)  discriminator
D)  identifier

Question 2

What is an ID-Dependent entity? Include an example.

Accepted Answer

There are some entities that cannot be c...

Question 3

The notation 1:N shows a relationship's maximum cardinalities.

Accepted Answer

A) True 
 B)False

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

Question 5

Recursive relationships can have all of the following maximum cardinalities except ________.

Accepted Answer

A)  1:1
B)  1:N
C)  N:M
D)  M:M

Question 6

The characteristics of a thing are described by its ________.

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

ID-dependent entities are a common type of weak entity.

Accepted Answer

A) True 
 B)False

Question 9

An entity is something that users want to track.

Accepted Answer

A) True 
 B)False

Question 10

Entities of a given type are grouped into entity classes.

Accepted Answer

A) True 
 B)False

Question 11

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"

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

ID-dependent entities are associated by a nonidentifying relationship.

Accepted Answer

A) True 
 B)False

Question 14

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 N:1 relationships to two parent entities

Question 15

Entities with an IS-A relationship should have the same identifier.

Accepted Answer

A) True 
 B)False

Question 16

You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above,and are asked to draw the relationship between them.If a given customer can place many orders and a given order can be placed by at most one customer,which of the following should be indicated in the relationship symbol between the two entities?

Accepted Answer

A)  N:M
B)  1:1
C)  1:N
D)  N:1

Question 17

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

Accepted Answer

The Crow's Foot E-R diagram notation use...

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)  parent

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 5: Data Modeling With the Entity-Relationship Model

Correct Answer
verified

Recursive relationships can have all of the following maximum cardinalities except ________.

Correct Answer
verified

What is an ID-Dependent entity? Include an example.

Correct Answer
verified
There are some entities that cannot be c...
View Answer

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

Correct Answer
verified

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

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

Correct Answer
verified

ID-dependent entities are a common type of weak entity.

Correct Answer
verified

ID-dependent entities are associated by a nonidentifying relationship.

Correct Answer
verified

The notation 1:N shows a relationship's maximum cardinalities.

Correct Answer
verified

The characteristics of a thing are described by its ________.

Correct Answer
verified

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

Correct Answer
verified

An attribute that determines which subtype should be used is a(n) ________.

Correct Answer
verified

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

Correct Answer
verified

Entities of a given type are grouped into entity classes.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
The Crow's Foot E-R diagram notation use...
View Answer

An entity is something that users want to track.

Correct Answer
verified

Entities with an IS-A relationship should have the same identifier.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Exam 5: Data Modeling With the Entity-Relationship Model

Correct AnswerverifiedShow Answer

Recursive relationships can have all of the following maximum cardinalities except ________.

Correct AnswerverifiedShow Answer

What is an ID-Dependent entity? Include an example.

Correct AnswerverifiedThere are some entities that cannot be c...View AnswerShow Answer

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

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

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

Correct AnswerverifiedShow Answer

ID-dependent entities are a common type of weak entity.

Correct AnswerverifiedShow Answer

ID-dependent entities are associated by a nonidentifying relationship.

Correct AnswerverifiedShow Answer

The notation 1:N shows a relationship's maximum cardinalities.

Correct AnswerverifiedShow Answer

The characteristics of a thing are described by its ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

An attribute that determines which subtype should be used is a(n) ________.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Entities of a given type are grouped into entity classes.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedThe Crow's Foot E-R diagram notation use...View AnswerShow Answer

An entity is something that users want to track.

Correct AnswerverifiedShow Answer

Entities with an IS-A relationship should have the same identifier.

Correct AnswerverifiedShow Answer

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

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
There are some entities that cannot be c...
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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The Crow's Foot E-R diagram notation use...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified