What is Normalization?

Discussion in 'Programming' started by exe download, Apr 18, 2011.

0
  1. #1
    Please give the solution to my problem.
    Thank you.
     
    exe download, Apr 18, 2011 IP
  2. ama

    ama Greenhorn

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #2
    It's a standard way of designing databases.
     
    ama, Apr 18, 2011 IP
  3. EyreWales

    EyreWales Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Normalization is one of the best data formation of the Database.When we talk about the Database



    Management system then fist the Normalization forms comes.



    Normalization is basically the process of simplyfying the data or can say it reduces the redundancy of



    of the data.Normalization is the process of make the database tables but in the sensible manner.



    Normalization contains 6 Normal Forms but basically we shares the only 4 normal forms.



    1) First Normal Form



    First Normal Formal Form Consists very basic set of rules like



    a) Database Tables Should not be duplicate.

    b) Create Separate Tables and set the identity of the row and can set the unique id also.





    2) Second Normal Form



    It is also used for remove the redundancy basically.



    a) Second normal form takes all the parameters of first normal form as well as something new also.

    b) we can create relation between 2 tables .





    3) Third Normal Form



    It contains all the parameters of second normal form.



    a) we should remove the fields that are not dependent on the primary key.



    4) Fourth Normal Form



    This is also known as Boyce Code Normal Form.In these normal forms or further normal forms data should be

    be seperated into so many tables and there should not be complexity in the tables.
     
    EyreWales, Apr 19, 2011 IP