CIS164AG - Project Two - Normalization
Name: _____________________________________ 
(Please Print)
Date Due: 
At the start of class.
Points: 
40 max.

Data Dependency Diagram [15 points]

Neatly fill in the following table.
 
Attribute Determines these attribute(s) 
Id  
Description  
Level  
Sec.  
Cost  
Enr.  
Loc.  
Region  
Instructor  
Avail.  
Pre-req.  

Normalized Tables [25 points]

____ All tables in Third Normal Form.

     ____ No repeating groups.

     ____ No partial key dependencies.

     ____ No transitive dependencies.

____ All primary keys identified.

____ Correct attributes identified and placed in correct tables.

Please neatly print your tables below.