Data Models into Database Designs Which of the following situation requires the use of ID-dependent entities? Archetype/instance relationships only Multivalued attributes only All of these Association relationships only Archetype/instance relationships only Multivalued attributes only All of these Association relationships only 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. the primary key a surrogate key a foreign key any alternate key the primary key a surrogate key a foreign key any alternate key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which is not true about surrogate keys? They have meaning to the user. They are fixed. They are short. They are numeric. They have meaning to the user. They are fixed. They are short. They are numeric. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:1 relationship, the primary key placement is arbitrary. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Intersection tables are ID-dependent on both their parent tables. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values? A range constraint An intrarelation constraint An interrelation constraint A domain constraint A range constraint An intrarelation constraint An interrelation constraint A domain constraint ANSWER DOWNLOAD EXAMIANS APP