In crows foot style e-r diagrams, a circle across the relationship line near an entity indicates:

Card Range To Study

through

In crows foot style e-r diagrams, a circle across the relationship line near an entity indicates:

In crows foot style e-r diagrams, a circle across the relationship line near an entity indicates:

In crows foot style e-r diagrams, a circle across the relationship line near an entity indicates:

Use LEFT and RIGHT arrow keys to navigate between flashcards;

Use UP and DOWN arrow keys to flip the card;

H to show hint;

A reads text to speech;

  • Share
  • Print
  • Export
  • Clone

20 Cards in this Set

  • Front
  • Back

Subtype entities may be either exclusive or inclusive.

True

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

True

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?

1:N

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?

1:N

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

True

A dashed line between entities indicates:

a nonidentifying relationship.

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

a maximum cardinality of many.

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

False

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

degree

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

True

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

False

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

False

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

True

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

True

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

True

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

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

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

Use cases

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:

a supertype / subtype relationship

An ID-dependent entity is:

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

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

minimum cardinality.

When an entity class has a relationship with itself it is called a?

It is possible for an entity to have a relationship with itself; for example, an entity Staff could have a relationship with itself, as one member of staff could supervise other staff. This is known as a recursive or involute relationship, and would be represented in an entity-relationship diagram as shown below.

Which of the following is the term for the number of entities involved in a relationship?

Cardinality: The number of times an entity of an entity set participates in a relationship set is known as cardinality.

What indicates whether or not an instance of one entity must participate in a relationship with another entity?

An entity's minimum cardinality in a relationship indicates the number of entity instances that must participate in the relationship. An entity's minimum cardinality in a relationship indicates whether or not an entity must participate in the relationship.

What is a representation of the content relationships and constraints of the data needed to support the system requirements?

The representation of the content, relationships, and constraints of the data needed to support the system requirements is the: data model.