MESSAGE
| DATE | 2015-01-22 |
| FROM | From: "Serge Glikstein"
|
| SUBJECT | Re: [LIU Comp Sci] Normalization review
|
From owner-learn-outgoing-at-mrbrklyn.com Thu Jan 22 20:00:11 2015
Return-Path:
X-Original-To: archive-at-mrbrklyn.com
Delivered-To: archive-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix)
id D789A16115E; Thu, 22 Jan 2015 20:00:11 -0500 (EST)
Delivered-To: learn-outgoing-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix, from userid 28)
id C5AF9161165; Thu, 22 Jan 2015 20:00:11 -0500 (EST)
Delivered-To: learn-at-mrbrklyn.com
Received: from mail-qg0-f45.google.com (mail-qg0-f45.google.com [209.85.192.45])
by mrbrklyn.com (Postfix) with ESMTP id 2D89D16115E
for ; Thu, 22 Jan 2015 20:00:11 -0500 (EST)
Received: by mail-qg0-f45.google.com with SMTP id q107so4070942qgd.4
for ; Thu, 22 Jan 2015 17:00:10 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=20120113;
h=date:mime-version:message-id:in-reply-to:references:from:to:subject
:content-type;
bh=IFB6VOoErR0KTzqHmn4KDrrv9eeUrAQB4TzzTGkTfSw=;
b=JhWZLibN7MS0Adck9fWOGyStHUuNYwkh4vj9HuRGQ3ZLDyEd/FJEYkv8ZgzdZ5G6GC
+RWzpCzLIzWv7i1ZC+UNgXQARJ71T276KXnTsh7pIjc1HoUskaUCi9xK3Bk9MLys3S/B
rNy5vE4640izIuic5Hg2HXWokZChTXSVBWFn2lo3GqabjTFuniFtmhVRpBOYSuGa6/bF
2leiFlFixw3uibJX3tP9o46DKukqVaqRvxLnulpCmTb3mqPzEflUG/wCQLLJ6wPMX10u
JkfkOUye5tGWZXkvdicrmqCLJehyWEkYx36zl1hRBmXnrncvC7R7WJbdw7h8It/GxhOb
KIlA==
X-Received: by 10.224.120.130 with SMTP id d2mr2756693qar.81.1421974810632;
Thu, 22 Jan 2015 17:00:10 -0800 (PST)
Received: from hedwig-53.prd.orcali.com (ec2-54-85-253-117.compute-1.amazonaws.com. [54.85.253.117])
by mx.google.com with ESMTPSA id j6sm84233qga.9.2015.01.22.17.00.09
for
(version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
Thu, 22 Jan 2015 17:00:09 -0800 (PST)
Date: Thu, 22 Jan 2015 17:00:09 -0800 (PST)
X-Google-Original-Date: Fri, 23 Jan 2015 01:00:08 GMT
MIME-Version: 1.0
X-Mailer: Nodemailer (0.5.0; +http://www.nodemailer.com/)
Message-Id: <1421974808357.def359ae-at-Nodemailer>
In-Reply-To: <54C19CE4.9010106-at-panix.com>
References: <54C19CE4.9010106-at-panix.com>
X-Orchestra-Oid: C562D0BD-90A0-42EB-ADF8-BB6CB3A6D9C7
X-Orchestra-Sig: 064b36ad60a2450567a771e047eba690d34bc2fa
X-Orchestra-Thrid: T1C85947A-9D46-4890-8E99-A32EC983B6E6_1491048605420596872
X-Orchestra-Thrid-Sig: 0ce738fb3f06bf952ff8e9ed99dede27b469d1a8
X-Orchestra-Account: ef0d23f2f43685816013b326104c3659fa37bcce
From: "Serge Glikstein"
To: learn-at-mrbrklyn.com
Subject: Re: [LIU Comp Sci] Normalization review
Content-Type: multipart/alternative;
boundary="----Nodemailer-0.5.0-?=_1-1421974809434"
Sender: owner-learn-at-mrbrklyn.com
Precedence: bulk
Reply-To: learn-at-mrbrklyn.com
------Nodemailer-0.5.0-?=_1-1421974809434
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Just the project class, you=3F
=E2=80=94
Sent from Mailbox
On Thu, Jan 22, 2015 at 7:59 PM, Ruben Safir wrote:
> Sergei
> what are you taking this semester=3F
> On 12/18/2014 01:35 PM, Sergei Glikstein wrote:
>> http://psoug.org/reference/normalization.html
>>
>> 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, =22Ruben Safir=22 =
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=3F
>>>>>>
>>>>>>
>>>>>>
>>>>>> 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=3F
>>>>>>>
>>>>>>> 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=3F
>>>>>>>>>>
>>>>>>>>>> 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=3F
>>>>>>>>
>>>>>>>> Ruben
>>>>>>>>
>>>>>>>>
------Nodemailer-0.5.0-?=_1-1421974809434
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Just the project class, =
you=3F
On Thu, Jan 22, 2015 at 7:59 PM=
, Ruben Safir <com=22 target=3D=22=5Fblank=22>mrbrklyn-at-panix.com> =
wrote:
0 .8ex;border-left:1px #ccc solid;padding-left:1ex;=22>Sergei
what are you taking this semester=3F
On 12/18/2014 01:35 PM, Sergei Glikstein wrote:
> http://psoug.org/reference/normalization.html
>
> On Thu, Dec 18, 2014 at 1:08 PM, Ruben Safir <mrbrklyn-at-panix.=
com> 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, =22Ruben Safir=22 =
<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=3F
>>>>>
>>>>>
>>>>>
>>>>> 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=3F
>>>>>>
>>>>>> On Thu, Dec 18, 2014 at 10:45 AM, Ruben Safir =
<mrbrklyn-at-panix.com>
>>>> 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=3F
>>>>>>>>>
>>>>>>>>> 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=3F
>>>>>>>
>>>>>>> Ruben
>>>>>>>
>>>>>>>
------Nodemailer-0.5.0-?=_1-1421974809434--
|
|
