Data Models into Database Designs An intersection table is required to represent M:N relationships. False True False True 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. a foreign key any alternate key a surrogate key the primary key a foreign key any alternate key a surrogate key the primary key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:N relationship, the foreign key is placed in: the child table. either table without specifying parent and child tables. either the parent table or the child table. the parent table. the child table. either table without specifying parent and child tables. either the parent table or the child table. the parent table. ANSWER DOWNLOAD EXAMIANS APP
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, a new parent row can always be inserted. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following situation requires the use of ID-dependent entities? Association relationships only Multivalued attributes only All of these Archetype/instance relationships only Association relationships only Multivalued attributes only All of these Archetype/instance relationships only ANSWER DOWNLOAD EXAMIANS APP