Topic 4 Flashcards
The entity relationship diagram (ERD) represents the _____ database as viewed by the end user
a. condensed
b. physical
c. logical
d. conceptual
conceptual
The _____ notation of entity-relationship modelling can be used for both conceptual and implementation modelling
a. Bachman
b. UML
c. Chen
d. Crow’s Foot
UML
A (n) _____ is the set of possible values for a given attribute
a. domain
b. range
c. identifier
d. key
domain
Ideally, an entity identifier is composed of _____ attribute(s)
a. one
b. two
c. three
d. six
one
A _____ attribute can be further subdivided to yield additional attributes
a. composite
b. simple
c. single-valued
d. multivalued
composite
A _____ attribute is one that cannot be subdivided
a. composite
b. simple
c. single-valued
d. multivalued
simple
The conceptual model can handle _____ relationships and multivalued attributes
a. 1:1
b. M:N
c. 1:M
d. 1:N
M:N
A derived attribute is indicated in the Chen notation by a _____ that connects the attribute and an entity
a. single line
b. dashed line
c. double dashed line
d. double line
dashed line
The decision to store _____ attributes in database tables depends on the processing requirements and the constraints placed on a particular application
a. multivalued
b. derived
c. single-valued
d. Composite
derived
A relationship is an association between _____
a. objects
b. entities
c. databases
d. fields
entities
_____ expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity
a. Connectivity
b. Relationship
c. Dependence
d. Cardinality
Cardinality
In the entity relationship diagram (ERD), cardinality is indicated using the _____ notation, where max is the maximum number of associated entities and min represents the minimum number of associated entities
a. (max, min)
b. (min, max)
c. [min … max]
d. {min|max}
(min, max)
When the specific cardinalities are not included on the diagram in Crow’s Foot notation, cardinality is implied by the use of _____
a. symbols
b. attributes
c. images
d. tables
symbols
Knowing the minimum and maximum number of _____ occurrences is very helpful at the application software level
a. object
b. attribute
c. data
d. entity
entity
An entity is said to be _____-dependent if it can exist in the database only when it is associated with another related entity occurrence
a. existence
b. relationship
c. business
d. data
existence
If an entity can exist apart from all of its related entities, then it is existence-independent, and it is referred to as a (n) _____ entity
a. weak
b. alone
c. unary
d. strong
strong
A _____ entity has a primary key that is partially or totally derived from the parent entity in the relationship
a. strong
b. weak
c. business
d. child
weak
The existence of a (n) _____ entity indicates that its minimum cardinality is zero
a. ternary
b. optional
c. strong
d. weak
optional
A _____ relationship exists when an association is maintained within a single entity
a. unary
b. ternary
c. strong
d. weak
unary
A _____ relationship exists when three entities are associated
a. unary
b. strong
c. ternary
d. weak
ternary
If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a _____ relationship
a. self
b. self-referring
c. looping
d. recursive
recursive
To simplify the conceptual design, most higher-order relationships are decomposed into appropriate equivalent _____ relationships whenever possible
a. unary
b. binary
c. strong
d. weak
binary
The entity relationship model uses the associative entity to represent a (n) _____ relationship between two or more entities
a. M:N
b. 1:M
c. N:1
d. M:1
M:N
When using the Crow’s Foot notation, the associative entity is indicated by _____ relationship lines between the parents and the associative entity
a. dotted
b. double
c. triple
d. solid
solid
