ARTÍCULO
TITULO

Normalizing Database Normalization Definitions In AIS Text Books

Ting J. (TJ) Wang    
David K. Dennis    

Resumen

Due to the abstract nature of the definitions for normal forms, over the years the interpretations of the definitions published in the textbooks, both MIS and AIS disciplines, have been differentiated and even deviated from its original form. The concept of deviation from the original form is a phenomenon that linguists call semantic drift. The most noticeable deviations are on first and second normal forms (i.e., 1NF and 2NF). Their definitions range from atomic attribute to removing repeating group for 1NF and from functional dependency to removing partial dependency in addition to being 1NF for 2NF. The purpose of this paper is to compare definitions of first, second, and third normal forms from the textbooks with those of the earlier forms and to identify shortfalls if there are any.