Isds 402 Ch 4

Front 1

Subtype entities may be either exclusive or inclusive.

Back 1

True

Front 2

The E-R Model assumes that all instances of a given entity class have the same
attributes.

Back 2

True

Front 3

If one instance of ENTITY B must be related to one and only one instance of ENTITY
A, and one instance of ENTITY A may be related to many instances of ENTITY B,
which of the following should be written in the relationship symbol of the figure below?

Back 3

1:N

Front 4

If one instance of ENTITY B must be related to one and only one instance of ENTITY
A, and one instance of ENTITY A may be related to many instances of ENTITY B,
which of the following should be written in the relationship symbol of the figure below?

Back 4

1:N

Front 5

In crow's foot E-R notation, a circle indicates a minimum cardinality of zero.

Back 5

True

Front 6

A dashed line between entities indicates:

Back 6

a nonidentifying relationship.

Front 7

In crow's foot style E-R diagrams, a crow's foot mark on the relationship line near an
entity indicates:

Back 7

a maximum cardinality of many.

Front 8

Maximum cardinality indicates whether or not an instance of one entity class must be
related to at least one instance of another entity class.

Back 8

False

Front 9

The number of entity classes involved in a relationship is known as the relationship's:

Back 9

degree

Front 10

During the design phase of developing a database system, the users are asked about the
need for changes to existing forms and reports.

Back 10

True

Front 11

The PRODUCT entity instance is the collection of all PRODUCT entity classes.

Back 11

False

Front 12

The number of entity classes involved in a relationship is the cardinality of the
relationship.

Back 12

False

Front 13

It is possible for an entity to have a relationship to itself.

Back 13

True

Front 14

During the design phase of developing a database system, the data model is
transformed into a database design.

Back 14

True

Front 15

Use cases can be used to validate the data model, design, and implementation.

Back 15

True

Front 16

Given only the excerpt of an E-R model shown in the figure below, which of the following is known to be true?

Back 16

A single instance of ENTITY B may be related to many
instances of ENTITY A.

Front 17

Which of the following is not a basic element of the E-R Model?

Back 17

Use cases

Front 18

In crow's foot style E-R diagrams, a single entity together with a related set of entities
that each contain specific sets of attributes related to the single entity represent:

Back 18

a supertype / subtype relationship

Front 19

An ID-dependent entity is:

Back 19

Both a special type of weak entity and an entity in which the
identifier of the entity includes the identifier of another entity

Front 20

Whether or not an instance of one entity class must participate in a relationship with
another entity class is indicated by the:

Back 20

minimum cardinality.