Forums » .NET » SQL Server »

What is the difference between first and second normalization form


Posted Date: 04 Aug 2010      Posted By:: sharmila Profile photo    Member Level: Gold    Member Rank: 497     Points: 1   Responses: 5



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




Responses

#534839    Author: Paritosh Mohapatra      Member Level: Gold      Member Rank: 9     Date: 05/Aug/2010   Rating: 2 out of 52 out of 5     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      Member Level: Gold      Member Rank: 128     Date: 05/Aug/2010   Rating: 2 out of 52 out of 5     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      Member Level: Silver      Member Rank: 1564     Date: 05/Aug/2010   Rating: 2 out of 52 out of 5     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      Member Level: Gold      Member Rank: 232     Date: 05/Aug/2010   Rating: 2 out of 52 out of 5     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      Member Level: Gold      Member Rank: 169     Date: 05/Aug/2010   Rating: 2 out of 52 out of 5     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


 
Post Reply

 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.



Return to Discussion Forum
Start new thread

Subscribe to Subscribers
Active Members
TodayLast 7 Daysmore...

Awards & Gifts
Talk to Webmaster Tony John

Online Members

More...
Copyright © SpiderWorks Technologies Pvt Ltd., Kochi, India