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 primary key should be defined as:
A primary key should be defined as:
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):
Which of the following columns is(are) are required in a table?
Which of the following columns is(are) are required in a table?
In a 1:1 relationship, the foreign key is placed in:
In a 1:1 relationship, the foreign key is placed in:
Which of the following situation requires the use of ID-dependent entities?
Which of the following situation requires the use of ID-dependent entities?
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 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?
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 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 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?
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?
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?
Each entity is represented as a(n):
Each entity is represented as a(n):
The identifier of an entity will become the ________ of the new table.
The identifier of an entity will become the ________ of the new table.
A foreign key is:
A foreign key is:
In a 1:N relationship, the foreign key is placed in:
In a 1:N relationship, the foreign key is placed in:
Which is not true about surrogate keys?
Which is not true about surrogate keys?
