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 ________.