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

Author: Paritosh Mohapatra05 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

Author: Lalji05 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

Author: manisha patel05 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

Author: krishnavenikaladi05 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.


Author: Christopher F05 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