top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

What is 1nf, 2nf and 3nf in oracle?

+1 vote

Please explain me the example for each. I am new to database..

posted Aug 10, 2014 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

NF means normal form

1NF: Rules are following
There are no columns with repeated or similar data
Each data item cannot be broken down any further.
Each row is unique i.e. it has a primary key
Each field has an unique name

2NF: Rules are following
The table must already be in first normal form
Non-key attributes must depend on every part of the primary key

3NF: Rules are following
The table must already be in second normal form
There are no non-key attributes that depend on another non-key attribute

answer Aug 11, 2014 by Salil Agrawal
Contact Us
+91 9880187415
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Karnataka INDIA.