You must Sign In to post a response.

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


Comments

#534839    Author: Paritosh Mohapatra    05 Aug 2010 Member Level: Gold   Points : 2

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    Author: Lalji    05 Aug 2010 Member Level: Gold   Points : 2

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    Author: manisha patel    05 Aug 2010 Member Level: Silver   Points : 2

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    Author: krishnavenikaladi  05 Aug 2010 Member Level: Gold   Points : 2

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    Author: Christopher F    05 Aug 2010 Member Level: Gold   Points : 2

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.