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 51

Multiple Choice

Review LaterAdd Note

Review Later

In an ER diagram,primary keys are indicated by ____.

A) bolding
B) italics
C) underlining
D) a special font

E) None of the above
F) C) and D)

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

Knowing the ____ number of entity occurrences is very helpful at the application software level.

A) maximum
B) minimum
C) approximate
D) maximum and minimum

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

Correct Answer

verified

Show Answer

Question 53

Short Answer

Review LaterAdd Note

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

Attributes cannot share a domain.

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

In an ER diagram,primary keys are usually bolded.

The Crow's Foot model is less implementation-oriented than the Chen model.

____ attributes can have many values.

A(n)____________________ relationship exists when two entities are associated.

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

Connectivities and cardinalities are usually based on ____________________ rules.

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

In the original ERM described by Chen,relationships do not contain ____________________.

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

Some ____________________ database modeling concepts can be expressed only using the Chen notation.

The ERD represents the ____ database as viewed by the end user.

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

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

A derived attribute is indicated in the Chen model by a ____.

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