Q.1
When assessing the table structure of an acquired set of tables with data, determining functional dependencies is (part of) the:
Q.2
When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:
Q.3
Creating a read-only database is a task that is ________ assigned to beginning database professionals.
Q.4
When building a database from an existing set of tables, we still need to consider normalization principles.
Q.5
We have normalized a table into BCNF if all candidate keys are determinants.
Q.6
We use the SQL construct COLUMNS(*) to determine the number and type of columns in a table.
Q.7
When assessing the table structure of an acquired set of tables with data, determining primary keys is (part of) the:
Q.8
Normalization ________ data duplication.
Q.9
Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
Q.10
Each answer below shows example data from a table. Which answer is an example of the multivalue, multicolumn problem?
Q.11
When assessing the table structure of an acquired set of tables with data, counting the number of table rows is (part of) the:
Q.12
Each answer below shows example data from a table. Which answer is an example of the general-purpose remarks column problem?
Q.13
For a number of reasons, normalizations is not often an advantage for a(n) ________ database.
Q.14
If a table has been normalized so that all determinants are candidate keys, then that table is in:
Q.15
Most of the time, modification anomalies are serious enough that tables should be normalized into:
Q.16

The design guidelines and priorities for read-only databases are different because read-only databases are never updated.

  • True
  • False
Q.17

One common design problem when designing a database from existing data is the use of a single cell in one column to store multiple values of an attribute.

  • True
  • False
Q.18

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
Q.19

The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.

  • True
  • False
Q.20

In all cases, normalization into BCNF is desirable.

  • True
  • False
0 h : 0 m : 1 s