Data Models into Database Designs When the parent entity is required, a new parent row can always be inserted. False True False True ANSWER DOWNLOAD EXAMIANS APP
Data Models into Database Designs A primary key should be defined as: NULL. None of these Either of the above can be used. NOT NULL. NULL. None of these Either of the above can be used. NOT NULL. 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 None of these MUST NOT MUST COVER Both of the above None of these MUST NOT 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. 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 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 Which of the following column properties would be used to specify that cells in a column must contain a monetary value? Default value Null status Data type Data constraints Default value Null status Data type Data constraints ANSWER DOWNLOAD EXAMIANS APP