Data Models into Database Designs In a 1:1 relationship, the primary key placement is arbitrary. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs An intersection table is required to represent M:N relationships. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following columns is(are) are required in a table? A foreign key An alternate key A primary key A surrogate key A foreign key An alternate key A primary key A 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. the primary key any alternate key a surrogate key a foreign key the primary key any alternate key a surrogate key a foreign key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The identifier of an entity will become the ________ of the new table. foreign key identity key primary key main attribute foreign key identity key primary key main attribute ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited. True False True False ANSWER DOWNLOAD EXAMIANS APP