Exam 4: Entity Relationship (ER)Modeling

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.

In the ERD,cardinality is indicated using the ____ notation.

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

A ____ attribute can have only one value.

You should always load data from the 1 side of a 1:M relationship.

Instead of storing a person's age,it is better to store the date of birth and use the difference between that value and the system date as 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.

____________________ attributes can be subdivided.

Explain the difference between simple and composite attributes.Provide at least one example of each.

A(n)____________________ attribute cannot be subdivided.

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

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

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

____________________ are underlined in an ER diagram.

Attributes may share a ____.

Some attributes are classified as ____.

A ____ relationship exists when two entities are associated.

A(n)____________________ is the attribute's set of possible values.

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

In the relationship "EMPLOYEE claims DEPENDENT" the DEPENDENT entity is ____________________ on the EMPLOYEE entity.