database normalisation

(redirected from Database normalization)
Also found in: Wikipedia.

database normalisation

(database)
A series of steps followed to obtain a database design that allows for efficient access and storage of data in a relational database. These steps reduce data redundancy and the chances of data becoming inconsistent.

A table in a relational database is said to be in normal form if it satisfies certain constraints. Codd's original work defined three such forms but there are now five generally accepted steps of normalisation. The output of the first step is called First Normal Form (1NF), the output of the second step is Second Normal Form (2NF), etc.

First Normal Form eliminates repeating groups by putting each value of a multi-valued attribute into a new row.

Second Normal Form eliminates functional dependencies on a partial key by putting the fields in a separate table from those that are dependent on the whole key.

Third Normal Form eliminates functional dependencies on non-key fields by putting them in a separate table. At this stage, all non-key fields are dependent on the key, the whole key and nothing but the key.

Fourth Normal Form separates independent multi-valued facts stored in one table into separate tables.

Fifth Normal Form breaks out data redundancy that is not covered by any of the previous normal forms.

http://bkent.net/Doc/simple5.htm.

References in periodicals archive ?
Students completing the case should have been taught REA, database normalization, and entity relationship diagrams.
A perusal of database textbooks exposes an obvious disagreement as to how to teach database normalization.
Conversely, it is not the intention of this paper to explain database normalization in detail.
Services include parcel mapping, GIS/CAMA integration, COGO construction, database normalization, CAD-to-GIS conversion, systems integration, internal data access, e-commerce data brokerage, training, toll-free support, as well as GIS data conversion services.
Our services include parcel mapping, GIS/CAMA integration, COGO construction, database normalization, CAD to GIS, systems integration, internet data access, e-commerce data brokerage, training, toll-free support, as well as data conversion services.
com includes more than a dozen executives, engineers and analysts who establish direct relationships with vendors to ensure database normalization and provide the technical expertise needed to develop and maintain the site.
health language, hli, language engine technology, medical vocabulary, medical terminology, activehealth, health management, clinical content management, administrative content management, frank norman, language engine, ICD-9, ICD-10, CPT-4, HCPCS, LOINC, FDB-ETC, clinical health information, payers, healthcare, health care IT, interoperability, george schwend, care management, mapping tools, cms, medical payment, P4P, database normalization, .
It includes a number of product enhancements such as industry leading performance analysis tools, platform robustness, improved tools for database normalization, and improved multi-modal support.
KERMIT (Knowledge-based Entity Relationship Modelling Intelligent Tutor) (Suraweera & Mitrovic, 2001) teaches conceptual database modelling, while NORMIT (NORMalization Intelligent Tutor) teaches database normalization (Mitrovic, 2003).
Database normalization is the process of refining a relational database schema to ensure that all tables are of high quality (Elmasri & Navathe, 1994).
Enhancements include performance analysis tools, platform robustness, improved multimodal support and tools for database normalization.
The technology required to break through these silos exists today, including account aggregation, database normalization, portfolio management/reporting and developments in delivery channel architecture.

Full browser ?