A circle across the relationship line near an entity indicates ________.
a maximum cardinality of "zero"
a maximum cardinality of "one"
a minimum cardinality of "optional"
a minimum cardinality of "required"
A composite attribute is an attribute that ________.
Describes a characteristic of the relationship
Is Multivalued
Consists of a group of attributes
Is calculated at run-time
A for-use-by pattern must involve what kind of entity?
Weak entity with one identifying relationship
Strong entity
Supertype entity
Weak entity with two identifying relationships
A hash mark across the relationship line near an entity indicates ________.
A maximum cardinality of "zero"
A maximum cardinality of "one"
A minimum cardinality of "optional"
A minimum cardinality of "required"
A line-item pattern must involve what kind of entity?
A referential integrity constraint policy that insures that all rows containing a particular foreign key value in a table are eliminated from the table when the row containing the corresponding primary key value in a parent table is eliminated from the database is called ________.
Incremental updates
Incremental deletes
Cascading deletes
Cascading updates
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 ________.
A surrogate key should be considered when ________.
A relationship is N:M
A composite key is required
The key contains a lengthy text field
The key contains a number
An attribute that determines which subtype should be used is a(n) ________.
Supertype
Subtype
Identifier
Discriminator
An entity that holds specialized attributes that distinguish it from one or more other similar entities is a ________.
Parent
An entity whose existence depends on the presence of another entity but whose identifier does not include the identifier of the other entity is a(n) ________.
ID-dependent entity
Subtype entity
Weak entity
An entity whose identifier includes the identifier of another entity is a(n) ________.
Required Entity
Weak Entity
Optional Entity
Strong Entity
An identifier may be ________.
Optional
A relationship
Minimal
Composite
An occurrence of a particular entity is called an ________.
Entity relationship
Entity class
Entity attribute
Entity instance
Each attribute of an entity becomes a(n) ________ of a table.
Alternate key
Primary key
Column
Foreign Key
Entities of a given type are grouped into an ________.
In a minimum cardinality, minimums are generally stated as ________.
0 or 1
M or N
1 or N
One or many
In a relational database design, all relationships are expressed by ________.
Creating a supertype
Creating a subtype
Creating a primary key
Creating a foreign key
In relational database design, IDdependent entities are not used to ________.
handle associative relationships
represent relationships where the child identifier does not include the key of the parent
represent N:M relationships
handle archetype/instance relationships
Many-to-many relationships are represented by ________.
an intersection table which has M:N relationships with the two tables
two tables with a 1:N relationship
two tables with an M:N relationship
an intersection table which has 1:N relationships with the two tables
Many-to-many relationships are represented by ________.
Maximum cardinality refers to ________.
the most instances of one entity class that can be involved in a relationship instance with another entity class
whether or not an instance of one entity class is required to be related to an instance of another entity class
the minimum number of entity classes involved in a relationship
whether or not an entity is a weak entity
Minimum cardinality refers to ________.
the most instances of one entity class that can be involved in a relationship with one instance of another entity class
Recursive relationships can have all of the following maximum cardinalities except ________.
1:1
N:M
1:N
M:M
Supertype/subtype entities are said to have a(n) ________ relationship.
HAS-A
Redundant
IS-A
Recursive
The binary constraint must cover indicates that ________.
a table includes values that must occur in a ternary relationship
a binary relationship includes a set of value combinations that must all occur in a ternary relationship
a specific binary relationship must be included in a ternary relationship
a table includes values that must occur in a binary relationship
The binary constraint must not indicates that ________.
a table includes values that must not occur in a ternary relationship
a binary relationship includes value combinations that must not occur in a ternary relationship
a table includes values that must not occur in a binary relationship
a specific binary relationship must not be included in a ternary relationship
The characteristics of a thing are described by its ________.
Identifiers
Attributes
Objects
Entities
The first step in transforming an extended ER model into a relational database design is to ________.
create a table for each relationship
create a table for each entity
remove any recursive relationships
evaluate the entities against the normalization criteria
The identifier of the entity becomes the ________ of the corresponding table.
Primary Key
To represent a multivalued attribute in an E-R model, ________.
create a new IDdependent entity with a 1:1 relationship
create a new weak, but not IDdependent entity with a 1:N relationship
create a new IDdependent entity with a 1:N relationship
create a new strong entity with a 1:1 relationship
To represent a one-to-many relationship in a relational database design, ________.
an intersection table must be created
the key of the table on the "many" side is placed in the table on the "one" side
the key of the parent is placed as a foreign key into the child
the key of the child is placed as a foreign key into the parent
To represent an archetype/instance pattern in an ER model, ________.
create a new ID-dependent entity with a 1:1 relationship
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
To represent an association pattern in an E-R model, ________.
create a new ID-dependent entity with a N:1 relationships to two parent entities
create a new weak, but not ID-dependent entity with a 1:1 relationship to one other entity
create a new strong entity with a 1:1 relationship to one other entity
create a new ID-dependent entity with a 1:1 relationship to one other entity
When an entity has a relationship to itself, we have a(n) ________.
supertype/subtype relationship
archetype/instance relationship
recursive relationship
Both supertype/subtype relationship and recursive relationship are correct
When representing a 1:1 relationship in a relational database design, ________.
the intersection table gets the key from both relations
the key of each table must be placed as foreign keys into the other
the key of either table may be placed as a foreign key into the other
the key of both tables must be the same
When representing a onetomany relationship in a relational database design, ________.
the parent is always on the one side of the "one-to-many" relationship
either parent or child can be on the one side of the "one-to-many" relationship, and the choice is arbitrary
either parent or child can be on the one side of the "one-to-many" relationship, and special criteria indicate which table should be on the one side
the child is always on the one side of the "one-to-many" relationship
