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 21

True/False

Review LaterAdd Note

Review Later

A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.

A) True
B) False

Correct Answer

verified

Show Answer

Question 22

Multiple Choice

Review LaterAdd Note

Review Later

A _____ relationship exists when an association is maintained within a single entity.

A) unary
B) ternary
C) strong
D) weak

E) A) and B)
F) B) and D)

Correct Answer

verified

Show Answer

Question 23

Short Answer

Review LaterAdd Note

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.

The decision to store _____ attributes in database tables depends on the processing requirements and the constraints placed on a particular application.

_____ are underlined in an ER diagram.

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

Complex _____ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design.

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

Database design is a(n) _____ process based on repetition.

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

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

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

If Tiny College has some departments that are classified as "research only" and do not offer courses, the COURSE entity of the college database would be _____ the DEPARTMENT entity.

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

Ideally, an entity identifier is composed of _____ attribute(s) .

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

A weak entity must be _____-dependent.

In the Chen and Crow's Foot notations, an entity is represented with a rectangle containing the entity's name.

The entity relationship diagram (ERD) represents the _____ database as viewed by the end user.