Chapter 4: Database Design Using Normalization

When you are given a set of tables and asked to create a database to store their data, the first step is to ________.

• assess the existing tables' structure and content

• design the database structure

• create one or more new tables

• move the data into the new database

The first step in assessing table structure includes ________.

• counting rows

• examining columns

• examining data values

• Both A and B are correct

The second step in assessing table structure includes ________.

• counting rows

• examining columns

• examining data values

• A and B

During the second step of assessing table structure, you are trying to determine ________.

• multivalued dependencies

• data types

• missing values

• subqueries

During the second step of assessing table structure, you are trying to determine ________.

• relationships

• candidate keys

• updatability

• efficiency

To count the number of rows in a table, use the SQL construct ________.

• SELECT *

• SELECT TOP n *

• SELECT COUNT(TOP n)

• SELECT COUNT(*)

The SQL function COUNT ________.

• counts the number of columns in a table

• counts the number of rows in a table

• counts the number of tables in a database

• counts the number of updates to a database

To limit the number of rows retrieved from a table, use the SQL construct ________.

• SELECT *

• SELECT TOP n *

• SELECT COUNT(TOP n)

• SELECT COUNT(*)

The SQL keyword TOP ________.

• limits the number of columns retrieved from a table

• limits the number of rows retrieved from a table

• limits the number of tables retrieved from a database

• A and C

You have been given two tables, CUSTOMER and SALE. You want to check the referential integrity constraint: SALE.CustomerNumber must exist in CUSTOMER.CustomerNumber You run the following SQL query: SELECT CustomerNumber FROM SALE WHERE CustomerNumber NOT IN (SELECT CustomerNumber FROM CUSTOMER); What is shown in the results of this query?

• All values of CustomerNumber that match the constraint.

• All values of CustomerNumber that violate the constraint.

• All values of CustomerNumber where SALE.CustomerNumber = CUSTOMER.CustomerNumber.

• All values of Customer number that are in CUSTOMER but not in SALE.