Normalization ________ data duplication. reduces maximizes increases eliminates 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: second step. third step. fourth step. first step. TRUE ANSWER : ? YOUR ANSWER : ?
If a table has been normalized so that all determinants are candidate keys, then that table is in: 1NF. 3NF. BCNF. 2NF. TRUE ANSWER : ? YOUR ANSWER : ?
Read-only databases are ________ updated. never seldom always commonly TRUE ANSWER : ? YOUR ANSWER : ?
When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the: first step. fourth step. second step. third step. 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. True False TRUE ANSWER : ? YOUR ANSWER : ?
For a number of reasons, normalizations is not often an advantage for a(n) ________ database. None of these either a read-only or an updateable updateable read-only TRUE ANSWER : ? YOUR ANSWER : ?
Eliminating modification anomalies is a(n) ________ of normalization. either an advantage or disadvantage disadvantage advantage neither an advantage nor disadvantage TRUE ANSWER : ? YOUR ANSWER : ?
One common design problem when designing a database from existing data is the use of a general-purpose remarks column in the received data. False True TRUE ANSWER : ? YOUR ANSWER : ?