third normal form

This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)

normalization

In relational database management, a process that breaks down data into record groups for efficient processing. There are six normalization stages. By the third stage (third normal form), data are identified only by the key field in their record. For example, ordering information is identified by order number, and customer information by customer number. A major goal of normalization is to eliminate redundancy by having a data element represented in only one place. See relational database, functional dependency and denormalization.

Copyright © 1981-2025 by The Computer Language Company Inc. All Rights reserved. THIS DEFINITION IS FOR PERSONAL USE ONLY. All other reproduction is strictly prohibited without permission from the publisher.

Mentioned in

References in periodicals archive

[11.] Bernstein, P.A.: Synthesizing third normal form relations from functional dependencies.

An algorithmic approach to database normalization

In this later paper Codd introduces "second normal form" (2NF) and "third normal form" (3NF).

First normal form reconsidered

All content on this website, including dictionary, thesaurus, literature, geography, and other reference data is for informational purposes only. This information should not be considered complete, up to date, and is not intended to be used in place of a visit, consultation, or advice of a legal, medical, or any other professional.