Question 1

Distinguish between entity identifiers and keys.

Accepted Answer

The answer of Distinguish between entity identifiers and keys....

Question 2

The ________ is a representation of the content,relationships,and constraints of the data needed to support the system requirements.

Accepted Answer

The answer of The ________ is a representation of the...

Question 3

What is a "use case" and how is it used?

Accepted Answer

The answer of What is a "use case" and how...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Changing aspects of a source document is much more difficult than changing the actual database,once constructed.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is not a basic element of the E-R Model?

Accepted Answer

A)  Identifiers 
B)  Entities 
C)  Cardinalities 
D)  Use cases 
E)  Relationships

Question 7

A nonidentifying relationship exists between an ID-dependent entity and its parent.

Accepted Answer

A) True 
 B)False

Question 8

Use cases can be used to validate the data model,design,and implementation.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following would not be contained in a use case?

Accepted Answer

A)  Inputs provided to the system to perform a task 
B)  A description of a task the user wants to perform 
C)  A prototype of the system performing a given task 
D)  Outputs generated by the system in performing a given task 
E)  An activity scenario

Question 10

Microsoft Access is only used to prototype databases where Microsoft Access itself will be the final DBMS.

Accepted Answer

A) True 
 B)False

Question 11

Given only the following excerpt of an E-R model:

Which of the following is known to be true?

Accepted Answer

A)  A single instance of ENTITY A must be related to one instance of ENTITY B. 
B)  Many instances of ENTITY A may be related to one instance of ENTITY B. 
C)  ENTITY B has a degree of many. 
D)  ENTITY B is a weak entity. 
E)  Both A and C are true.

Question 12

A PRODUCT entity instance is the collection of all PRODUCT entity classes.

Accepted Answer

A) True 
 B)False

Question 13

In crow's foot style E-R diagrams,an entity class is represented by a(n)________.

Accepted Answer

The answer of In crow's foot style E-R diagrams,an entity...

Question 14

One or more entities can be associated together in relationships.

Accepted Answer

A) True 
 B)False

Question 15

In crow's foot style E-R diagrams,a circle 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 C

Question 16

Because of its forms and reports wizards,________ can be used to build a prototype database for many different other operational DBMS.

Accepted Answer

The answer of Because of its forms and reports wizards,________...

Question 17

Unified Modeling Language (UML)has quickly replaced the E-R Model as the most popular technique for creating data models.

Accepted Answer

A) True 
 B)False

Question 18

The Microsoft Access report editor is a(n)________.

Accepted Answer

A)  banded report editor 
B)  wizard-based report editor 
C)  ASCII report editor 
D)  WYSIWYG report editor 
E)  Web-based report editor

Question 19

________ can be used to build prototype databases.

Accepted Answer

The answer of ________ can be used to build prototype...

Question 20

In crow's foot style E-R diagrams,a single entity together with a related set of entities that each contain specific sets of attributes related to the single entity represent ________.

Accepted Answer

A)  a strong entity relationship 
B)  an ID-dependent weak entity relationship 
C)  a non-ID-dependent weak entity relationship 
D)  a supertype /subtype relationship 
E)  a recursive entity relationship

Exam 4: Data Modeling and the Entity Relationship Model

Distinguish between entity identifiers and keys.

The ________ is a representation of the content,relationships,and constraints of the data needed to support the system requirements.

What is a "use case" and how is it used?

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

Changing aspects of a source document is much more difficult than changing the actual database,once constructed.

Which of the following is not a basic element of the E-R Model?

A nonidentifying relationship exists between an ID-dependent entity and its parent.

Use cases can be used to validate the data model,design,and implementation.

Which of the following would not be contained in a use case?

Microsoft Access is only used to prototype databases where Microsoft Access itself will be the final DBMS.

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

A PRODUCT entity instance is the collection of all PRODUCT entity classes.

In crow's foot style E-R diagrams,an entity class is represented by a(n)________.

One or more entities can be associated together in relationships.

In crow's foot style E-R diagrams,a circle across the relationship line near an entity indicates ________.

Because of its forms and reports wizards,________ can be used to build a prototype database for many different other operational DBMS.

Unified Modeling Language (UML)has quickly replaced the E-R Model as the most popular technique for creating data models.

The Microsoft Access report editor is a(n) ________.

________ can be used to build prototype databases.

In crow's foot style E-R diagrams,a single entity together with a related set of entities that each contain specific sets of attributes related to the single entity represent ________.