database normalisation
Sign in to saveAlso known as database normalization
reduction of data redundancy
Wikidata facts
Show 2 more facts
- Stack Exchange tag
- dba.stackexchange.com/tags/normalization
- P8168
- The Rose
Sources (3)
via Wikidata · CC0
~16 min read
Article
Database normalization is the process of structuring a relational database in accordance with a series of normal forms to reduce data redundancy and improve data integrity. It was first proposed by British computer scientist Edgar F. Codd as part of his relational model.
Normalization entails organizing the columns (attributes) and tables (relations) of a database to ensure that their dependencies are properly enforced by database integrity constraints. It is accomplished by applying some formal rules either by a process of synthesis (creating a new database design) or decomposition (improving an existing database design).
Connections
database
Entity
query language
Entity
data integrity
Entity
referential integrity
Entity
first normal form
Entity
third normal form
Entity
second normal form
Entity
Boyce–Codd normal form
Entity
Christopher J. Date
Entity
fourth normal form
Entity
fifth normal form
Entity
sixth normal form
Entity
domain-key normal form
Entity
multi-model database system
Entity
International Standard Book Number
Entity
Wayback Machine
Entity
Q47607
Entity
digital object identifier
Entity
OCLC, Inc.
Entity
British
Entity