Solved

Need help understanding the second and third normal forms

Posted on 2008-10-22
3
479 Views
Last Modified: 2012-05-05
I have two questions.
(1.) Besides needing to satisfy the first normal form, is the second normal applicable only to enitities/tables that have compound primary keys? Or can it be applicable to a table with only one primary key?

(3) What is the third normal form? Is it basically saying that no Non Key attributes must not be dependent upon each other?

0
Comment
Question by:brgdotnet
  • 2
3 Comments
 
LVL 18

Assisted Solution

by:David Robitaille
David Robitaille earned 30 total points
ID: 22781072
1- It can it be applicable to a table with only one primary key, yes, it<s just remove the "duplicate", the street exemple is good, we got a database where the same street is not always spelled the same.
2 - (or 3) basicly it s that.
 
here some bonus links
http://databases.about.com/od/specificproducts/a/firstnormalform.htm
http://databases.about.com/od/specificproducts/a/2nf.htm
http://databases.about.com/od/specificproducts/a/3nf.htm 
0
 
LVL 22

Accepted Solution

by:
dportas earned 50 total points
ID: 22781277
(1) No. 2NF is a rule that can apply to any relation.
(2) ?
(3) Very loosely speaking you are right.

The most important normal forms are BCNF and 5NF. 2NF and 3NF are somewhat weaker rules about functional dependencies. Since they are subsumed by BCNF it's arguable that 2NF and 3NF are not very important. In fact what many people refer to as 3NF is really BCNF - the definitions are often confused.
0
 
LVL 18

Expert Comment

by:David Robitaille
ID: 22782180
I agree with dportas
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question