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

#1

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 );

I wrote this real fast and the // are just comments. So my question is C.J
Date hates the concept of data modeling, although at one time he was happy
to define "Entity". I think tables are very logical, and a tool called
FabForce D4Data. It is free.

#2

On Oct 1, 4:11 pm, "Evan Keel" <evank... (AT) sbcglobal (DOT) net> wrote:

Quote:

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 );

I wrote this real fast and the // are just comments. So my question is C.J
Date hates the concept of data modeling, although at one time he was happy
to define "Entity". I think tables are very logical, and a tool called
FabForce D4Data. It is free.

Okay, I am not trying to "make fun" here, but I found your
post confusing. The way I read it is that the above table has
caused you develop a database design course for PHP
programmers. Also you say "my question is" but you don't
follow it with a question.

Marshall

#3

Evan Keel schreef:

Quote:

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

???

Quote:

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?

#4

On Oct 2, 12:19 am, mAsterdam <mAster... (AT) vrijdag (DOT) org> wrote:

Quote:

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 );

Yay!

Marshall

#5

On Oct 2, 12:11 am, "Evan Keel" <evank... (AT) sbcglobal (DOT) net> wrote:

Quote:

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 );

I wrote this real fast and the // are just comments. So my question is C.J
Date hates the concept of data modeling, although at one time he was happy
to define "Entity".

I'd warrant that only CJ Date is going to be able to answer your
questions as to his opinions on data modelling. Luckily he has written
several books around such topics

Quote:

I think tables are very logical, and a tool called
FabForce D4Data. It is free.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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

comp.databases.theory comp.databases.theory

I was made of fun of the last time I posted, but here goes.. - 10-01-2007 , 06:11 PM

Re: I was made of fun of the last time I posted, but here goes.. - 10-01-2007 , 08:00 PM

Re: I was made of fun of the last time I posted, but here goes.. - 10-02-2007 , 02:19 AM

Re: I was made of fun of the last time I posted, but here goes.. - 10-02-2007 , 09:29 AM

Re: I was made of fun of the last time I posted, but here goes.. - 10-03-2007 , 07:19 PM