Exam 4: Entity Relationship (ER)Modeling

A recursive relationship is one in which a relationship can exist between occurrences of the same entity set

When indicating cardinality,the first value represents the ____________________ number of associated entities.

Some ____ database modeling concepts can be expressed only using the Chen notation.

A ____ relationship exists when three entities are associated.

If the focus is on data-retrieval speed,you might also be forced to include ____ attributes in the design,which would not ordinarily be done.

____________________ are underlined in an ER diagram.

A derived attribute is indicated in the Chen model by a ____.

The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity.

Ideally,a primary key is composed of several attributes.

Complex ____ requirements may dictate data transformations,and they may expand the number of entities and attributes within the design.

____________________ not only helps you stay on track during the design process,it also enables you and your coworkers to pick up the design thread when the time comes to modify the design.

In the relationship "EMPLOYEE claims DEPENDENT" the DEPENDENT entity is ____________________ on the EMPLOYEE entity.

Instead of storing a person's age,it is better to store the date of birth and use the difference between that value and the system date as a(n)____________________ attribute.

A relationship is an association between ____.

The ERM forms the basis of a(n)___________________________________.

____________________ are characteristics of entities.

A ____ relationship exists when two entities are associated.

A(n)____________________ attribute is an attribute that must have a value.

The ____________________ refers to a specific table row as an entity instance.

Another word for existence-independent is ____.