Exam 5: Data Modeling With the Entity-Relationship Model

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

Which of the following is not a good reason for designing a data model?

(Multiple Choice)
4.9/5
(30)

Which of the following is not true about subtype entities?

(Multiple Choice)
4.8/5
(32)

An identifier serves the same role for a table that a key does for an entity.

(True/False)
4.7/5
(34)

A composite attribute is an attribute that ________.

(Multiple Choice)
4.9/5
(39)

The degree of a relationship is expressed as the relationship's maximum cardinality.

(True/False)
4.8/5
(45)

An identifier of an entity instance must consist of one and only one attribute.

(True/False)
4.9/5
(30)

A single relationship class involves only one entity class.

(True/False)
4.9/5
(42)

A relationship's maximum cardinality indicates the maximum number of entities that can participate in the relationship.

(True/False)
4.7/5
(30)

E-R models use an identifying relationship to connect entities that are ID-dependent.

(True/False)
4.8/5
(34)

An entity instance is an occurrence of a particular entity.

(True/False)
4.8/5
(36)

When designing a database,first identify the entities,then determine the attributes,and finally create the relationships.

(True/False)
4.8/5
(37)

A binary relationship is a relationship based on numerical entity instance identifiers.

(True/False)
4.9/5
(34)

In E-R modeling,entities within an entity class may have different attributes.

(True/False)
4.9/5
(33)

Distinguish between entity identifiers and keys.

(Essay)
4.8/5
(31)

In a minimum cardinality,minimums are generally stated as ________.

(Multiple Choice)
4.7/5
(40)

For a relationship to be considered a binary relationship it must satisfy which of the following conditions?

(Multiple Choice)
4.7/5
(28)

Relationships between supertypes and subtypes are called IS-A relationships.

(True/False)
4.7/5
(39)

An entity that represents something that can exist on its own is called a strong entity.

(True/False)
4.9/5
(21)

The principal difference between an entity and a table is that you can express a relationship between entities without using foreign keys.

(True/False)
4.8/5
(25)

Entities containing multivalued attributes are often represented using subtypes.

(True/False)
4.9/5
(30)
Showing 61 - 80 of 104
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)