Re: Re: Where to start!
| From: | Tony Marston | Date: | Mon, 05 May 2008 09:31:45 +0000 |
| Subject: | Re: Re: Where to start! | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-273878@lists.php.net to get a copy of this message | ||
"Richard Heyes" <richardh@phpguru.org> wrote in message
news:481ED03B.7090200@phpguru.org...
> > The database must be properly normalised otherwise it
>> will be difficult to get at the data you need in an efficient manner.
>
> Not true. If your needs are simple for example, normalisation can increase
> the complexity of a schema, hence increasing development time needed.
> Sometimes for example you could use something like a SET type, and search
> for something in it using FIND_IN_SET().
I disagree. The database should ALWAYS be normalised to at least the 3rd
normal form. Sometimes going beyond that to 4NF, 5NF or 6NF becomes too
complex.
--
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
> --
> Richard Heyes
>
> +----------------------------------------+
> | Access SSH with a Windows mapped drive |
> | http://www.phpguru.org/sftpdrive |
> +----------------------------------------+