Question 1

The relationship ____________________ is difficult to establish if you know only one side of the relationship.

Accepted Answer

The answer of The relationship ____________________ is difficult to establish...

Question 2

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

Accepted Answer

The answer of A(n) ____________________ relationship is also known as...

Question 3

____________________ not only helps you stay on track during the design process, it also enables you and your coworkers to pick up the design thread when the time comes to modify the design.

Accepted Answer

The answer of ____________________ not only helps you stay on...

Question 4

Relationship strength depends on how the primary key of the related entity is formulated, while the relationship ____________________ depends on how the business rule is written.

Accepted Answer

The answer of Relationship strength depends on how the primary...

Question 5

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.

Accepted Answer

The answer of Failure to understand the distinction between mandatory...

Question 6

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

Accepted Answer

The answer of When indicating cardinality, the first value represents...

Question 7

What is a ternary relationship? Provide some example business rules that specify the need for a ternary or higher-order relationship.

Accepted Answer

The answer of What is a ternary relationship? Provide some...

Question 8

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

Accepted Answer

The answer of The Crow's Foot notation depicts the strong...

Question 9

Explain single-valued attributes and provide an example. Is an attribute that is single-valued always simple? Why or why not? Use an example to illustrate your point.

Accepted Answer

The answer of Explain single-valued attributes and provide an example....

Question 10

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

Accepted Answer

The answer of A relationship ____________________ indicates the number of...

Question 11

Participation is ____________________ if one entity occurrence does not require a corresponding entity occurrence in a particular relationship.

Accepted Answer

The answer of Participation is ____________________ if one entity occurrence...

Question 12

What is a weak relationship? Provide an example.

Accepted Answer

The answer of What is a weak relationship? Provide an...

Question 13

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

Accepted Answer

The answer of The Chen notation identifies the weak entity...

Question 14

Identifying the attributes of the entities helps you better understand the ____________________ among entities.

Accepted Answer

The answer of Identifying the attributes of the entities helps...

Question 15

Explain multivalued attributes, and provide an example. How are multivalued attributes indicated in the Chen model? How are they indicated in the Crow's Foot model?

Accepted Answer

The answer of Explain multivalued attributes, and provide an example....

Question 16

A(n) ____________________ process is based on repetition of processes and procedures.

Accepted Answer

The answer of A(n) ____________________ process is based on repetition...

Question 17

Explain the difference between simple and composite attributes. Provide at least one example of each.

Accepted Answer

The answer of Explain the difference between simple and composite...

Question 18

A weak entity must be ____________________-dependent.

Accepted Answer

The answer of A weak entity must be ____________________-dependent....

Question 19

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

Accepted Answer

The answer of In Crow's Foot notation, an optional relationship...

Question 20

In the relationship "EMPLOYEE claims DEPENDENT" the DEPENDENT entity is ____________________ on the EMPLOYEE entity.

Accepted Answer

The answer of In the relationship "EMPLOYEE claims DEPENDENT" the...

Quiz 7: Data Modeling With Entity Relationship Diagrams