Data Models into Database Designs In a 1:1 relationship, the foreign key is placed in: the parent table. the child table. either the parent table or the child table. either table without specifying parent and child tables. the parent table. the child table. either the parent table or 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, a new child row can always be inserted. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following columns is(are) are required in a table? An alternate key A primary key A foreign key A surrogate key An alternate key A primary key A foreign key A surrogate key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n): surrogate key. composite key. primary key. foreign key. surrogate key. composite key. primary key. foreign key. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship? Both of the above None of these MUST COVER MUST NOT Both of the above None of these MUST COVER MUST NOT ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A foreign key is: used to define data types. All of these used to define null status. a column containing the primary key of another table. used to define data types. All of these used to define null status. a column containing the primary key of another table. ANSWER DOWNLOAD EXAMIANS APP