Definitions of Normalization



     First Normal Form:  
     
     A relation which contains no multi-valued attributes.
     
     All of the attributes are dependent on the primary key.
     
     
     
     Second Normal Form:
     
     A relation this is in First Normal Form and has every non key
     attribute fully functionally dependent on the primary key.
     
     All of the non key attributes are dependent on all of the key.
     
     (No non key attribute(s) is functionally dependent on part (but not all)
     of the primary key.)
     
     Partial functional dependency:
     
     A functional dependency in which one or more non key attributes are
     functionally dependent on part (but not all) of the primary key.
     
     
     Third Normal Form:
     
     A relation that is in Second Normal Form and has no 
     transitive dependencies present.
     
     Transitive Dependency:
     
     A functional dependency between two (or more) non key attributes
     
     
     

Home | Syllabus | Assignments
Schedule | Hand Outs | Lesson Outlines
College of Business and Technology | Information Management & Decision Sciences
Western Illinois University | Western Illinois University Regional Center