Data Models into Database Designs The identifier of an entity will become the ________ of the new table. foreign key main attribute primary key identity key foreign key main attribute primary key identity key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs Which of the following columns is(are) are required in a table? A surrogate key A primary key A foreign key An alternate key A surrogate key A primary key A foreign key An alternate key ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A foreign key is: used to define data types. used to define null status. a column containing the primary key of another table. All of these used to define data types. used to define null status. a column containing the primary key of another table. All of these ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs In a 1:1 relationship, the foreign key is placed in: 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. the parent table. the child table. ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS