Data Models into Database Designs A foreign key is: a column containing the primary key of another table. used to define data types. All of these used to define null status. a column containing the primary key of another table. used to define data types. All of these used to define null status. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A primary key should be defined as: None of these NOT NULL. Either of the above can be used. NULL. None of these NOT NULL. Either of the above can be used. NULL. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row? Null status Data constraints Data type Default value Null status Data constraints Data type Default value 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 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 the primary key any alternate key a surrogate key a foreign key the primary key any alternate key a surrogate 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