Exam 7: Data Modeling With Entity Relationship Diagrams

The ERD represents the ____ database as viewed by the end user.

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

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

Another word for existence-independent is ____.

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

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

In an ER diagram, primary keys are usually bolded.

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

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

A ____ identifier is composed of more than one attribute.

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

____________________ are characteristics of entities.

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

If Tiny College had some departments that were classified as "research only," they would not offer courses; therefore, the COURSE entity would be ____ to the DEPARTMENT entity.

The term "____" is used to label any condition in which one or more optional relationships exist.

A person's social security number would be an example of a(n) ____________________ attribute.

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

A composite identifier is a primary key composed of more than one attribute.

____________________ are underlined in an ER diagram.

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