Welcome to WebmasterServe!

FREE TO JOIN! Join us now to engage in informative and friendly discussions about Webmastering, SEO, SEM, Internet Marketing, Programming, Graphic Design, Online Jobs and more. What are you waiting for? Ready to join our friendly community? It takes just one minute to register.

Dismiss Notice

Join WebmasterServe Forums 
Join the discussion! Have a better idea or an opinion? It takes just one minute to register Click Here to Join

Help Me/Question What Is The Need Of Normalization In Rdbms?

Discussion in 'Database Management' started by steve taylor, Feb 17, 2016.

  1. steve taylor

    Yellow Belt

    Joined:
    Feb 12, 2016
    Messages:
    769
    Ratings:
    +25 / -0
    Relational data base management system organize the data in the form row and columns . I have a data of college student and I want to manage a table . There are all attributes of the table are as follows :-
    student name.
    Roll number.(unique)
    Date of Birth.
    Phone number (May have more than one mobile number)
    Which normal form is suitable for above relation.
     
  2. krishatg

    Yellow Belt

    Joined:
    Jan 16, 2016
    Messages:
    240
    Ratings:
    +14 / -0
    Above database is normal one can be maintained in 1st normalization form also. Normalization is required where dependency,redundancy of data is occurring because of using single table for whole data. I most of the situations for such data we prefer to acquire 3rd normalization form.
     
  3. VIVEK KUMAR

    Yellow Belt

    Joined:
    Mar 8, 2016
    Messages:
    300
    Ratings:
    +2 / -0
    Normalization reduce the redundancy . Suppose we maintain student a database in this database. student table contain more than one record for student A. In this condition it is very difficult to retrieve the data according to key because there are no unique value in any field. To resolve these type of problem we are going to database normalization.
     
  4. Pooja Sharma

    Yellow Belt

    Joined:
    Feb 5, 2016
    Messages:
    373
    Ratings:
    +20 / -0
    Normalization in RDBMS is used to increase the normality of the data by removing the redundancy in data. Redundancy comes while entering same data more than once during data insertion. There are many stages of Normalization process..:
    1. 1NF
    2. 2NF
    3. 3NF
    4. BC NF
    5. 5NF...etc..

    Raw data is normalized in all forms.
     
  5. Swati Mishra

    Yellow Belt

    Joined:
    Dec 28, 2015
    Messages:
    644
    Ratings:
    +105 / -0
    normalization is the technique to organize the data in database, it use for eliminating redundant data. and the data is logically stored.
     
  6. saurabh mathur

    Yellow Belt

    Joined:
    Nov 8, 2017
    Messages:
    130
    Ratings:
    +2 / -0
    We need to ensure that all the data structures are able to be implemented in relational database.It is required for organizing the content of tables for transnational databases and data warehouses. It is the part of successful database design without normalization or database system should be inaccurate.

    web hosting
     

Share This Page