For every relationship, there are six possible referential integrity actions.
For every relationship, there are six possible referential integrity actions.
An intersection table is required to represent M:N relationships.
An intersection table is required to represent M:N relationships.
Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?
Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?
Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
A foreign key is used to implement relationships between tables.
A foreign key is used to implement relationships between tables.
Which is not true about surrogate keys?
Which is not true about surrogate keys?
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
The identifier of an entity will become the ________ of the new table.
The identifier of an entity will become the ________ of the new table.
Each entity is represented as a(n):
Each entity is represented as a(n):
When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
The DBMS allows surrogate keys to be changed.
The DBMS allows surrogate keys to be changed.
Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
For every relationship, how many possible sets of minimum cardinalities are there?
For every relationship, how many possible sets of minimum cardinalities are there?
In a 1:1 relationship, the foreign key is placed in:
In a 1:1 relationship, the foreign key is placed in:
Intersection tables are ID-dependent on both their parent tables.
Intersection tables are ID-dependent on both their parent tables.
All primary keys are required.
All primary keys are required.
The terms alternate key and candidate key mean the same thing.
The terms alternate key and candidate key mean the same thing.
(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.
When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.
Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
When the parent entity is required, a new child row can always be inserted.
When the parent entity is required, a new child row can always be inserted.
A primary key should be defined as:
A primary key should be defined as:
In 1:N relationships, which entity becomes the parent entity is arbitrary.
In 1:N relationships, which entity becomes the parent entity is arbitrary.
For every relationship, there are six possible sets of minimum cardinalities.
For every relationship, there are six possible sets of minimum cardinalities.
A foreign key is:
A foreign key is:
Surrogate keys have much meaning for users.
Surrogate keys have much meaning for users.
In a 1:N relationship, the foreign key is placed in:
In a 1:N relationship, the foreign key is placed in:
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
When the parent entity is required, a new parent row can always be inserted.
When the parent entity is required, a new parent row can always be inserted.
When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.
When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.
In a 1:1 relationship, the primary key placement is arbitrary.
In a 1:1 relationship, the primary key placement is arbitrary.
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Which of the following situation requires the use of ID-dependent entities?
Which of the following situation requires the use of ID-dependent entities?
When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
Which of the following columns is(are) are required in a table?
Which of the following columns is(are) are required in a table?
Which of the following column properties specifies whether or not cells in a column must contain a data value?
Which of the following column properties specifies whether or not cells in a column must contain a data value?
An ideal primary key is short, numeric and seldom changing.
An ideal primary key is short, numeric and seldom changing.
