Data Models into Database Designs A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n): foreign key. composite key. surrogate key. primary key. foreign key. composite key. surrogate key. primary key. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:1 relationship, the foreign key is placed in: 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. either table without specifying parent and child tables. the parent table. either the parent table or the child table. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The terms alternate key and candidate key mean the same thing. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The identifier of an entity will become the ________ of the new table. identity key foreign key main attribute primary key identity key foreign key main attribute primary key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following column properties specifies whether or not cells in a column must contain a data value? Default value Data type Data constraints Null status Default value Data type Data constraints Null status 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? Data constraints Data type Default value Null status Data constraints Data type Default value Null status ANSWER DOWNLOAD EXAMIANS APP