Re: Database-design

[Brent Baisley]

Why would you created separate fields for each quarter? Create a field 
called quarter and store a number in it. You could also combine year, 
month and day into a date field, which would make it easier to search 
on ranges.
So, I think your table should look like this:
id
quarter
eventdate
week

On Tuesday, November 11, 2003, at 02:33 PM, 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
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]