which of the following normal forms meet the sql server table requirement?

Posted by Rajesh123 under Sql Server on 8/28/2015 | Points: 10 | Views : 1567 | Status : [Member] | Replies : 7

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

which of the following normal forms meet the sql server table requirement below?
-no repeating and multivalued attributes
-no attributes that are not dependent on the whole primary key
-no attribute that depend on other non-key attributes.

A)2nd NORMAL FORM
B)DOMAIN KEY NORMAL FORM
C)1st NORMAL FORM
D)3rd NORMAL FORM
E)5tH NORMAL FORM

Rply ASAP friends

rajesh.plsql123@gmail.com

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Bandi on: 8/28/2015 [Member] [MVP] Platinum | Points: 25

0	Third Normal Form... Go through this link https://sites.google.com/site/merasemester/dbm/normalization Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Rajesh123, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Rajesh123 on: 8/28/2015 [Member] Starter | Points: 25

0	Hi bandi your link is not open. any way thanks for your responce rajesh.plsql123@gmail.com Rajesh123, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Bandi on: 8/28/2015 [Member] [MVP] Platinum | Points: 25

0	copy sites.google.com/site/merasemester/dbm/normalization and paste it in browser address bar.... Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif Rajesh123, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Rajesh123 on: 8/28/2015 [Member] Starter | Points: 25

0	k thank u rajesh.plsql123@gmail.com Rajesh123, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Shreedar on: 8/30/2015 [Member] Starter | Points: 25

0	Hi The first line " no repeating and multivalued attributes" is the rule of first normal form. There should not be any column that is not fully dependent on primary key. This is the rule of Third Normal Form. How ever for a table to be in third normal form, it should aslo be in first and second normal form as well. Regards Sridhar Thota. www.dotnet-sridhar.blogspot.com Rajesh123, if this helps please login to Mark As Answer. \| Alert Moderator

Hi

The first line " no repeating and multivalued attributes" is the rule of first normal form.
There should not be any column that is not fully dependent on primary key. This is the rule of Third Normal Form.
How ever for a table to be in third normal form, it should aslo be in first and second normal form as well.

Regards

Sridhar Thota.
www.dotnet-sridhar.blogspot.com

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

Posted by: Manub22 on: 9/22/2015 [Member] Starter | Points: 25

0	It's in 3rd NF. -no repeating and multivalued attributes : 1st NF -no attributes that are not dependent on the whole primary key : 2nd NF -no attribute that depend on other non-key attributes. 3rd NF Check here all 3 normal form details: http://sqlwithmanoj.com/2009/03/25/database-normalization/ Rajesh123, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Rajnilari2015 on: 9/25/2015 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 25

0	It is in 3NF -- Thanks & Regards, RNA Team Rajesh123, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts