Exam 7: Data Modeling With Entity Relationship Diagrams

All simple attributes are also single-valued.

Connectivities and cardinalities are established by business rules.

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

A ____ attribute can be further subdivided to yield additional attributes.

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

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

Relationship strength depends on how the primary key of the related entity is formulated, while the relationship ____________________ depends on how the business rule is written.

A relationship ____________________ indicates the number of entities or participants associated with a relationship.

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

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

An ERM is dependent on the database type.

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

Ideally, an entity identifier is composed of ____ attribute(s).

In an ER diagram, primary keys are indicated by ____.

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

Attributes may share a ____.

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

A(n) ____________________ relationship is also known as an identifying relationship.

The relationship ____________________ is difficult to establish if you know only one side of the relationship.

Attributes cannot share a domain.