Remember that the nature of the relationship is often determined by the ____, who must use professional judgment to determine which relationship type and strength best suit the database transaction, efficiency, and information requirements.
RDBMS
ERD
end-user
database designer
The entity relationship diagram is used to graphically represent the ____ database model.
condensed
physical
logical
conceptual
When loading data into two entities with a 1:* relationship, how should the data be loaded?
the 1 side must be loaded first
the * side must be loaded first
if the relationship is strong the 1 side must be loaded first, if the relationship is weak, the * side must be loaded first
the order is irrelevant
The preferred way to represent multivalued attributes in a DBMS is to create a new entity composed of the original multivalued attribute's components in a(n) ____ relationship with the original entity.
*:*
1:1
1:*
weak
If no ____ symbol is depicted with an entity, the entity exists in a mandatory relationship with the related entity.
optionality
cardinality
directional
strength
A ____ relationship exists when an association is maintained within a single entity.
unary
ternary
binary
weak
Knowing the ____ number of entity occurrences is very helpful at the application software level.
maximum
minimum
exact
maximum and minimum
In an ERD, the focus is on the ____ and the relationships between them.
attributes
entities
keys
indexes
A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.
strong
weak
business
relationship
Suppose that Tiny University offers several courses; each course has several classes. It is possible for the department to create the entity COURSE first and then create the CLASS entity after making the teaching assignments. In this case, what cardinality will appear for CLASS in the ERD?
(0,1)
(1,1)
(0,*)
(1,*)
Which attribute(s) make up the primary key in the table definition CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)?
CRS_CODE
CLASS_SECTION
CRS_CODE and CLASS_SECTION
there is no primary key
The set of possible values for an attribute is a ____.
domain
range
set
key
Which of the following might be represented with a multivalued attribute?
person's name
class location
bank account balance
book title
When the PK of one entity does not contain a PK component of a related entity, the relationship is ____.
missing
weak
strong
neutral
A ____ relationship is one in which a relationship can exist between occurrences of the same entity set.
recursive
dependent
strong
weak
Which of the following might be represented with a single-valued attribute?
person's phone number
car's color
employee's educational background
computer's processor speed
A derived attribute ____.
must be stored physically within the database
need not be physically stored within the database
has many values
must be based on the value of three or more attributes
_____________ refers to the number of instances of one entity that are associated with one instance of a related entity.
the degree
identifiers
multiplicity
participation
What is meant by the multiplicity 1..* ?
A minimum of zero and a maximum of many instances of this class are associated with an instance of the other related class (indicates an optional class).
A minimum of one and a maximum of one instance of this class are associated with an instance of the other related class (indicates a mandatory class).
minimum of zero and a maximum of one instance of this class are associated with an instance of the other related class (indicates an optional class).
A minimum of one and a maximum of many instances of this class are associated with an instance of the other related class (indicates a mandatory class).