Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Normalization

    • 0
    • 2
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 262
    Comment on it

    Database Normalization

    Normalization is a technique of managing records in a database. It is an approach to eliminate data redundancy and anamolies . It also removes data duplicacy in a record. It helps in data update,delete and insert anamolies.Without normalisation,it becomes tough to handle database records.I illustrate an example to show how anamolies exists in a record or database.

    Emp_id        Emp_Name         Emp_City        Emp_Specialisation
    
     1011        Akshat garg       Mumbai          C++
    
     1012        Akhil Semwal      Pune           JAVA
    
     1013        Suzan Arora       Pune           C++
    
     1014       Shruti gupta       Nanital        PHP
    

    There are three types of anamolies in a record.

    Update Anamoly : data will become inconsistent,if there exist two or more type of similar data in a record.

    Insert Anamoly : If we do vacant a data of a person or employee or any other kind of record, yet then also we have to insert NULL on that empty place of a respective record.

    Delete Anamoly : If primary key of a record does not contains any data temporarily,so if we delete that row ,the whole record of database shall be deleted.

    Normalization Forms.
    There are several types of normalizations.

    1. First Normal Form 
    2. Second Normal Form 
    3. Third Normal Form 
    4. BCNF (Boyce and Codd  Normal Form)
    5. Fourth Normal Form
    6. Fifth Normal Form
    

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: