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 For every relationship, how many possible types of actions are there when enforcing minimum cardinalities? Four Six Three Two Four Six Three Two ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following column properties specifies whether or not cells in a column must contain a data value? Data constraints Data type Default value Null status Data constraints Data type Default value Null status ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs An ideal primary key is short, numeric and seldom changing. False True False True 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. surrogate key. foreign key. composite key. primary key. surrogate key. foreign 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 NOT None of these Both of the above MUST COVER MUST NOT None of these Both of the above MUST COVER ANSWER DOWNLOAD EXAMIANS APP