test 1 review part 4 Flashcards
Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the:
A) degree.
B) recursive cardinality.
C) minimum cardinality.
D) maximum cardinality.
E) ordinality.
C) minimum cardinality.
A dashed line between entities indicates:
A) a unique identifier.
B) a minimum cardinality of zero.
C) a minimum cardinality of one.
D) an identifying relationship.
E) a nonidentifying relationship.
E) a nonidentifying relationship
Which of the following is not a basic element of the E-R Model?
A) Identifiers
B) Entities
C) Cardinalities
D) Use cases
E) Relationships
D) Use cases
In crow’s foot style E-R diagrams, a circle across the relationship line near an entity indicates:
A) a minimum cardinality of zero.
B) a minimum cardinality of one.
C) a maximum cardinality of one.
D) a maximum cardinality of many.
E) Both B and C
A) a minimum cardinality of zero.
An ID-dependent entity is:
A) a special type of weak entity.
B) an entity in which the identifier of the entity includes the identifier of another entity.
C) a strong entity.
D) an entity with a maximum cardinality of one.
E) Both A and B
E) Both A and B
Which of the following is not a stage in the development of a database system?
A) Requirements analysis
B) Validation
C) Component design
D) Implementation
E) All of the above are stages in the development of a database system.
B) Validation
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) a strong entity relationship.
B) an ID-dependent weak entity relationship.
C) a non-ID-dependent weak entity relationship.
D) a supertype / subtype relationship.
E) a recursive entity relationship.
D) a supertype / subtype relationship.
