MESSAGE
DATE | 2014-12-18 |
FROM | Ruben Safir
|
SUBJECT | Re: [LIU Comp Sci] Normalization review
|
From owner-learn-outgoing-at-mrbrklyn.com Thu Dec 18 13:02:22 2014 Return-Path: X-Original-To: archive-at-mrbrklyn.com Delivered-To: archive-at-mrbrklyn.com Received: by mrbrklyn.com (Postfix) id ABD7C161167; Thu, 18 Dec 2014 13:02:22 -0500 (EST) Delivered-To: learn-outgoing-at-mrbrklyn.com Received: by mrbrklyn.com (Postfix, from userid 28) id 9793F161169; Thu, 18 Dec 2014 13:02:22 -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 B8DD2161167 for ; Thu, 18 Dec 2014 13:02:21 -0500 (EST) Received: from panix2.panix.com (panix2.panix.com [166.84.1.2]) by mailbackend.panix.com (Postfix) with ESMTP id A65C6135C4 for ; Thu, 18 Dec 2014 13:02:21 -0500 (EST) Received: by panix2.panix.com (Postfix, from userid 20529) id 7C9A233C87; Thu, 18 Dec 2014 13:02:21 -0500 (EST) Date: Thu, 18 Dec 2014 13:02:21 -0500 From: Ruben Safir To: learn-at-mrbrklyn.com Subject: Re: [LIU Comp Sci] Normalization review Message-ID: <20141218180221.GB8203-at-panix.com> References: <20141218154519.GC4242-at-panix.com> <20141218160916.GA14854-at-panix.com> <20141218165609.GA3184-at-panix.com> <20141218170904.GB3184-at-panix.com> <20141218171309.GC3184-at-panix.com> <20141218171812.GA16120-at-panix.com> <20141218175719.GA8203-at-panix.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20141218175719.GA8203-at-panix.com> User-Agent: Mutt/1.5.23 (2014-03-12) Sender: owner-learn-at-mrbrklyn.com Precedence: bulk Reply-To: learn-at-mrbrklyn.com
those slides 6-56 and 6-55 , I've been staring at the text book all night to make sense of that section.
That does not explain how you get to where you need to be, and it doesn't explain what the function PROJECT(x) ACTUALLY is. That should be the set of ALL tuples in Project.
On Thu, Dec 18, 2014 at 12:57:19PM -0500, Ruben Safir wrote: > Ah - but that is the same as the text book. > > It says, for example: > > The only free tuple variables in a relational calculus expression should > be those that appear to the left of the bar ( | ). > In above query, t is the only free variable; it is then bound > successively to each tuple. > > WHY? What is the point of the bar and what does it matter if a tupple > variable is free or bound? > > This should have been tought FIRST, in the first two weeks and driven > into us over the entire semester. This is tough and important stuff. > > Ruben >
|
|