Exam 4: Data Modeling and the Entity Relationship Model

Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the ________.

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

Microsoft Access ________ allow easy mock-ups of forms and reports for prototyping.

A use case can be used to perform which of the following tasks?

The number of entity classes involved in a relationship is the cardinality of the relationship.

In crow's foot E-R notation,a circle indicates a minimum cardinality of zero.

The E-R Model assumes that all instances of a given entity class have the same attributes.

A(n)________ is a working demonstration of selected portions of the future system.

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

Distinguish between an entity class and an entity instance.

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

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

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

Microsoft Access database files can be easily ________ to create multiple copies of a database.

An entity cannot be both weak and strong.

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

Microsoft Access can be used to build a prototype database,which allows users to validate the data model by demonstrating the consequences of data modeling decisions.

Explain the ambiguity in the broad definition of a weak entity.

What are "business rules" and what is their role in database design?

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