On Fri, 1999-09-24 06:24:22 +0200, Bart Zylowski wrote:
> I have just a little question about tables in Mysql.
> Is it better to have more tables with less fields or less tables
> with more fields?
This question isn't really MySQL specific, but you address the broader
field of good (relational) database design in general.
I found some web pages that might be useful:
- Database Tutorials Menu
<URL: http://www.geekgirls.com/xmenu_database.htm >
- Designing a Database -- Understanding Relational Design
<URL: http://www.odf.state.or.us/techsup/MSOFFICE/ACCESS/Ureldes.htm >
<URL: http://www.geog.ubc.ca/courses/klink/gis.notes/rdbms.html >
<URL: http://support.microsoft.com/support/kb/articles/Q164/1/72.asp >
The short answer to your question is:
Neither many nor few fields per table is good, but the right fields!
Every table should be about only _one_ subject, and then should hold
all fields to describe this subject.
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26 E4 EC 80 58 7B 31 3A D7