you need to normalize your database structure, and create an ER diagram based on that.
On Tue, 11 Nov 2003, Meli Meli wrote: > > I have a table with following structure: > > Id > first quarter > second quarter > third quarter > last quarter > year > month > week > day > > On an entry not all fields of the four quarter fields are covered with values. > Following combinations are possible: > > first quarter | second quarter | third quarter | last quarter > > > > x null null null > > null x null null > > null null x null > > null null null x > > x x null null > > x null x null > > x null null x > > null x x null > > null x null x > > null null x x > > x x x null > > x x null x > > x null x x > > null x x x > > x x x x > > > > The table will receive many thousands of entry’s. > > Would it be better to divide the table in to 15 small tables in order to not > register fields with null values? > > > > Thanks for helping > > Regards Martin > > > > --------------------------------- > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]