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 a foreign key the primary key any alternate key a surrogate key a foreign key the primary key any alternate key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A primary key should be defined as: None of these Either of the above can be used. NOT NULL. NULL. None of these Either of the above can be used. NOT NULL. NULL. 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 interrelation constraint An intrarelation constraint A domain constraint A range constraint An interrelation constraint An intrarelation constraint A domain constraint ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the parent entity is required, a new parent row can always be inserted. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following situation requires the use of ID-dependent entities? Association relationships only Archetype/instance relationships only All of these Multivalued attributes only Association relationships only Archetype/instance relationships only All of these Multivalued attributes only ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS