MESSAGE
| DATE | 2015-01-22 |
| FROM | Ruben Safir
|
| SUBJECT | Re: [LIU Comp Sci] Normalization review
|
From owner-learn-outgoing-at-mrbrklyn.com Thu Jan 22 19:59:18 2015
Return-Path:
X-Original-To: archive-at-mrbrklyn.com
Delivered-To: archive-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix)
id 0AA9016115E; Thu, 22 Jan 2015 19:59:18 -0500 (EST)
Delivered-To: learn-outgoing-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix, from userid 28)
id EF4E5161165; Thu, 22 Jan 2015 19:59:17 -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 8C9BF16115E
for ; Thu, 22 Jan 2015 19:59:17 -0500 (EST)
Received: from [10.0.0.19] (unknown [96.57.23.82])
by mailbackend.panix.com (Postfix) with ESMTPSA id 5DAAB19A00
for ; Thu, 22 Jan 2015 19:59:17 -0500 (EST)
Message-ID: <54C19CE4.9010106-at-panix.com>
Date: Thu, 22 Jan 2015 19:59:16 -0500
From: Ruben Safir
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.3.0
MIME-Version: 1.0
To: learn-at-mrbrklyn.com
Subject: Re: [LIU Comp Sci] Normalization review
References: <20141218153424.GA4242-at-panix.com> <20141218154519.GC4242-at-panix.com> <20141218160916.GA14854-at-panix.com> <20141218165609.GA3184-at-panix.com> <20141218180801.GB5809-at-panix.com>
In-Reply-To:
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Sender: owner-learn-at-mrbrklyn.com
Precedence: bulk
Reply-To: learn-at-mrbrklyn.com
Sergei
what are you taking this semester?
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, "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
>>>>>>>
>>>>>>>
|
|
