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 12:09:06 2014
Return-Path:
X-Original-To: archive-at-mrbrklyn.com
Delivered-To: archive-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix)
id 04220161167; Thu, 18 Dec 2014 12:09:06 -0500 (EST)
Delivered-To: learn-outgoing-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix, from userid 28)
id E1A0F161169; Thu, 18 Dec 2014 12:09:05 -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 08F33161168
for ; Thu, 18 Dec 2014 12:09:05 -0500 (EST)
Received: from panix2.panix.com (panix2.panix.com [166.84.1.2])
by mailbackend.panix.com (Postfix) with ESMTP id CD91413465
for ; Thu, 18 Dec 2014 12:09:04 -0500 (EST)
Received: by panix2.panix.com (Postfix, from userid 20529)
id B7B2D33C87; Thu, 18 Dec 2014 12:09:04 -0500 (EST)
Date: Thu, 18 Dec 2014 12:09:04 -0500
From: Ruben Safir
To: learn-at-mrbrklyn.com
Subject: Re: [LIU Comp Sci] Normalization review
Message-ID: <20141218170904.GB3184-at-panix.com>
References: <20141218153424.GA4242-at-panix.com>
<20141218154519.GC4242-at-panix.com>
<20141218160916.GA14854-at-panix.com>
<20141218165609.GA3184-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 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:
>
if you do a NF2 aren't you automatically ok for a NF3? If not why not?
Ruben
> > 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
> > > > > 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
> > > > >
> > > > >
> >
|
|
