Data Models into Database Designs 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 False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the parent entity is required and the parent has a surrogate key, update actions can be ignored. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n): composite key. primary key. foreign key. surrogate key. composite key. primary key. foreign key. surrogate key. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs 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. a surrogate key any alternate key a foreign key the primary key a surrogate key any alternate key a foreign key the primary key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs An intersection table is required to represent M:N relationships. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A foreign key is: used to define data types. All of these a column containing the primary key of another table. used to define null status. used to define data types. All of these a column containing the primary key of another table. used to define null status. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS