Chapter 6

Question 1

In order for a table to be in the _______________, none of the columns should have
multiple values in the same row of data

Answer 1

first normal form (1NF)

Question 2

The _______________ requires that all non-key columns are functionally dependent on
the entire primary key

Answer 2

second normal form (1NF

Question 3

The _______________requires that there is no functional dependency among non-key
attributes.

Answer 3

third normal form (1NF)

Question 4

The basic building blocks for an entity-relationship diagram are _______________,
_______________, and _______________

Answer 4

Entity, Attribute, Relationship

Question 5

The _______________ clause in a SELECT statement evaluates each row for a
condition and decides whether to include it in the result set.

Answer 5

WHERE

Question 6

The object used with the using statement must implement the _______________
interface

Answer 6

IDisposable

Question 7

T-SQL’s _______________ statement can be used to create a stored procedure

Answer 7

CREATE PROCEDURE

Question 8

In the process of _______________, you apply a set of rules to ensure that your
database design helps with data integrity and ease of maintenance in the future.

Answer 8

normalization

Question 9

You find classes for working with streams and backing stores in the _______________
namespace

Answer 9

System.IO

Question 10

The _______________ format is a hierarchical data representation format.

Answer 10

XML