Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> 1st and 2nd NF

1st and 2nd NF

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 4 Dec 2003 05:07:49 -0800
Message-ID: <1efdad5b.0312040507.1609473c@posting.google.com>


I have a college textbook and it discuss 3-6 NF and BCNF, but totally skips 1NF and 2NF. can someone help me in understanding this? I dont need it for school, I just want to know what it is.

BCNF
for every functional dependency X->A in F+ 1. X->A is trival or
2. X is a superkey X+_f=R

3NF
1. Its in BCNF or
2. X->A, such that A is part of some candidate key.

I would assume 2NF is

  1. Its in 3NF or... ????

1NF
1. Its in 2NF or.... ???? Received on Thu Dec 04 2003 - 07:07:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US