One common design problem when designing a database from existing data is the presence of missing values, called blank values, in received data. False True TRUE ANSWER : ? YOUR ANSWER : ?
When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the: third step. first step. fourth step. second step. TRUE ANSWER : ? YOUR ANSWER : ?
The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint. True False TRUE ANSWER : ? YOUR ANSWER : ?
Each answer below shows example data from a table. Which answer is an example of the missing values problem? One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column. Three rows have the values Brown, NULL, and Blue in the same column. Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row. Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column. TRUE ANSWER : ? YOUR ANSWER : ?
Multivalued dependencies should ________ be eliminated. never seldom always commonly TRUE ANSWER : ? YOUR ANSWER : ?
Read-only databases are ________ updated. seldom always never commonly TRUE ANSWER : ? YOUR ANSWER : ?
Most of the time, modification anomalies cause problems that are severe enough that a table should be normalized into BCNF. True False TRUE ANSWER : ? YOUR ANSWER : ?
When building a database from an existing set of tables, we still need to consider normalization principles. False True TRUE ANSWER : ? YOUR ANSWER : ?
When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given. False True TRUE ANSWER : ? YOUR ANSWER : ?
Most of the time, modification anomalies are serious enough that tables should be normalized into: BCNF. 2NF. 3NF. 1NF. TRUE ANSWER : ? YOUR ANSWER : ?