Forums » .NET » SQL Server »

What is the difference between first and second normalization form

Posted Date: 04 Aug 2010      Posted By:: sharmila Profile photo    Member Level: Gold  Member Rank: 0     Points: 1   Responses: 5

hai everyone,

both forms contain the same rule that to eliminate the repetions of group of data..why they are separating these into two forms..give me a example for that please..

thank u



#534839    Author: Paritosh Mohapatra      Member Level: Gold      Member Rank: 0     Date: 05/Aug/2010   Rating: 2 out of 52 out of 5     Points: 2


Please check the following link:

Thanks & Regards
Paritosh Mohapatra

Thanks & Regards
Paritosh Mohapatra
Microsoft MVP (ASP.Net/IIS)
DotNetSpider MVM

#534847    Author: Lalji      Member Level: Gold      Member Rank: 41     Date: 05/Aug/2010   Rating: 2 out of 52 out of 5     Points: 2

First Normal Form: doesnt contain the duplicate rows and null values.
2.those values can be moved into new table.

second normal form:
1.each columns are completely depend upon key

#534853    Author: manisha patel      Member Level: Silver      Member Rank: 0     Date: 05/Aug/2010   Rating: 2 out of 52 out of 5     Points: 2

go to this link.this will help you to understand 1Nf and 2NF with example.

thanks & regards
manisha patel

#534863    Author: krishnavenikaladi      Member Level: Gold      Member Rank: 0     Date: 05/Aug/2010   Rating: 2 out of 52 out of 5     Points: 2

1NF The values in the table should be atomic.
2NF The Non primary key values should depend on the primary key value.

enjoy coding.....
with regards

#535125    Author: Christopher F      Member Level: Gold      Member Rank: 48     Date: 05/Aug/2010   Rating: 2 out of 52 out of 5     Points: 2

What is Normalization, First Normal Form, Second Normal Form , Third Normal Form?

1.Normalization is process for assigning attributes to entities–Reducesdata redundancies–Helps eliminate data anomalies–Produces controlledredundancies to link tables

2.Normalization is the analysis offunctional dependency between attributes / data items of userviews?It reduces a complex user view to a set of small andstable subgroups of fields / relations

1NF:Repeating groups must beeliminated, Dependencies can be identified, All key attributesdefined,No repeating groups in table

2NF: The Table is already in1NF,Includes no partial dependencies–No attribute dependent on a portionof primary key, Still possible to exhibit transitivedependency,Attributes may be functionally dependent on non-keyattributes

3NF: The Table is already in 2NF, Contains no transitivedependencies

Post Reply     

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

  • Return to Discussion Forum
  • Start new thread

  • Subscribe to Subscribers
    Active Members
    TodayLast 7 Daysmore...

    Awards & Gifts
    Talk to Webmaster Tony John

    Online Members

    sridhar thota
    Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India