Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: I was made of fun of the last time I posted, but here goes..

Re: I was made of fun of the last time I posted, but here goes..

From: mAsterdam <mAsterdam_at_vrijdag.org>
Date: Tue, 02 Oct 2007 09:19:21 +0200
Message-ID: <4701f075$0$244$e4fe514c@news.xs4all.nl>


Evan Keel schreef:
> I am developing a database design course for young PHP programmers. Here is
> why:

???

> CREATE TABLE tblShoes(
> charSKU as Char(10) //first 3 characters indicate color,
> charSizes as char(5) // ex. 7B,7C,7D,7E,7EE,7EE,8A,
> intPID as int //Producer number //Producer ID
> charPCity as varchar(35) //producer city );
>
> ... the // are just comments.

[snip]

What do I need this data for?
What does it mean?
What does a row in our table tell us, which facts exactly does it convey?

First, get rid of the noise:
CREATE TABLE Shoes(

   SKU as Char(10), //first 3 characters indicate color,
                    // SKU stands for ...
   Sizes as char(5) // ex. 7B,7C,7D,7E,7EE,7EE,8A,
                    // sizecode?

   PID as int //Producer number //Producer ID    PCity as varchar(35) //producer city );

A little premature normalization (syntax, form) is possible. Based on your names and comments,
it looks like we have a good deal of updating Shoes.PCity when a Producer moves.
Lets make a table Producer(ID, City), removing PCity from Shoes, keeping Shoes.PID (or Shoes.Producer_ID, seems more readable) as a foreign key to 'Producer'.

Still, the questions to be answered first are about pragmatics and semantics,
/use/ and /meaning/ :
What do I need it for?
What does it mean? Received on Tue Oct 02 2007 - 02:19:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US