Data Models into Database Designs In a 1:N relationship, the foreign key is placed in: either the parent table or the child table. the parent table. the child table. either table without specifying parent and child tables. either the parent table or the child table. the parent table. the child table. either table without specifying parent and child tables. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited. False True False True ANSWER DOWNLOAD EXAMIANS APP
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 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 a surrogate key any alternate key the primary key a foreign key a surrogate key any alternate key the primary key 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 Multivalued attributes only All of these Association relationships only Archetype/instance relationships only Multivalued attributes only All of these ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A foreign key is: a column containing the primary key of another table. used to define null status. All of these used to define data types. a column containing the primary key of another table. used to define null status. All of these used to define data types. ANSWER DOWNLOAD EXAMIANS APP