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. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following columns is(are) are required in a table? A surrogate key A foreign key An alternate key A primary key TRUE ANSWER : ? YOUR ANSWER : ?
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities? Four Six Three Two TRUE ANSWER : ? YOUR ANSWER : ?
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n): surrogate key. foreign key. primary key. composite key. TRUE ANSWER : ? YOUR ANSWER : ?
When the parent entity is required and the parent has a surrogate key, update actions can be ignored. False True TRUE ANSWER : ? YOUR ANSWER : ?
In a 1:1 relationship, the primary key placement is arbitrary. False True TRUE ANSWER : ? YOUR ANSWER : ?
A foreign key is used to implement relationships between tables. False True TRUE ANSWER : ? YOUR ANSWER : ?
The identifier of an entity will become the ________ of the new table. primary key identity key foreign key main attribute TRUE ANSWER : ? YOUR ANSWER : ?