You must Sign In to post a response.
  • Category: SQL Server

    What is the difference between first and second normalization form

    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


    bye,
    sharmi
  • #534839
    Hi

    Please check the following link:

    http://wiki.answers.com/Q/What_is_difference_between_1St_NF_and_2Nd_NF

    Thanks & Regards
    Paritosh Mohapatra


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

  • #534847
    First Normal Form:
    1.it 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
    Hi
    go to this link.this will help you to understand 1Nf and 2NF with example.

    http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server/1481/1NF-2NF-normalization-question

    thanks & regards
    manisha patel

  • #534863
    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
    krishnavenikaladi

  • #535125
    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


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.