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

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

The process of database design is a sequential process.

A) True
B) False

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

are characteristics of entities.

Explain mandatory participation in an entity relationship.

A relationship exists when three entities are associated.

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

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

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

What is a weak relationship? Provide an example.

Relationships between entities always operate in one direction.

When the specific cardinalities are not included on the diagram in Crow's Foot notation, cardinality is implied by the use of _____.

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

Explain recursive relationships with the help of an example.

A person's Social Security number would be an example of a(n) attribute.

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.

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

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

Unary relationships are common in manufacturing industries.

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

In implementation terms, an entity is existence-dependent if it has a mandatory primary key.