Data Models into Database Designs When transforming an entity-relationship model into a relational database design, each entity is represented as a table. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the parent entity is required, a new parent row can always be inserted. True False True False 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. any alternate key a surrogate key the primary key a foreign key any alternate key a surrogate key the primary key a foreign key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:1 relationship, the foreign key is placed in: either table without specifying parent and child tables. the parent table. either the parent table or the child table. the child table. either table without specifying parent and child tables. the parent table. either the parent table or the child table. the child table. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following column properties would be used to specify that cells in a column must contain a monetary value? Default value Data constraints Data type Null status Default value Data constraints Data type Null status ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A foreign key is: used to define data types. a column containing the primary key of another table. All of these used to define null status. used to define data types. a column containing the primary key of another table. All of these used to define null status. ANSWER DOWNLOAD EXAMIANS APP