MBN News | The Independent Business Blogging Community

MBN News: Business Intelligence | Databases | BigData

MBN International: English Flag Bulgarian Flag

29 Members | ~1,500 Unique Visitors with ~3,500 Visits Last Month | Last Update: 27 Apr 2017 | Google PageRank 5 (PR5)

MBN Most Popular

MBN Latest

Now Blogging » Business Intelligence (BI)

Business Intelligence Dictionary: Database Normalization And Normal Forms | NSBI

<a href='http://morningbiznews.com/en/search/Boyce'>Boyce</a>, <a href='http://morningbiznews.com/en/search/Codd'>Codd</a>, <a href='http://morningbiznews.com/en/search/normalization'>normalization</a>, <a href='http://morningbiznews.com/en/search/normal+form'>normal form</a>, <a href='http://morningbiznews.com/en/search/primary+key'>primary key</a>, <a href='http://morningbiznews.com/en/search/foreign+key'>foreign key</a>, <a href='http://morningbiznews.com/en/search/nsbi-dict'>nsbi-dict</a>

Optimization has always been a priority for business and database optimization is not an exclusion. Relational Database optimization is often related to a process called Normalization.

Normalization | Definition

Normalization is a process of optimization of a relational database in terms of data redundancy by partitioning data in different tables and applying relationships between them. This is achieved by correct assignment of primary keys and foreign keys across the fields.

The extent of normalization is also described by the so called Boyce-Codd Normal Forms.

NSBI Tutorials aim to make Business Intelligence (BI) and Data Warehousing (DWH) attractive to non-technical people as well as to those who are now entering the field and are excited by the numerous ways data is changing our world. NSBI Tutorials are written and delivered by Nick Shopov, (BI Software Developer & DWH Consultant).

Boyce-Codd Normal Form 1 | Definition & Example

Rule says: Each field is atomic, it cannot be further broken into smaller entities.


Atomic Normal Form 1

Boyce-Codd Normal Form 2 | Definition & Example

Rule says: Each field is fully and uniquely identified by a Primary Key.

Example: "National ID" uniquely identifies John as a person, so this field should be the table Primary Key.

Boyce-Codd Normal Form 3 | Definition & Example

Rule says: Primary Key is not uniquely identified by any non Primary Key field.

Example: You cannot determine John's National ID by knowing his Name and Birth Place. There are many with this name born in Texas.

Normal Form 3 is the most widely used one. Normal Forms 4 and 5 are seldom achieved, so an example will be out of scope for them.

Boyce-Codd Normal Form 4 | Definition

Rule says: Each multi-value dependency is identified by a Primary key.

Boyce-Codd Normal Form 5 | Definition

Rule says: Each join is implied by the Primary Key.

See a sample visualization of a normalized relational schema:

Normalization Schema

Image Coutesy: www.nationalvetcontent.edu.au