MESSAGE
| DATE | 2014-12-18 |
| FROM | maneeshkongara
|
| SUBJECT | Re: [LIU Comp Sci] Normalization review
|
From owner-learn-outgoing-at-mrbrklyn.com Thu Dec 18 11:59:19 2014
Return-Path:
X-Original-To: archive-at-mrbrklyn.com
Delivered-To: archive-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix)
id A7F7E161167; Thu, 18 Dec 2014 11:59:19 -0500 (EST)
Delivered-To: learn-outgoing-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix, from userid 28)
id 9134E161169; Thu, 18 Dec 2014 11:59:19 -0500 (EST)
Delivered-To: learn-at-mrbrklyn.com
Received: from mail-qg0-f48.google.com (mail-qg0-f48.google.com [209.85.192.48])
by mrbrklyn.com (Postfix) with ESMTP id AD880161167
for ; Thu, 18 Dec 2014 11:59:18 -0500 (EST)
Received: by mail-qg0-f48.google.com with SMTP id f51so1130529qge.7
for ; Thu, 18 Dec 2014 08:59:18 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=20120113;
h=mime-version:in-reply-to:references:date:message-id:subject:from:to
:content-type;
bh=WOQauznrYphvLyUjikENN117xK972xsZacrRAmfebRI=;
b=bnFzHtEO5ScGsaSS9CLjL8e9yN9qC/0zLxjRE2Jjpy8YGc2pBML/O9Cs1UOO9I/PXE
u6n+qCc8SRxjtGP6C8+1kO/jDspXtOMw9hNDZioFZqHgZA91XNFa0t509qijd12sYnH2
r0jxX8zl3lUwa01ZL/eDKyTMo3FksBjnbY1qgWJb0KtlArwIsHl9ZSrYL8V3wkKes5Er
g9a5f/4wSrmCMbimt0g2QWtUzD4HuPjq9zJH9Tu5/xFCXcXv1gk/7Ilqm1kSNvNbSFq7
VlllFmj/YH993PI3CQ9Hgs1wpKo9Ha6RV+vYePsJGTm1yD2JFmu6UQ87c67nndeKK7cD
858g==
MIME-Version: 1.0
X-Received: by 10.224.51.68 with SMTP id c4mr5631539qag.26.1418921958252; Thu,
18 Dec 2014 08:59:18 -0800 (PST)
Received: by 10.229.157.204 with HTTP; Thu, 18 Dec 2014 08:59:18 -0800 (PST)
Received: by 10.229.157.204 with HTTP; Thu, 18 Dec 2014 08:59:18 -0800 (PST)
In-Reply-To: <20141218165609.GA3184-at-panix.com>
References: <20141218153424.GA4242-at-panix.com>
<20141218154519.GC4242-at-panix.com>
<20141218160916.GA14854-at-panix.com>
<20141218165609.GA3184-at-panix.com>
Date: Thu, 18 Dec 2014 11:59:18 -0500
Message-ID:
Subject: Re: [LIU Comp Sci] Normalization review
From: maneeshkongara
To: learn-at-mrbrklyn.com
Content-Type: multipart/alternative; boundary=089e0160ba6c4923f9050a808310
Sender: owner-learn-at-mrbrklyn.com
Precedence: bulk
Reply-To: learn-at-mrbrklyn.com
--089e0160ba6c4923f9050a808310
Content-Type: text/plain; charset=UTF-8
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
> > > > 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
> > > >
> > > >
>
--089e0160ba6c4923f9050a808310
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
A table in 2NF is free of Functional Dependencies and a tabl=
e in 3NF is free of transitive deprecates along with functional dependencie=
s.
On Dec 18, 2014 11:56 AM, "Ruben Safir"= ; < mrbrklyn-at-panix.com> wrot= e: n:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">what exactly is t=
he 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 primaryr>
> 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 <to:mrbrklyn-at-panix.com">mrbrklyn-at-panix.com> wrote:
> > >
> > > On Thu, Dec 18, 2014 at 10:39:29AM -0500, Sergei Glikstein w=
rote:
> > > > i am in the library upstairs
> > > >
> > > > On Thu, Dec 18, 2014 at 10:34 AM, Ruben Safir <ef=3D"mailto:mrbrklyn-at-panix.com">mrbrklyn-at-panix.com>
> > > wrote:
> > > > >
> > > > > Anyone want to review normalization?
> > > > >
> > > > > Ruben
> > > > >
> > > > >
> > >
> > >
> > > why not come here so I can pick your brain without distracti=
ons and with
> > > a network that functions.
> > >
> > > Everytime i go to that damn libvrary i waste my time
> > >
> > > Ruben
> > >
> > > BTW - you know IRC - xchat?
> > >
> > > Ruben
> > >
> > >
--089e0160ba6c4923f9050a808310--
|
|
