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 the primary key a surrogate key any alternate key a foreign key the primary key a surrogate key any alternate key 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
Data Models into Database Designs Cascading updates refers to child rows being automatically deleted when a parent row is deleted. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:1 relationship, the foreign key is placed in: the child table. the parent table. either table without specifying parent and child tables. either the parent table or the child table. the child table. the parent table. either table without specifying parent and child tables. either the parent table or the child table. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Intersection tables are ID-dependent on both their parent tables. True False True False 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? None of these Both of the above MUST NOT MUST COVER None of these Both of the above MUST NOT MUST COVER ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS