What is second normal form in sql server [Resolved]

Posted by Jitendrasoft09 under Sql Server on 6/26/2013 | Points: 10 | Views : 1271 | Status : [Member] [MVP] | Replies : 3
Hi All,
I want to understand What is second normal form in sql server, let me know if anybody knows

Jitendra Kumar
If my post helps you, plz mark as an answer.



Responses

Posted by: Satyapriyanayak on: 6/27/2013 [Member] [MVP] Silver | Points: 50

Up
0
Down

Resolved
Second normal form states that it should meet all the rules for 1NF and there must be no partial dependences of any of the columns on the primary key:

http://www.tutorialspoint.com/sql/second-normal-form.htm

If this post helps you mark it as answer
Thanks

Jitendrasoft09, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Niladri.Biswas on: 6/26/2013 [Member] Platinum | Points: 25

Up
0
Down
In order to be in Second Normal Form, a relation must first fulfill the requirements to be in First Normal Form. Additionally, each nonkey attribute in the relation must be functionally dependent upon the primary key.

Source: http://databases.about.com/od/administration/l/bldef_2nf.htm

Best Regards,
Niladri Biswas

Jitendrasoft09, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jitendrasoft09 on: 6/27/2013 [Member] [MVP] Starter | Points: 25

Up
0
Down
Good effort Niladri, nice explanation, Thanks Satya...

Jitendra Kumar
If my post helps you, plz mark as an answer.

Jitendrasoft09, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response