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 any alternate key a foreign key a surrogate key the primary key any alternate key a foreign key a surrogate key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Each entity is represented as a(n): table. tuple. attribute. file. table. tuple. attribute. file. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time. False True False True 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 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? A range constraint An intrarelation constraint A domain constraint An interrelation constraint A range constraint An intrarelation constraint A domain constraint An interrelation constraint ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following situation requires the use of ID-dependent entities? Association relationships only Multivalued attributes only Archetype/instance relationships only All of these Association relationships only Multivalued attributes only Archetype/instance relationships only All of these ANSWER DOWNLOAD EXAMIANS APP