Data Models into Database Designs Which of the following columns is(are) are required in a table? A foreign key A surrogate key A primary key An alternate key A foreign key A surrogate key A primary key An alternate key 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 When the parent entity is required and the parent has a surrogate key, update actions can be ignored. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs All primary keys are required. False True False True 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 For every relationship, how many possible types of actions are there when enforcing minimum cardinalities? Three Two Four Six Three Two Four Six ANSWER DOWNLOAD EXAMIANS APP