ilto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 10:45 AM
Cc: php
Subject: Re: [PHP] tutorials on good database design
Jason Murray wrote:
> True - I find the best way to explain database design to someone is by
> having them design a database (as with someone here last week whom I
> he
, March 13, 2001 7:38 PM
To: php
Subject: [PHP] tutorials on good database design
hi,
i'm looking for some good tutorials / articles / books on database
design, no, i'm not talking about the classic employee contact database
that nearly every site has lingering somewhere... i'm
Jason Murray wrote:
> True - I find the best way to explain database design to someone is by
> having them design a database (as with someone here last week whom I
> helped out with an office sports tipping database as a little how-to-SQL
> project) and help them out as they go.
First up, thanks
ow far you want to go in splitting up
entities...
AndrewH
- Original Message -
From: "Jason Murray" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "php" <[EMAIL PROTECTED]>
Sent: Wednesday, March 14, 2001 12:19 PM
Subject: RE: [PHP] tutorials on goo
> I agree - throw us some examples of what you're thinking about, Justin.
>
> Jason
I'm not Justin but I have a question. I would like to write a billing
database to keep track of my hours for clients. I would like to
keep track of what date I've been paid through and then create
a report for
ECTED]>
> Sent: Wednesday, March 14, 2001 2:00 AM
> Subject: Re: [PHP] tutorials on good database design
>
>
> > One of my co-worker has a phenominal book on sql. You will want
something
> > that covers the different
> > type of joins... when to use them, as well
One of my co-worker has a phenominal book on sql. You will want something
that covers the different
type of joins... when to use them, as well as database normalization,
reinforcing data integrity with
foreign and primary keys. You will also want some transact sql in there
and some indexing.
> H... while there are abstract ideas which are generally useful
> and prudent to adhere to, I don't think most people understand them
> too well as abstracts and need concrete examples to map them to.
>
> Hence the employee contact database examples. And simple
> shopping cart examples. :
You could try the book SQL for Smarties by Joe Celko... I'm not through
it yet, but it's got some theory (but not enough to make your head hurt)
and goes over all the various SQL commands... in the TOC there's stuff
on how to implement directed graphs (such as the organizational path
from you to t
As usual, O'Reilly did a great job with MySQL/mSQL by Randy Jay Yarger,
George Reese and Tim King
jack
Justin French wrote:
>
> hi,
>
> i'm looking for some good tutorials / articles / books on database
> design, no, i'm not talking about the classic employee contact database
> that nearly ever
H... while there are abstract ideas which are generally useful
and prudent to adhere to, I don't think most people understand them
too well as abstracts and need concrete examples to map them to.
Hence the employee contact database examples. And simple shopping cart
examples. :)
Do you hav
MySQL by Paul DuBois is a very good one.
Jeff Oien
> hi,
>
> i'm looking for some good tutorials / articles / books on database
> design, no, i'm not talking about the classic employee contact database
> that nearly every site has lingering somewhere... i'm after the good stuff:
>
> smart data
hi,
i'm looking for some good tutorials / articles / books on database
design, no, i'm not talking about the classic employee contact database
that nearly every site has lingering somewhere... i'm after the good stuff:
smart data design
smart data planning
unique keys
taking advantage of relatio
13 matches
Mail list logo
