Exam 4: Entity Relationship Er Modeling

The entity relationship diagram (ERD) represents the _____ database as viewed by the end user.

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

A _____ relationship exists when an association is maintained within a single entity.

Participation is _____ if one entity occurrence does not require a corresponding entity occurrence in a particular relationship.

Database design is a(n) _____ process based on repetition.

What is a ternary relationship? Provide some business rules examples that specify the need for a ternary or higher-order relationship.

When the specific cardinalities are not included on the diagram in Crow's Foot notation, cardinality is implied by the use of _____.

If Tiny College has some departments that are classified as "research only" and do not offer courses, the COURSE entity of the college database would be _____ the DEPARTMENT entity.

A(n) _____ process is based on repetition of processes and procedures.

_____ are underlined in an ER diagram.

In organizations that generate large number of transactions, _____ are often a top priority in database design.

A person's Social Security number would be an example of a(n) _____ attribute.

A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.

In the Chen and Crow's Foot notations, an entity is represented with a rectangle containing the entity's name.

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

In implementation terms, an entity is existence-dependent if it has a mandatory primary key.

An entity in the entity relationship model corresponds to a table in the relational environment.

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

A weak entity must be _____-dependent.

The decision to store _____ attributes in database tables depends on the processing requirements and the constraints placed on a particular application.