What are different Normal Forms in DBMS

1-NF:

A relation is said to be in 1-NF if and only if all the values in the relation are atomic and there are no multi valued attributes.

Note: According to CODD’s rule of RDBMS each and every relation shall exist in 1-NF minimum in Relational Database.

2-NF:

A relation is said to be in 2-NF if and only if:

Note: 2-NF eliminates all the partial dependencies hence all the dependencies caused by partial dependencies also gets eliminated.

3-NF:

A relation is said to be in 3-NF if and only if:

  1. It exists in 2-NF
  2. It does not have any Transitive dependencies.

Note: 3-NF eliminates both partial and transitive dependencies and hence the redundancies caused by them would get eliminated.

BCNF (Boyce Codd Normal Form):

A relation is said to be in BCNF if and only if:

  1. It exists in 3-NF.
  2. It does not have any Overlapping candidate key dependencies.

Hierarchy of Normal Forms:

NormalForms

One thought on “What are different Normal Forms in DBMS

Add yours

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: