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 foreign key any alternate key the primary key a surrogate key a foreign key any alternate key the primary key a surrogate key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship? MUST COVER MUST NOT Both of the above None of these MUST COVER MUST NOT Both of the above None of these ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following column properties would be used to specify that cells in a column must contain a monetary value? Null status Default value Data type Data constraints Null status Default value Data type Data constraints ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The identifier of an entity will become the ________ of the new table. identity key main attribute foreign key primary key identity key main attribute foreign key primary key ANSWER DOWNLOAD EXAMIANS APP
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 When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS