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 When transforming an entity-relationship model into a relational database design, each entity is represented as a table. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A primary key should be defined as: NOT NULL. None of these Either of the above can be used. NULL. NOT NULL. None of these Either of the above can be used. NULL. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the parent entity is required and the parent has a surrogate key, update actions can be ignored. True False True False 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? Data type Default value Data constraints Null status Data type Default value Data constraints Null status 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