Exam 4: Entity Relationship Er Modeling

When using the Crow's Foot notation, the associative entity is indicated by _____ relationship lines between the parents and the associative entity.

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.

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a _____ relationship.

A _____ relationship exists when three entities are associated.

_____ expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.

In Chen notation, there is no way to represent cardinality.

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

In the entity relationship diagram (ERD), cardinality is indicated using the _____ notation, where max is the maximum number of associated entities and min represents the minimum number of associated entities.

A(n) _____ is the set of possible values for a given attribute.

If an entity can exist apart from all of its related entities, then it is existence-independent, and it is referred to as a(n) _____ entity.

Knowing the minimum and maximum number of _____ occurrences is very helpful at the application software level.

A(n) _____ attribute need not be physically stored within the database.

The entity relationship model uses the associative entity to represent a(n) _____ relationship between two or more entities.

Explain mandatory participation in an entity relationship.

In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n) _____ on the side of the optional entity.

To implement a small database, a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional.

A _____ attribute is one that cannot be subdivided.

Connectivities and cardinalities are established by concise statements known as business rules.

The Chen notation identifies a weak entity by using a double-walled entity _____.

The Crow's Foot notation depicts the strong relationship with a(n) _____ line between the entities.