Data Models into Database Designs In a 1:N relationship, the foreign key is placed in: the parent table. either the parent table or the child table. the child table. either table without specifying parent and child tables. the parent table. either the parent table or the child table. the child table. either table without specifying parent and child tables. 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 surrogate key a foreign key the primary key any alternate key a surrogate key a foreign key the primary key ANSWER DOWNLOAD EXAMIANS APP
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 In 1:N relationships, which entity becomes the parent entity is arbitrary. True False True False 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 Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table? An intrarelation constraint A range constraint An interrelation constraint A domain constraint An intrarelation constraint A range constraint An interrelation constraint A domain constraint ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS