Learn SQL Programming from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

Database Normalization

Umasankar Natarajan
15/06/2017 0 0

Database Normalization is the process of reducing duplication in database by decomposing the table

1. Normal Form (1NF):

  • Every attribute is atomic, Each cell to be single valued
  • No multivalued attribute: Example subject  ( C, C++ )
  • No composite attribute: Example Address (392, XYZ street, Bangalore, 560001).  
  • Entries in a column are same type
  • Rows must be uniquely identified using UNIQUE ID or Add more column to make unique

2. Normal Form (2NF):
Table must not contain redundancy(Unnecessary repeating information).

3. Normal Form (3NF):
All fields can be determined only by Key in the table and not other column.

3.5. Normal Form - Boyce Codd Normal Form (BCNF):
Even when a database is in 3rd Normal Form, still there would be anomalies resulted if it has more than one Candidate Key. Table should not have multiple candidate key. Database should be only one primary key

4. 4NF (Fourth Normal Form):
Table instance contains two or more, independent and multivalued dependencies on Primary key

5. 5NF (Fifth Normal Form):
Table cannot be decomposed into any number of smaller tables without loss of data

0 Dislike
Follow 0

Please Enter a comment


Other Lessons for You

Handbook of websites for Website Developers/Designers (software professionals)
Know the trending languages(past & present) and their comparision with other languages: @ https://www.tiobe.com/tiobe-index/ Found an interesting website? identify the technologies used to build...

How to be a good developer?
I think practice more and read less.see what the logic in the programs then you must be a good developer

Virtual (Derived) Column: Oracle 11g R1 (Part 1)
VIRTUAL OR DERIVED COLUMN A nice feature introduced in Oracle 11gR1. Welcome to the practical analysis of various scenarios with virtual columns - introduced in 11gR1 are like normal table columns whose...

What Are Olap, Molap, Rolap, Dolap, Holap?
1. OLAP: On-Line Analytical Processing: Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal...

What is Big Data and Why Do Organizations Need It?
Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. But it’s not the amount of data that’s...

Looking for SQL Programming Classes?

The best tutors for SQL Programming Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn SQL Programming with the Best Tutors

The best Tutors for SQL Programming Classes are on UrbanPro

Book a Free Demo

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more