FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Entity Relationship Ermodeling

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Short Answer

Review LaterAdd Note

Review Later

are underlined in an ER diagram.

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

In the entity relationship diagram (ERD) ,cardinality is indicated using the notation,where max is the maximum number of associated entities and min represents the minimum number of associated entities.

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

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

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

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

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

Composite attributes make it easier to facilitate detailed queries.

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

A relationship is an association between .

Connectivities and cardinalities are established by concise statements known as business rules.

An entity in the entity relationship model corresponds to a table in the relational environment.

expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.

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

In organizations that generate large number of transactions,are often a top priority in database design.

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

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

A attribute is one that cannot be subdivided.