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 41

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

Referential integrity and participation are both bidirectional, meaning that they must be addressed in both directions along a relationship.

A) True
B) False

Correct Answer

verified

Show Answer

Question 43

Short Answer

Review LaterAdd Note

not only helps database designers to stay on track during the design process, it also enables them to pick up the design thread when the time comes to modify the design.

In the original Chen notation, each attribute is represented by an oval with the attribute name connected to an entity rectangle with a line.

A(n) is the set of possible values for a given attribute.

To simplify the conceptual design, most higher-order relationships are decomposed into appropriate equivalent? relationships whenever possible.

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

The Crow's Foot notation is less implementation-oriented than the Chen notation.

Knowing the minimum and maximum number of occurrences is very helpful at the application software level.

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

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

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

The conceptual model can handle relationships and multivalued attributes.

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

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