Designing DB's is an entire domain of study in itself!

However the rules (guidelines rather) I stick by at present but am open 
to new ones as I need them,- are:

* Don't repeat data across tables (leads to 'data redundancy' = more 
complex to update the DB)
* If in doubt 'put it' in a new table
* Use useful and memorable names for your tables and table columns

I do:


Good luck!

         "Believe nothing - consider everything"        
           "Web Developers do it on-the-fly."
  Russ Michell
  Anglia Polytechnic University Webteam
  +44 (0)1223 363271 ext 2331

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to