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
Try a book called - Database Design For Mere Mortals by Michael J.
Hernandez. This book does a wonderful job of explaining concepts and theory
on good RDB design. It also goes through the SQL syntax.
Chad
-Original Message-
From: Justin French [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
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
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
11 matches
Mail list logo
