Which of the following situation requires the use of ID-dependent entities?
The identifier of an entity will become the ________ of the new table.
A foreign key is:
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 cells in a column must be one of a specific set of possible values?
The DBMS allows surrogate keys to be changed.
(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
When the parent entity is required, a new child row can always be inserted.
A foreign key is used to implement relationships between tables.
Which of the following columns is(are) are required in a table?
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
In a 1:N relationship, the foreign key is placed in:
Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
When the parent entity is required, a new parent row can always be inserted.
All primary keys are required.
The terms alternate key and candidate key mean the same thing.
In 1:N relationships, which entity becomes the parent entity is arbitrary.
In a 1:1 relationship, the foreign key is placed in:
Please disable the adBlock and continue. Thank you.