Exam 4: Entity Relationship (ER)Modeling

Derived attributes are stored in a special database table.

Attributes have a domain that specifies the data type of the attribute.

All attributes are either simple or composite.

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

If an entity can exist apart from one or more related entities,it is said to be ____-independent.

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

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

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

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

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

In an ER diagram,primary keys are usually bolded.

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

A ____ should be a derived attribute.

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

Relationships operate only in one direction.

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

____ relationships are most common.

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

The ER diagram represents the conceptual database as viewed by the end user.

The existence of a(n)____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity.