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 31

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 B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

A) Connectivity
B) Relationship
C) Dependence
D) Cardinality

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

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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

When using the Crow's Foot notation, the associative entity is indicated by _____ relationship lines between the parents and the associative entity.

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

The entity relationship model uses the associative entity to represent a(n) _____ relationship between two or more entities.

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

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

The Crow's Foot notation depicts the strong relationship with a(n) _____ line between the entities.

A _____ relationship exists when three entities are associated.

Failure to understand the distinction between mandatory and optional _____ in relationships might yield designs in which awkward (and unnecessary) temporary rows (entity instances) must be created just to accommodate the creation of required entities.

A(n) _____ attribute need not be physically stored within the database.

Explain mandatory participation in an entity relationship.

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

In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n) _____ on the side of the optional entity.

A _____ attribute is one that cannot be subdivided.

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

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

To implement a small database, a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional.

If an entity can exist apart from all of its related entities, then it is existence-independent, and it is referred to as a(n) _____ entity.