MESSAGE
| DATE | 2014-12-18 |
| FROM | Sergei Glikstein
|
| SUBJECT | Re: [LIU Comp Sci] Normalization review
|
From owner-learn-outgoing-at-mrbrklyn.com Thu Dec 18 22:20:57 2014
Return-Path:
X-Original-To: archive-at-mrbrklyn.com
Delivered-To: archive-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix)
id 28B8A161167; Thu, 18 Dec 2014 22:20:57 -0500 (EST)
Delivered-To: learn-outgoing-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix, from userid 28)
id 15CDA161169; Thu, 18 Dec 2014 22:20:56 -0500 (EST)
Delivered-To: learn-at-mrbrklyn.com
Received: from mail-lb0-f169.google.com (mail-lb0-f169.google.com [209.85.217.169])
by mrbrklyn.com (Postfix) with ESMTP id 6BC95161167
for ; Thu, 18 Dec 2014 22:20:55 -0500 (EST)
Received: by mail-lb0-f169.google.com with SMTP id p9so144356lbv.28
for ; Thu, 18 Dec 2014 19:20:54 -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=tTk9SW2kWTHaSuGLd8ExNkPaE1hR34oSODbYUXUOkCA=;
b=inxhRiJQanCB6OC+Sb21ZXAkTDxl7/jzDeyGCOI0rxgoy6zpLgeDC7OGTxaceJYetV
lHCnyVadzdVC6fVU8buCZdX0cksO54iwriIXYZ7Nw8AjKVlhsJIBXhT+/F/dOg3y9L93
gqVGcKEx/SQAUL6q5B0JZjGgpCtKfduvqLcrMv4nyIEy0/+W1IU4HUp/ONHwo82Pknae
iWXLHDH4dbgo8iY/QdJO1FVNR8RUCnodRQScRDXwGFWA4sEgQDWz2KAdaEoWEQ5c2fiJ
6wr8WCTNS1wFCvtE+Cx2aJFzCDhx7ybs+lrZfwMEzHKpyQobIa2muJr5foKAXVWHU1Iu
fYCw==
MIME-Version: 1.0
X-Received: by 10.152.238.1 with SMTP id vg1mr5510536lac.83.1418959254052;
Thu, 18 Dec 2014 19:20:54 -0800 (PST)
Received: by 10.25.28.132 with HTTP; Thu, 18 Dec 2014 19:20:53 -0800 (PST)
In-Reply-To: <20141219032028.4F211161169-at-mrbrklyn.com>
References:
<20141219032028.4F211161169-at-mrbrklyn.com>
Date: Thu, 18 Dec 2014 19:20:53 -0800
Message-ID:
Subject: Re: [LIU Comp Sci] Normalization review
From: Sergei Glikstein
To: learn-at-mrbrklyn.com
Content-Type: multipart/alternative; boundary=001a1134930e49eab1050a893221
Sender: owner-learn-at-mrbrklyn.com
Precedence: bulk
Reply-To: learn-at-mrbrklyn.com
--001a1134930e49eab1050a893221
Content-Type: text/plain; charset=UTF-8
horrible! you?
On Thu, Dec 18, 2014 at 7:20 PM, wrote:
>
> How'd you do
>
>
>
> -- Sent from my HP TouchPad
> ------------------------------
> On Dec 18, 2014 1: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, "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
>> > > > > >
>> > > > > >
>> > >
>>
>
--001a1134930e49eab1050a893221
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
ra"> On Thu, Dec 18, 2014 at 7:20 PM, dir=3D"ltr"><mrb=
rklyn-at-panix.com> wrote: e=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">How'=
;d you do
=
color:#999999">-- Sent from my HP TouchPad :navy;font-family:Prelude,Verdana,san-serif">
dth:75%">
--001a1134930e49eab1050a893221--
|
|
