Data Models into Database Designs For every relationship, there are six possible referential integrity actions. 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 surrogate key the primary key a foreign key any alternate key a surrogate key the primary key a foreign key any alternate key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A foreign key is: 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. a column containing the primary key of another table. used to define data types. 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. False True False True 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 be immediately filled with a monetary value of $10,000? Default value Data type Data constraints Null status Default value Data type Data constraints Null status ANSWER DOWNLOAD EXAMIANS APP