RDBMS-Normalisation

Page 1

1NF



1 NF

Relationship


2 NF



2 NF


Functional Dependency Relationship


3 NF



3 NF


Functional Dependency Transitive Dependency Relationship

BCNF

Functional Dependency Transitive Dependency



1 NF

2 NF

3 NF


Functional Dependency Transitive Dependency Normalized Relations


4 NF



4 NF

Multivalued Dependency Many-to-Many Relationship



5 NF



5 NF

Many-to-Many Relationship



Relation with Anomalies and Dependencies

Eliminate Repeating Groups

First Normal Form (1NF)

Eliminate Partial Functional Dependency

Second Normal Form (2NF)

Eliminate Transitive Dependency

Third Normal Form (3NF)

Eliminate Multivalued Dependency

Fourth Normal Form (4NF)

Eliminate Join Dependency

Fifth Normal Form (5NF)

Simple Normalized Relations without Anomalies and Dependencies


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.