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 1

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 2

Multiple Choice

Review LaterAdd Note

Review Later

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

A) strong
B) weak
C) business
D) child

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

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

Software vendors have adopted the Chen representation because of its compact representation.

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

When indicating cardinality, the first value represents the _____ number of associated entities.

The conceptual model can handle _____ relationships and multivalued attributes.

The first step in building an entity-relationship diagram (ERD) is _____.

A relationship _____ is difficult to establish if only one side of the relationship is known.

Relationships between entities always operate in one direction.

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

A(n) _____ relationship is also known as an identifying relationship.

_____ are characteristics of entities.

Explain recursive relationships with the help of an example.

The _____ notation of entity-relationship modelling can be used for both conceptual and implementation modelling.

The Crow's Foot notation easily identifies multivalued attributes.

A relationship is an association between _____.

In the entity relationship model, a table row corresponds to an entity instance.

A(n) _____ attribute is an attribute that must have a value.

A _____ attribute can be further subdivided to yield additional attributes.

_____ 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.