Normalizing Database Normalization Definitions In AIS Text Books

Abstract

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.