Exam 4: Entity Relationship (ER)Modeling

Identifying the attributes of the entities helps you better understand the ____________________ among entities.

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

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

The Crow's Foot model is more ____________________-oriented than the Chen model.

A ____ attribute is one that cannot be subdivided.

Connectivities and cardinalities are established by business rules.

In the Chen model,a multivalued attribute is connected to the owning entity with a double line.

All attributes are either simple or composite.

A(n)____ might be represented with a single-valued attribute.

A ____ relationship exists when three entities are associated.

Failure to understand the distinction between mandatory and optional ____________________ in relationships might yield designs in which awkward (and unnecessary)temporary rows (entity instances)must be created just to accommodate the creation of required entities.

Derived attributes are stored in a special database table.

An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.

The set of possible values for an attribute is a ____.

A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

A relationship is identified by a name that describes the relationship.

The step,____,occurs first in the process of building an ERD.

What is a weak relationship? Provide an example.

Another word for existence-independent is ____.

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