If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Nornalization and Functional dependancy

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-24-08, 10:33
Pearl_89 Pearl_89 is offline
Registered User
 
Join Date: Sep 2008
Posts: 24
Nornalization and Functional dependancy

What is the difference between 1NF ,2NF,and 3NF?? can someone explain with examples??

and what about the partial dependency and the transative dependency?? what are the difference?
Thank you
Reply With Quote
  #2 (permalink)  
Old 09-24-08, 10:52
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
What kind of class are you taking? Like many fields, the teacher will (and should) expect different answers from a survey-class student, a student that is focused on a technology (if it is part of their major), and a professional. The answers that you get here will probably be professional, so they won't be suitable for handing in as though you'd written them yourself.

-PatP
Reply With Quote
  #3 (permalink)  
Old 09-24-08, 11:31
Pearl_89 Pearl_89 is offline
Registered User
 
Join Date: Sep 2008
Posts: 24
The course that am taking is DATABASE MANAGEMENT SYSTEM
Reply With Quote
  #4 (permalink)  
Old 09-24-08, 12:01
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
does that course not recommend any textbooks that you should read?

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #5 (permalink)  
Old 09-24-08, 12:14
Pearl_89 Pearl_89 is offline
Registered User
 
Join Date: Sep 2008
Posts: 24
Ofcourse it does!!
If I understood it then I wouldnt be asking for help....
Reply With Quote
  #6 (permalink)  
Old 09-24-08, 12:37
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
do you mind if i ask which textbook it is?

also, have you tried googling? there are hunnerts of web sites that explain 1NF, 2NF, 3NF...
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #7 (permalink)  
Old 09-24-08, 13:34
Pearl_89 Pearl_89 is offline
Registered User
 
Join Date: Sep 2008
Posts: 24
The book that we are using is called Database Systems Design,Implementation,And Management
Seventh Edition
Peter Rob , Carlos Coronel
Reply With Quote
  #8 (permalink)  
Old 09-24-08, 14:54
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
Try looking at the Wikipedia for understanding normalization concepts.

-PatP
Reply With Quote
  #9 (permalink)  
Old 09-24-08, 16:25
gvee gvee is offline
www.gvee.co.uk
 
Join Date: Jan 2007
Location: UK
Posts: 10,156
Even wikipedia gives you a decent start... But you're not allowed to cite wikipedia any more are you?

EDIT: I really should have refreshed the page before responding, eh ;-)
__________________
George
Twitter | Blog
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On