SQL SERVER – Rules of Third Normal Form and Normalization Advantage – 3NF

I always ask question about Third Normal Form in interviews I take.

Q. What is Third Normal Form and what is its advantage?
A. Third Normal Form (3NF) is most preferable normal form in RDBMS. Normalization is the process of designing a data model to efficiently store data in a database. The rules of 3NF are mentioned here

  • Make a separate table for each set of related attributes, and give each table a primary key.
  • If an attribute depends on only part of a multi-valued key, remove it to a separate table
  • If attributes do not contribute to a description of the key, remove them to a separate table.

Normalization is very close to concept of object oriented schema’s and it stores one data at only one place by removing all the redundant data. It also helps to draw the schema easier. Normalization comes at the cost of performance.

Reference : Pinal Dave (https://blog.sqlauthority.com) , DataModel.org.

Solarwinds

, ,
Previous Post
SQLAuthority News – SQL Server Compact 3.5 Downloads and ReportViewer Visual Studio Download
Next Post
SQL SERVER – 2005 – List All Stored Procedure in Database

Related Posts

29 Comments. Leave new

  • hi pinal sir

    I am new to this site and also i am a fresher..
    can u explaine me SP,trigers and Views with small example sir..
    pls do the needful

    Reply
  • Hi Pinal sir,
    your articles are great!, can you please explain with example If an attribute depends on only part of a multi-valued key, remove it to a separate table, what is multi-valued key means?
    Thanks.

    Reply
  • Hi Pinal,
    I am also New to Sql Sever But i am interesting go to database side .
    Basically I am developer I know the Syntax in Sqlserver .
    But Now i want know depth in sql server .
    what should i do please help me sir
    will give you any Reference liks or videos .

    Reply
  • thanks

    Reply
  • Thanks Pinal

    Reply

Leave a Reply

Menu