1.   Match the Following Terms on the Left with the Correct Definitions on the Right:

 

J.    Normalization

H.   Referential Integrity

D.   Anomoly

G.   Functional Dependency

A.   Transitive Dependency

B.   Composite Key

K.   Multi-valued Key

E.    1NF

C.    2NF

I.     3NF

F.    BCNF

A.

B.

C.

D.

E.

F.

G.

H.

I.

J.

K.

Functional Dependency Between nonkey attributes

An Attribute that can be broken down into component parts

Contains no partial Dependencies

Inconsistency or errors created in editing

Contains no repeating groups

Accounts for Editting Anomolies

The value of one attribute depends on a primary key

Constraint between 2 attributes

Transitive Dependencies eliminated

The process of determining how attributes should be grouped

An attribute that may take on more than one value