Data Models into Database Designs An ideal primary key is short, numeric and seldom changing. 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A foreign key is: All of these used to define null status. used to define data types. a column containing the primary key of another table. All of these used to define null status. used to define data types. a column containing the primary key of another table. 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 NOT None of these MUST COVER Both of the above MUST NOT None of these MUST COVER Both of the above 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. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The identifier of an entity will become the ________ of the new table. foreign key main attribute primary key identity key foreign key main attribute primary key identity key ANSWER DOWNLOAD EXAMIANS APP