Data Models into Database Designs The identifier of an entity will become the ________ of the new table. primary key identity key main attribute foreign key primary key identity key main attribute 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? None of these MUST NOT Both of the above MUST COVER None of these MUST NOT Both of the above MUST COVER ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:1 relationship, the primary key placement is arbitrary. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key. 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): foreign key. composite key. primary key. surrogate key. foreign key. composite key. primary key. surrogate key. 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 a foreign key the primary key a surrogate key any alternate key a foreign key the primary key a surrogate key ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS