Data Models into Database Designs A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n): primary key. composite key. surrogate key. foreign key. primary key. composite key. surrogate key. foreign key. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The terms alternate key and candidate key mean the same thing. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the parent entity is required and the parent has a surrogate key, update actions can be ignored. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Each entity is represented as a(n): table. attribute. file. tuple. table. attribute. file. tuple. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs The identifier of an entity will become the ________ of the new table. main attribute foreign key identity key primary key main attribute foreign key identity key primary key ANSWER DOWNLOAD EXAMIANS APP
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