Scribd
Upload
13 views1 page

Database Normalization Explained

The document summarizes the different normal forms in database normalization including 0NF, 1NF, 2NF, and 3NF. 0NF has redundant data, non-atomic fields, and no primary key. 1NF removes redundancy and makes fields atomic with a primary key. 2NF removes partial dependencies by splitting tables. 3NF further links tables with primary and foreign keys.

Uploaded by

Billie stan for life
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
13 views1 page

Database Normalization Explained

The document summarizes the different normal forms in database normalization including 0NF, 1NF, 2NF, and 3NF. 0NF has redundant data, non-atomic fields, and no primary key. 1NF removes redundancy and makes fields atomic with a primary key. 2NF removes partial dependencies by splitting tables. 3NF further links tables with primary and foreign keys.

Uploaded by

Billie stan for life
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

NORMALISATION SUMMARY

UNNORMALISED FORM (0NF):-

• Repeated data entries and fields (redundant data)


• Data is no atomic (ex: employee name -Kaila Bennett is non atomic, it
will be separated into first name and last name Kaila in a field and
Bennett in another field in order to become atomic)
• Table has no primary key
• Data is inconsistent

1ST NORMAL FORM (1NF):-


• Data is atomic
• No repeated fields/ records
• Table has a primary key

2nd NORMAL FORM (2NF):-


• 1ST normal form is done
• No partial dependencies (if data does not depend on the primary key it
will be removed from the table)
• Many tables will be formed and each one has a its own primary key

3rd NORMAL FORM (3NF):-

• 2ND Normal form is done


• Tables will be linked and relationships formed (primary keys and foreign
keys)

You might also like