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:03:45 2015
Return-Path:
X-Original-To: archive-at-mrbrklyn.com
Delivered-To: archive-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix)
id 58C4D16115E; Thu, 22 Jan 2015 20:03:45 -0500 (EST)
Delivered-To: learn-outgoing-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix, from userid 28)
id 49ADA161165; Thu, 22 Jan 2015 20:03:45 -0500 (EST)
Delivered-To: learn-at-mrbrklyn.com
Received: from mail-qa0-f50.google.com (mail-qa0-f50.google.com [209.85.216.50])
by mrbrklyn.com (Postfix) with ESMTP id 55887161162
for ; Thu, 22 Jan 2015 20:03:44 -0500 (EST)
Received: by mail-qa0-f50.google.com with SMTP id k15so3880752qaq.9
for ; Thu, 22 Jan 2015 17:03:44 -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=BVAtGR4QU//05+bM3U80RbkdCtyY71MVSb76Pk+IoiM=;
b=AajfWVOTJSVFUppp1dbg0JyNjgTHt2yx43280RPCgP87jW5Qi7Qdtqx/wzzg4CWhCJ
T/FLb0E14xEDueCq4Vop0wsvb+ArsHAxqScPuaa4dy+CfxfmUhc+b+RzXCzov5CzfKKn
qlASCcEZLmI5syd/fWbpAcKzejYRVyjjk/hd/fdK8WwoOEEyFE+/5GwDj73wlbqBTEJT
XRv6P9ZrPYYHgphAYiQxDz/rUiN8CpIM2v6ePMkCmUU3xaD45ow2lo2UrIXDlfnHbIEy
yOVO1CRZI1XQzzpo2SY9zc4vm2BTshTp4VwZAl4+w6pe4VvahTIzsW0hMSBEKomb+zX3
+zPg==
X-Received: by 10.140.22.233 with SMTP id 96mr8267592qgn.86.1421975023981;
Thu, 22 Jan 2015 17:03:43 -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 m74sm82988qgd.17.2015.01.22.17.03.42
for
(version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
Thu, 22 Jan 2015 17:03:42 -0800 (PST)
Date: Thu, 22 Jan 2015 17:03:42 -0800 (PST)
X-Google-Original-Date: Fri, 23 Jan 2015 01:03:41 GMT
MIME-Version: 1.0
X-Mailer: Nodemailer (0.5.0; +http://www.nodemailer.com/)
Message-Id: <1421975021725.c6fe91fe-at-Nodemailer>
In-Reply-To: <54C19D59.6000308-at-panix.com>
References: <54C19D59.6000308-at-panix.com>
X-Orchestra-Oid: 70391127-A2F6-4ED2-AFC5-759DD46FB4FD
X-Orchestra-Sig: ce0815fd47c33b55a7b26759708f2dfb1ea8698b
X-Orchestra-Thrid: T1C85947A-9D46-4890-8E99-A32EC983B6E6_1491048605420596872
X-Orchestra-Thrid-Sig: 0ce738fb3f06bf952ff8e9ed99dede27b469d1a8
X-Orchestra-Account: 1b2df77309e82054f712af7c7f6bd513d2457b47
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-1421975022859"
Sender: owner-learn-at-mrbrklyn.com
Precedence: bulk
Reply-To: learn-at-mrbrklyn.com
------Nodemailer-0.5.0-?=_1-1421975022859
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
We will use Java or python to build a project. We will decide next week =
what it will be. Something like a Twitter or another fun project=C2=A0
=E2=80=94
Sent from Mailbox
On Thu, Jan 22, 2015 at 8:01 PM, Ruben Safir wrote:
> On 01/22/2015 08:00 PM, Serge Glikstein wrote:
>> Just the project class, you=3F
> what is the project class=3F=20
>> =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 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-1421975022859
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
We will use Java or python to build a=
project. We will decide next week what it will be. Something like a =
Twitter or another fun project=C2=A0
On Thu, Jan 22, 2015 at 8:01 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>On 01/22/2015 =
08:00 PM, Serge Glikstein wrote:
> Just the project class, you=3F
what is the project class=3F=20
> =E2=80=94
> Sent from Mailbox
>
> On Thu, Jan 22, 2015 at 7:59 PM, Ruben Safir <mrbrklyn-at-panix.=
com> 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 =
<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-1421975022859--
|
|
