An Improved Third Normal Form for Relational Databases

  title={An Improved Third Normal Form for Relational Databases},
  author={Tok Wang Ling and Frank Wm. Tompa and Tiko Kameda},
  journal={ACM Trans. Database Syst.},
In this paper, we show that some Codd third normal form relations may contain “superfluous” attributes because the definitions of transitive dependency and prime attribute are inadequate when applied to sets of relations. To correct this, an improved third normal form is defined and an algorithm is given to construct a set of relations from a given set of functional dependencies in such a way that the superfluous attributes are guaranteed to be removed. This new normal form is compared with… CONTINUE READING


Publications referenced by this paper.

Synthesizing Third Normal Form Relations from Functional Dependencies

ACM Trans. Database Syst. • 1976
View 3 Excerpts
Highly Influenced

Similar Papers

Loading similar papers…