> A table in 2NF is free =
of Functional Dependencies and a table in 3NF is
> free of transitive deprecates along with functional dependencies.
> On Dec 18, 2014 11:56 AM, "Ruben Safir" <
o:mrbrklyn-at-panix.com">mrbrklyn-at-panix.com> wrote:
>
> > what exactly is the difference between the 2nd and 3rd NF
> >
> > Ruben
> >
> > On Thu, Dec 18, 2014 at 11:09:16AM -0500, Ruben Safir wrote:
> > > is a foriegn key a dependedncy for a relation with a seperae=
primary
> > > key?
> > >
> > >
> > >
> > > Like Course has a cno primary and a deptno foreign key.
> > >
> > >
> > > On Thu, Dec 18, 2014 at 10:50:31AM -0500, Sergei Glikstein w=
rote:
> > > > where is that?
> > > >
> > > > On Thu, Dec 18, 2014 at 10:45 AM, Ruben Safir <
ef=3D"mailto:mrbrklyn-at-panix.com">mrbrklyn-at-panix.com>
> > wrote:
> > > > >
> > > > > On Thu, Dec 18, 2014 at 10:39:29AM -0500, Sergei G=
likstein wrote:
> > > > > > i am in the library upstairs
> > > > > >
> > > > > > On Thu, Dec 18, 2014 at 10:34 AM, Ruben Safir=
<
mrbrklyn-at-panix.com>
> > > > > wrote:
> > > > > > >
> > > > > > > Anyone want to review normalization?
> > > > > > >
> > > > > > > Ruben
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > > why not come here so I can pick your brain without=
distractions and
> > with
> > > > > a network that functions.
> > > > >
> > > > > Everytime i go to that damn libvrary i waste my ti=
me
> > > > >
> > > > > Ruben
> > > > >
> > > > > BTW - you know IRC - xchat?
> > > > >
> > > > > Ruben
> > > > >
> > > > >
> >
