Exam 4: Data Modeling and the Entity Relationship Model

Explain maximum cardinality.

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

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

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

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

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

An entity identifier can be either unique or nonunique.

Microsoft Access 2013 can be used to prototype databases for ________.

An ID-dependent entity is:

In crow's foot E-R notation,the hash mark indicates both a minimum cardinality of one and a maximum cardinality of one.

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

The Microsoft Access 2013 report editor is a(n):

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

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

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

How is minimum cardinality expressed in crow's foot E-R diagrams?

Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system?

Given only the following excerpt of an E-R model: If one instance of ENTITY B must be related to one and only one instance of ENTITY A,and one instance of ENTITY A may be related to many instances of ENTITY B,which of the following should be written on the end of the relationship line next to ENTITY B in the figure above?

Distinguish between a data model and a database design.

Identifiers of an entity that are composed of two or more attributes are called ________ identifiers.