Question 1 (2 points)
Minimum cardinality refers to ________.
Question 1 options:
the most instances of one entity class that can be involved in a relationship with one instance of another entity class |
the minimum number of entity classes involved in a relationship |
whether or not an instance of one entity class is required to be related to an instance of another entity class |
whether or not an entity is a weak entity |
None of these. |
Save
Question 2 (2 points)
Relationships are classified by their cardinality.
Question 2 options:
Save
Question 3 (2 points)
Attributes may be ________.
Question 3 options:
composite |
element |
multivalued |
composite and multivalued |
element and multivalued |
Save
Question 4 (2 points)
A relationship's maximum cardinality indicates the maximum number of entities that can participate in the relationship.
Question 4 options:
Save
Question 5 (2 points)
A circle across the relationship line near an entity indicates ________.
Question 5 options:
a maximum cardinality of "zero" |
a maximum cardinality of "one" |
a minimum cardinality of "optional" |
a minimum cardinality of "required" |
None of these. |
Save
Question 6 (2 points)
The characteristics of a thing are described by its ________.
Question 6 options:
identifiers |
entities |
objects |
attributes |
relationships |
Save
Question 7 (2 points)
To represent a multivalued attribute in an E-R model, ________.
Question 7 options:
create a new ID-dependent entity with a 1:N relationship |
create a new weak, but not ID-dependent entity with a 1:N relationship |
create a new strong entity with a 1:1 relationship |
create a new ID-dependent entity with a 1:1 relationship |
create a new weak, but not ID-dependent entity with a 1:1 relationship |
Save
Question 8 (2 points)
In a 1:N relationship, the term parent refers to the N side of the relationship.
Question 8 options:
Save
Question 9 (2 points)
A hash mark across the relationship line near an entity indicates ________.
Question 9 options:
a maximum cardinality of "zero" |
a maximum cardinality of "one" |
a minimum cardinality of "optional" |
a minimum cardinality of "required" |
None of these. |
Save
Question 10 (2 points)
For a relationship to be considered a binary relationship it must satisfy which of the following conditions?
Question 10 options:
It must involve exactly two entity classes. |
It must have a maximum cardinality of 1:1. |
It must have a maximum cardinality of 1:N. |
It must involve exactly two entity classes. and It must have a maximum cardinality of 1:1 |
It must involve exactly two entity classes. and It must have a maximum cardinality of 1:N |
Save
Question 11 (2 points)
In relational database design, ID-dependent entities are used to ________.
Question 11 options:
represent N:M relationships |
handle associative relationships |
handle multivalued attributes |
handle archetype/instance relationships |
All of these. |
Save
Question 12 (2 points)
A foreign key is a key that does not belong in any table.
Question 12 options:
Save
Question 13 (2 points)
When transforming an ID-dependent E-R data model relationship into a relational database design and the child entity is designed to use a surrogate key, then ________.
Question 13 options:
the parent entity must also use a surrogate key |
the relationship remains an ID-dependent relationship |
the relationship changes to a non-ID-dependent relationship |
the parent entity must also use a surrogate key and the relationship remains an ID-dependent relationship |
the parent entity must also use a surrogate key and the relationship changes to a non-ID-dependent relationship |
Save
Question 14 (2 points)
A referential integrity constraint policy that insures that foreign key values in a table are correctly maintained when there is a change to the primary key value in the parent table is called ________.
Question 14 options:
incremental updates |
incremental deletes |
controlled key adjustments |
cascading updates |
cascading deletes |
Save
Question 15 (2 points)
In a relational database design, all relationships are expressed by creating a foreign key.
Question 15 options:
Save
Question 16 (2 points)
An intersection table can have additional attributes besides the keys of its parent tables.
Question 16 options:
Save
Question 17 (2 points)
An ID-dependent table can be used to represent multivalued attributes.
Question 17 options:
Save
Question 18 (2 points)
Like all ID-dependent relationships, the parents of an association table are required.
Question 18 options:
Save
Question 19 (2 points)
An intersection table is always ID-dependent on both of its parent tables.
Question 19 options:
Save
Question 20 (2 points)
By default, the identifier of the entity becomes the foreign key of the corresponding table.
Question 20 options:
Save
Question 21 (2 points)
One of the important properties of an attribute is whether or not it is ________.
Question 21 options:
found in more than one entity |
required |
character or numeric |
subject to normalization |
subject to denormalization |
Save
Question 22 (2 points)
The first step in the database design process is to create tables and columns from entities and attributes.
Question 22 options:
Save
Question 23 (2 points)
When creating a relational database design from E-R diagrams, first create a relation for each relationship.
Question 23 options:
Save
Question 24 (2 points)
A surrogate key should be considered when ________.
Question 24 options:
a relationship is M:N |
a composite key is required |
the key contains a lengthy text field |
the key contains a number |
an index needs to be created |
Save
Question 25 (2 points)
In a relational database design, all relationships are expressed by ________.
Question 25 options:
creating a primary key |
creating a foreign key |
creating a supertype |
creating a subtype |
creating a line between entities |
Save
Question 26 (5 points)
What are the guidelines for transforming a single entity into a table?
Question 26 options:
Save
Question 27 (5 points)
In detail, describe the relationship between CUSTOMER and ORDER.
Question 27 options:
Save
Question 28 (5 points)
Explain the following true statement: Databases do not model the real world.
Question 28 options:
Save
Question 29 (5 points)
What are the guidelines for handling multivalued attributes when transforming an entity into a table?
Question 29 options:
Save
Question 30 (5 points)
Describe in detail the relationship between ORDER and PRODUCT.
Question 30 options:
Save
Question 31 (5 points)
What is an entity?
Question 31 options:
Save
Question 32 (5 points)
What is the 1:N Transformation Rule?
Question 32 options:
Save
Question 33 (5 points)
What is the N:M Transformation Rule?
Question 33 options:
Save
Question 34 (5 points)
Degree is the number of entities that participate in a relationship. A relationship of degree 2 is a binary relationship. What are the three types of binary relationships?
Question 34 options:
Save
Question 35 (5 points)
What is the 1:1 Transformation Rule?
Question 35 options: