Database Design Using Normalization Questions

• Read-only databases are ________ updated.
• Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
• Needing to using more complicated SQL in database applications is a(n) ________ of normalization.
• Normalization ________ data duplication.
• When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:
• Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
• Multivalued dependencies should ________ be eliminated.
• 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:
• When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:
• Eliminating modification anomalies is a(n) ________ of normalization.
• When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:
• Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
• Creating a read-only database is a task that is ________ assigned to beginning database professionals.
• Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?
• For a number of reasons, normalizations is not often an advantage for a(n) ________ database.
• Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
• Most of the time, modification anomalies are serious enough that tables should be normalized into:
• If a table has been normalized so that all determinants are candidate keys, then that table is in:
• When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:
• Each answer below shows example data from a table. Which answer is an example of the missing values problem?