MESSAGE
| DATE | 2014-12-18 |
| FROM | Ruben Safir
|
| SUBJECT | Re: [LIU Comp Sci] Normalization review
|
From owner-learn-outgoing-at-mrbrklyn.com Thu Dec 18 13:50:41 2014
Return-Path:
X-Original-To: archive-at-mrbrklyn.com
Delivered-To: archive-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix)
id 9D50C161167; Thu, 18 Dec 2014 13:50:41 -0500 (EST)
Delivered-To: learn-outgoing-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix, from userid 28)
id 86BF5161169; Thu, 18 Dec 2014 13:50:41 -0500 (EST)
Delivered-To: learn-at-mrbrklyn.com
Received: from mailbackend.panix.com (mailbackend.panix.com [166.84.1.89])
by mrbrklyn.com (Postfix) with ESMTP id 74336161167
for ; Thu, 18 Dec 2014 13:50:40 -0500 (EST)
Received: from panix2.panix.com (panix2.panix.com [166.84.1.2])
by mailbackend.panix.com (Postfix) with ESMTP id 2DA9C1354C
for ; Thu, 18 Dec 2014 13:50:40 -0500 (EST)
Received: by panix2.panix.com (Postfix, from userid 20529)
id 17E5333C87; Thu, 18 Dec 2014 13:50:40 -0500 (EST)
Date: Thu, 18 Dec 2014 13:50:40 -0500
From: Ruben Safir
To: learn-at-mrbrklyn.com
Subject: Re: [LIU Comp Sci] Normalization review
Message-ID: <20141218185039.GA17797-at-panix.com>
References: <20141218153424.GA4242-at-panix.com>
<20141218154519.GC4242-at-panix.com>
<20141218160916.GA14854-at-panix.com>
<20141218165609.GA3184-at-panix.com>
<20141218180801.GB5809-at-panix.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To:
User-Agent: Mutt/1.5.23 (2014-03-12)
Sender: owner-learn-at-mrbrklyn.com
Precedence: bulk
Reply-To: learn-at-mrbrklyn.com
On Thu, Dec 18, 2014 at 01:35:42PM -0500, Sergei Glikstein wrote:
> http://psoug.org/reference/normalization.html
very good. Now I just need to disect it. Where did you get that from?
>
> On Thu, Dec 18, 2014 at 1:08 PM, Ruben Safir wrote:
> >
> > Do you have HIS definition for BCNF because if I recall, he said it was
> > exclusive to himself since it is defined in different places
> > differently.
> >
> >
> >
> > On Thu, Dec 18, 2014 at 11:59:18AM -0500, maneeshkongara wrote:
> > > 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" 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 wrote:
> > > > > > where is that?
> > > > > >
> > > > > > On Thu, Dec 18, 2014 at 10:45 AM, Ruben Safir
> > > > wrote:
> > > > > > >
> > > > > > > On Thu, Dec 18, 2014 at 10:39:29AM -0500, Sergei Glikstein 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 time
> > > > > > >
> > > > > > > Ruben
> > > > > > >
> > > > > > > BTW - you know IRC - xchat?
> > > > > > >
> > > > > > > Ruben
> > > > > > >
> > > > > > >
> > > >
> >
|
|
