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. the primary key a surrogate key any alternate key a foreign key the primary key a surrogate key any alternate key a 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? Both of the above None of these MUST COVER MUST NOT Both of the above None of these MUST COVER MUST NOT ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A primary key should be defined as: None of these Either of the above can be used. NULL. NOT NULL. None of these Either of the above can be used. NULL. NOT NULL. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following columns is(are) are required in a table? A surrogate key An alternate key A foreign key A primary key A surrogate key An alternate key A foreign key A primary key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Surrogate keys have much meaning for users. 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 A domain constraint An interrelation constraint An intrarelation constraint A range constraint A domain constraint An interrelation constraint ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS