Exam 5: Data Modeling With the Entity-Relationship Model

arrow

5,052 students have unlocked this exam

  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

A relationship's minimum cardinality indicates the number of entity instances that must participate in the relationship.

(True/False)
4.9/5
(37)

A hash mark across the relationship line near an entity indicates ________.

(Multiple Choice)
4.8/5
(39)

There are three types of recursive relationships: 1:1,1:N and N:M.

(True/False)
4.8/5
(44)

Entities with an IS-A relationship should have the same identifier.

(True/False)
4.8/5
(42)

  -You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above,and are asked to draw the relationship between them.If a given customer can place only one order and a given order can be placed by at most one customer,which of the following should be indicated in the relationship symbol between the two entities? -You are given an E-R diagram with two entities,ORDER and CUSTOMER,as shown above,and are asked to draw the relationship between them.If a given customer can place only one order and a given order can be placed by at most one customer,which of the following should be indicated in the relationship symbol between the two entities?

(Multiple Choice)
4.9/5
(40)

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

(Multiple Choice)
4.7/5
(40)

An attribute that determines which subtype is appropriate is called a discriminator.

(True/False)
4.9/5
(35)

Entities containing optional sets of attributes are often represented using subtypes.

(True/False)
4.8/5
(31)

How is maximum cardinality expressed in IE Crow's Foot E-R diagrams?

(Essay)
4.9/5
(36)

All weak entities must have a minimum cardinality of 1 on the entity on which it depends.

(True/False)
4.9/5
(38)

A single relationship class involves only one entity class.

(True/False)
4.9/5
(31)

To represent an association pattern in an E-R model,________.

(Multiple Choice)
5.0/5
(39)

A weak entity is an entity that cannot exist in the database without (and is logically dependent upon)another type of entity also existing in the database.

(True/False)
5.0/5
(36)

The notation 1:N shows the relationship's maximum cardinality.

(True/False)
4.9/5
(37)

To represent a multivalued attribute in an E-R model,________.

(Multiple Choice)
4.9/5
(32)

The principle 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
(38)

One example of a database design using an ID-dependent relationship is the association pattern.

(True/False)
4.7/5
(44)

How is minimum cardinality expressed in IE Crow's Foot E-R diagrams?

(Essay)
4.9/5
(37)

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

(True/False)
4.9/5
(38)

One example of a database design using an ID-dependent relationship is the archetype/instance pattern.

(True/False)
4.9/5
(35)
Showing 21 - 40 of 100
close modal

Filters

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