"Richard Heyes" <richardh@xxxxxxxxxxx> wrote in message news:481ED03B.7090200@xxxxxxxxxxxxxx > > 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 | > +----------------------------------------+ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php