Re: I was made of fun of the last time I posted, but here goes..
Date: Tue, 02 Oct 2007 09:19:21 +0200
Evan Keel schreef:
> I am developing a database design course for young PHP programmers. Here is
> 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.
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,
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 - 09:19:21 CEST