Question 1

A dashed line between entities indicates:

Accepted Answer

A)  a unique identifier.
B)  a minimum cardinality of zero.
C)  a minimum cardinality of one.
D)  an identifying relationship.
E)  a nonidentifying relationship.F) A) and B)
G) All of the above

Question 2

In crow's foot style E-R diagrams,a hash mark across the relationship line near an entity indicates:

Accepted Answer

A)  a minimum cardinality of zero.
B)  a minimum cardinality of one.
C)  a maximum cardinality of one.
D)  a maximum cardinality of many.
E)  Both B and CF) A) and D)
G) C) and D)

Question 3

Which of the following is true about identifiers of entities?

Accepted Answer

A)  Identifiers must be unique.
B)  Identifiers are not normally used in a naming role.
C)  The value of an identifier may identify a set of entity instances.
D)  Identifiers may not be more than two attributes.
E)  An identifier in the E-R model is equivalent to a key in the relational model.F) A) and B)
G) C) and E)

Question 4

In the Entity-Relationship data model,all instances of an entity of a given type are grouped into:

Accepted Answer

A)  entity objects.
B)  class objects.
C)  entity classes.
D)  identifiers.
E)  entity attributes.F) All of the above
G) A) and B)

Question 5

________ can be used to build prototype databases.

Accepted Answer

Microsoft ...

Question 6

It is possible for an entity to have a relationship to itself.

Accepted Answer

A) True 
 B)False

Question 7

An entity that must logically depend on another entity is called a(n)________ entity.

Accepted Answer

The answer of An entity that must logically depend on...

Question 8

Given only the following excerpt of an E-R model: 
Which of the following is known to be true?

Accepted Answer

A)  There are more instances of ENTITY A than there are instances of ENTITY B in the user's environment.
B)  A single instance of ENTITY B may be related to many instances of ENTITY A.
C)  A single instance of ENTITY A must be related to many instances of ENTITY B.
D)  ENTITY A has a minimum cardinality of one.
E)  The degree of the relationship is "many."F) C) and E)
G) A) and D)

Question 9

The number of entity classes involved in a relationship is known as the relationship's:

Accepted Answer

A)  maximum cardinality.
B)  minimum cardinality.
C)  ordinality.
D)  degree.
E)  class.F) B) and C)
G) C) and D)

Question 10

Distinguish between an entity class and an entity instance.

Accepted Answer

An entity class is the collection of all...

Question 11

There is usually only one instance of an entity in an entity class.

Accepted Answer

A) True 
 B)False

Question 12

Distinguish between entity identifiers and keys.

Accepted Answer

An entity identifier is an attribute or ...

Question 13

During the implementation phase of developing a database system,the data model is transformed into a database design.

Accepted Answer

A) True 
 B)False

Question 14

In crow's foot E-R notation,the crow's foot indicates a maximum cardinality of one.

Accepted Answer

A) True 
 B)False

Question 15

During the design phase of developing a database system,the users are asked about the need for changes to existing forms and reports.

Accepted Answer

A) True 
 B)False

Question 16

Maximum cardinality indicates whether or not an instance of one entity class must be related to at least one instance of another entity class.

Accepted Answer

A) True 
 B)False

Exam 4: Data Modeling and the Entity Relationship Model

Which of the following is true about identifiers of entities?

Correct Answer
verified

In crow's foot E-R notation,the crow's foot indicates a maximum cardinality of one.

Correct Answer
verified

During the design phase of developing a database system,the users are asked about the need for changes to existing forms and reports.

Correct Answer
verified

A dashed line between entities indicates:

Correct Answer
verified

In the Entity-Relationship data model,all instances of an entity of a given type are grouped into:

Correct Answer
verified

In crow's foot style E-R diagrams,a hash mark across the relationship line near an entity indicates:

Correct Answer
verified

Distinguish between an entity class and an entity instance.

Correct Answer
verified
An entity class is the collection of all...
View Answer

During the implementation phase of developing a database system,the data model is transformed into a database design.

Correct Answer
verified

________ can be used to build prototype databases.

Correct Answer
verified
Microsoft ...
View Answer

There is usually only one instance of an entity in an entity class.

Correct Answer
verified

It is possible for an entity to have a relationship to itself.

Correct Answer
verified

Maximum cardinality indicates whether or not an instance of one entity class must be related to at least one instance of another entity class.

Correct Answer
verified

Given only the following excerpt of an E-R model: Which of the following is known to be true?

Correct Answer
verified

An entity that must logically depend on another entity is called a(n)________ entity.

Correct Answer
verified

Distinguish between entity identifiers and keys.

Correct Answer
verified
An entity identifier is an attribute or ...
View Answer

The number of entity classes involved in a relationship is known as the relationship's:

Correct Answer
verified

Exam 4: Data Modeling and the Entity Relationship Model

Which of the following is true about identifiers of entities?

Correct AnswerverifiedShow Answer

In crow's foot E-R notation,the crow's foot indicates a maximum cardinality of one.

Correct AnswerverifiedShow Answer

During the design phase of developing a database system,the users are asked about the need for changes to existing forms and reports.

Correct AnswerverifiedShow Answer

A dashed line between entities indicates:

Correct AnswerverifiedShow Answer

In the Entity-Relationship data model,all instances of an entity of a given type are grouped into:

Correct AnswerverifiedShow Answer

In crow's foot style E-R diagrams,a hash mark across the relationship line near an entity indicates:

Correct AnswerverifiedShow Answer

Distinguish between an entity class and an entity instance.

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

During the implementation phase of developing a database system,the data model is transformed into a database design.

Correct AnswerverifiedShow Answer

________ can be used to build prototype databases.

Correct AnswerverifiedMicrosoft ...View AnswerShow Answer

There is usually only one instance of an entity in an entity class.

Correct AnswerverifiedShow Answer

It is possible for an entity to have a relationship to itself.

Correct AnswerverifiedShow Answer

Maximum cardinality indicates whether or not an instance of one entity class must be related to at least one instance of another entity class.

Correct AnswerverifiedShow Answer

Given only the following excerpt of an E-R model: Which of the following is known to be true?

Correct AnswerverifiedShow Answer

An entity that must logically depend on another entity is called a(n)________ entity.

Correct AnswerverifiedShow Answer

Distinguish between entity identifiers and keys.

Correct AnswerverifiedAn entity identifier is an attribute or ...View AnswerShow Answer

The number of entity classes involved in a relationship is known as the relationship's:

Correct AnswerverifiedShow Answer

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
Microsoft ...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
An entity identifier is an attribute or ...
View Answer

Correct Answer
verified