Data Models into Database Designs When transforming an entity-relationship model into a relational database design, each entity is represented as a table. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The DBMS allows surrogate keys to be changed. True False True False 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 A primary key should be defined as: NULL. NOT NULL. Either of the above can be used. None of these NULL. NOT NULL. Either of the above can be used. None of these ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The identifier of an entity will become the ________ of the new table. foreign key primary key main attribute identity key foreign key primary key main attribute identity key 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 foreign key the primary key any alternate key a surrogate key a foreign key the primary key any alternate key a surrogate key ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS