Data Models into Database Designs Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship? MUST NOT Both of the above MUST COVER None of these MUST NOT Both of the above MUST COVER None of these 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. any alternate key the primary key a foreign key a surrogate key any alternate key the primary key a foreign key a surrogate key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key. True False True False 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 the parent table or the child table. either table without specifying parent and child tables. the child table. the parent table. either the parent table or the child table. either table without specifying parent and child tables. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:1 relationship, the primary key placement is arbitrary. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which is not true about surrogate keys? They are short. They are fixed. They have meaning to the user. They are numeric. They are short. They are fixed. They have meaning to the user. They are numeric. ANSWER DOWNLOAD EXAMIANS APP