It should be just as simple as understanding the following terms and when
they should be used:
- entity
- attribute
- relationship
- cardinality
- first normal form
- second normal form
- third normal form
- fourth normal form
- boyce-codd normal form (BCNF)
- fifth normal form (could ignore this one if not going hard-core :)
The normal forms are the most important - if you know and understand them,
they will basically build a wholesome relational database for you (up to
fourth normal form) ... the only decisions to be made beyond what fourth
normal form will 'make for you' is how 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 good database design
> > Hmmmm... 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. :)
>
> 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.
>
> > Do you have some real-life examples that you'd care to discuss in the
> > open? Using real-life examples (with the added realism of budgets,
> > legacy code, deadlines, etc.) may help everyone here.
>
> I agree - throw us some examples of what you're thinking about, Justin.
>
> Jason
>
> --
> Jason Murray
> [EMAIL PROTECTED]
> Web Design Team, Melbourne IT
> Fetch the comfy chair!
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
