Re: Designing a database
| From: | Russ Michell | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | Re: Designing a database | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-8703@lists.php.net to get a copy of this message | ||
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:
tablename_colname
Good luck!
Russ
#-------------------------------------------------------#
"Believe nothing - consider everything"
"Web Developers do it on-the-fly."
Russ Michell
Anglia Polytechnic University Webteam
www.apu.ac.uk/webteam
r.j.michell@apu.ac.uk
+44 (0)1223 363271 ext 2331
www.theruss.com
#-------------------------------------------------------#