A simple guide to five normal forms in relational database theory

@article{Kent1983ASG,
  title={A simple guide to five normal forms in relational database theory},
  author={William Kent},
  journal={Commun. ACM},
  year={1983},
  volume={26},
  pages={120-125}
}
  • W. Kent
  • Published 1 February 1983
  • Economics
  • Commun. ACM
<italic>The concepts behind the five principal normal forms in relational database theory are presented in simple terms.</italic> 

Performance Criteria for Relational Database Normalization

the efficiency of We find that in almost all cases where there are multi-valued dependencies, the normal form is more efficient.

A theory of data dependencies over relational expressions

  • M. Casanova
  • Computer Science
    International Journal of Computer & Information Sciences
  • 2004
A class of integrity constraints for the relational model of data, called implicational dependencies over relational expressions (or, simply, IDEXs), is defined and a refutation procedure, which is a direct adaptation of first-order analytic tableaux, is introduced.

Representation of Data Structures Using the Entity Relationship Model and the Transformation in Relational Databases

It is shown here how the structure of relationships, as well as the properties of Relationships, and the role of language in this discussion can be changed over time from simple to complex.

Normalization of relations and PROLOG

The program presented here implements several normalization algorithms and is suitable for the interactive design of small database applications and as a teaching aid.

Tutorial: The relational data model for Design Automation

This tutorial explains what the relational data model is and how database management systems based on it can be used with Design Automation applications.

A simple taxonomy for distributed mutual exclusion algorithms

This short paper examines the two basic principles from which distributed mutual exclusion algorithms are designed : permission-based and token-based principles. This presentation is done in a

Boyce-Codd Normal Form and Object Normal Forms

  • J. Biskup
  • Computer Science
    Inf. Process. Lett.
  • 1989

Re-Engineering Relational Normal Forms in an Object-Oriented Framework

This paper reviews relational normal forms, interprets them in an object-oriented context, and provides guidelines to port relationalnormal forms to an object the database designer must reconcile normalization processes with newer approaches that identify the core application classes.

The practical need for fourth normal form

The need to understand and user fourth normal form is more important than previously believed after a study of forty organizational databases found that nine of them contained data violating fourthnormal form.

MULTIVALUED DEPENDENCIES AND FIFTH NORMAL FORM OF RELATIONAL DATABASES

This work tries to represent, how the concept of multivalued dependency is used in Fifth Normal Form (5NF), a Forth Normal Form for relational schemata.
...

References

SHOWING 1-10 OF 15 REFERENCES

Normal forms and relational database operators

We discuss the relationship between normal forms in a relational database and an allowed set of relational operators. We define "projection-join normal form" (PJ/NF), which is the ultimate normal

An improved third normal form for relational databases

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.

Normalized data base structure: a brief tutorial

  • E. Codd
  • Computer Science
    SIGFIDET '71
  • 1971
This paper illustrates the removal of repeating groups, hierarchic and plex structures, and cross-referencing structures and the simplification of data base relations by normalization is discussed.

Multivalued dependencies and a new normal form for relational databases

It is shown that every relation schema can be decomposed into a family of relation schemata in fourth normal form without loss of information (that is, the original relation can be obtained from the new relations by taking joins).

A relational model of data for large shared data banks

A model based on n-ary relations, a normal form for data base relations, and the concept of a universal data sublanguage are introduced and certain operations on relations are discussed and applied to the problems of redundancy and consistency in the user's model.

A relational model of data for large shared data banks

A model based on n-ary relations, a normal form for data base relations, and the concept of a universal data sublanguage are introduced and certain operations on relations are discussed and applied to the problems of redundancy and consistency in the user's model.

An Introduction to Database Systems, 3rd Edition

Further Normalization of the Data Base Relational Model

  • E. Codd
  • Computer Science
    Research Report / RJ / IBM / San Jose, California
  • 1971

The original paper introducing the relational data model

  • The original paper introducing the relational data model

CR Categories and Subjects: H.2.1 [Database Management]: Logical Design--normal forms General Term

  • CR Categories and Subjects: H.2.1 [Database Management]: Logical Design--normal forms General Term