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

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?

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 - 09:19:21 CEST