FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Entity Relationship (ER)Modeling

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

Multiple Choice

Review LaterAdd Note

Review Later

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

A) (max,min)
B) (min,max)
C) [min ...max]
D) {min|max}

E) A) and B)
F) None of the above

Correct Answer

verified

Show Answer

Question 22

Short Answer

Review LaterAdd Note

Review Later

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.

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

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.

____________________ are underlined in an ER diagram.

A(n)____________________ attribute cannot be subdivided.

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

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

____________________ attributes can be subdivided.

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

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

A ____ relationship exists when two entities are associated.

A ____ attribute can have only one value.

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

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

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

Some attributes are classified as ____.

Attributes may share a ____.

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

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

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