Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.
Edgar F. Codd, the inventor of the relational model, introduced the concept of normalization and what we now know as the First Normal Form (1NF) in 1970. Codd went on to define the Second Normal Form (2NF) and Third Normal Form (3NF) in 1971, and Codd and Raymond F. Boyce defined the Boyce-Codd Normal Form (BCNF) in 1974. Informally, a relational database table is often described as "normalized" if it is in the Third Normal Form. Most 3NF tables are free of insertion, update, and deletion anomalies.
A standard piece of database design guidance is that the designer should create a fully normalized design; selective denormalization can subsequently be performed for performance reasons.
Read more about Database Normalization: Objectives of Normalization, Background To Normalization: Definitions, Normal Forms, Denormalization
Other articles related to "database":
... The Database and Collections of Information Misappropriation Act, H.R ... Proponents argued that the bill was based on the 1996 EU Database Directive, and was designed to encourage database creators by ensuring their revenue ...
... In April 2007, responsibility for the delivery of National DNA Database (NDNAD) services was transferred from the Home Office to the National Policing Improvement Agency (NPIA) ... The agency's role was to run the database operations and maintain and ensure the integrity of the data, and to oversee the National DNA Database service so that it is ...
... The United Kingdom National DNA Database (NDNAD officially the UK National Criminal Intelligence DNA Database) is a national DNA Database that was set up in 1995 ... In March 2012 the database contained an estimated 5,950,612 individuals ... The database, which grows by 30,000 samples each month, is populated by samples recovered from crime scenes and taken from police suspects and, in England ...
... to develop and later maintain an application built around its respective database type ... Examples for tools relate to database design, application programming, application program maintenance, database performance analysis and monitoring ...
Famous quotes containing the word normal:
“Every normal person, in fact, is only normal on the average. His ego approximates to that of the psychotic in some part or other and to a greater or lesser extent.”
—Sigmund Freud (1856–1939)