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

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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

A) unary
B) binary
C) strong
D) weak

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

A derived attribute is indicated in the Chen notation by a _____ that connects the attribute and an entity.

The existence of a(n) _____ entity indicates that its minimum cardinality is zero.

Explain multivalued attributes with the help of examples. How are multivalued attributes indicated in the Chen Entity Relationship model?

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

The Crow's foot symbol with two vertical parallel lines indicates _____ cardinality.

In a 1:M relationship, to avoid the possibility of referential integrity errors, the data of the "1" side must be loaded first.

Composite attributes make it easier to facilitate detailed queries.

In organizations that generate large numbers of transactions, _____ processing speeds are often a top priority in database design, whichresult inminimal access time. ​

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

The concept of relationship strength is based on how the _____ of a related entity is defined.

Identifying the attributes of entities helps in the better understanding of _____ among entities.

The entity relationship model (ERM) is dependent on the database type.

What is a weak relationship? Provide an example.