Data Models into Database Designs A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n): composite key. primary key. foreign key. surrogate key. composite key. primary key. foreign key. surrogate key. 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the parent entity is required, a new parent row can always be inserted. True False True False ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values? A range constraint A domain constraint An intrarelation constraint An interrelation constraint A range constraint A domain constraint An intrarelation constraint An interrelation constraint ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:1 relationship, the foreign key is placed in: either table without specifying parent and child tables. either the parent table or the child table. the child table. the parent table. either table without specifying parent and child tables. either the parent table or the child table. the child table. the parent table. 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 All of these Multivalued attributes only Association relationships only Archetype/instance relationships only All of these Multivalued attributes only ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS