Completion
Complete each sentence or
statement.


1.

The
____________________ process enables you to identify the existence of potential
problems.


2.

To
correct ____________________ anomalies in a database, you must convert tables into various types of
normal forms.


3.

A
table in a particular ____________________ form possesses a certain desirable collection of
properties.


4.

An
attribute named B is functionally ____________________ on another column named A if a value for A
determines a single value for B at any one time.


5.

If B
is functionally ________________________ on A, we can use the notation A>B.


6.

We
can say that column A is the ____________________ key for a relation if all columns in the relation
are functionally dependent on A and no subcollection of columns in A is also functionally dependent
on A.


7.

A
relation is in first normal form if it does not contain ____________________ groups.


8.

A
column is a(n) ____________________ column if it is not a part of the primary key.


9.

A
relation is in second normal form if it in first normal form and no nonkey column is
____________________ on only a portion of the primary key.


10.

Any
column that determines another column is called a(n) ____________________.


11.

A
table is in third normal form if it is in second normal form and the only determinants it contains
are ____________________ keys.


12.

A
better definition or name for the third normal form is referred to as ____________________ normal
form.


13.

A
table is in fourth normal form if it is in third normal form and there are no ____________________
dependencies.


14.

In a
table with columns A, B, and C, there is a multivalued dependency of B on A if each value for A is
associated with a specific collection of values for B, and further, this collection is
____________________ of any values for C.


15.

A(n)
_______________________ dependency of column B on column A of the same table is usually written as A
>> B.


16.

The
conversion of a(n) ____________________ form to first normal form requires the removal of repeating
groups.


17.

If
there are two or more repeating groups in a table, you must place each repeating group in a(n)
____________________ table.


18.

To
summarize the requirements of a first normal form, there must be no ______________________
groups.


19.

To
summarize the requirements for the third normal form, the table must be in second normal form with
the only ____________________ being candidate keys.


20.

To
summarize the requirements for the fourth normal form, the table must be in third normal form and
have no multivalued ____________________.

Short Answer


21.

What
process enables you to identify the existence of potential problems?


22.

There
are potential problems that can occur in relations (tables). What are these problems
called?


23.

What
is the terminology for a value in column A in a table to determine a single value for column B in the
same table at any one time?


24.

If
there are a number of columns that could be classified as a primary key, what is the term for all
these possibilities?


25.

If a
candidate key is not chosen as the primary key, by what term are these candidate keys
referred?


26.

What
is a column called if it is not a part of the primary key?


27.

If
the primary key of a table contains only a single column, then this table is in what normal
form?


28.

What
is the term for any column that determines another column?


29.

When
a table is in third normal form, it is in second normal form and the only determinants it contains
are what type of keys?

Essay





30.

Please refer to the above figure. Is Class the primary key for the Part
table? Explain your answer.





31.

Using
the above figure, explain the reason for splitting the Faculty table into two separate
tables. Use the concepts of update, additions, and deletions in examples as the basis for
your answer.


32.

How
do we divide tables that have two or more repeating groups? How do we create the new primary
key?
