Data Models into Database Designs The identifier of an entity will become the ________ of the new table. identity key primary key main attribute foreign key identity key primary key main attribute foreign key 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? Null status Data type Default value Data constraints Null status Data type Default value Data constraints 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? MUST COVER Both of the above MUST NOT None of these MUST COVER Both of the above MUST NOT None of these 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. foreign key. primary key. surrogate key. composite key. foreign key. primary key. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:N relationship, the foreign key is placed in: 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. either the parent table or the child table. the parent table. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs All primary keys are required. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS