Hello everyone. I need some help to design the database or table for my
application on scheduling task. My application is to do some scheduling
task based on daily, weekly and monthly. On the daily the choice are
everyday, weekdays, or every what ever value of the days. On the daily
the choice are every what ever value of the week on the selected days.
On the monthly the choice are on what date, on what day of what week,
and on selected month. My scheduling task choice is the same as
Microsoft Windows XP Professional Version 2002 SP 2 scheduling task
choice. I want to store these choices on database so I can check the
value using timer. Or maybe anyone would suggest different methods.
Thanks in advance...

Do you have a calendar table which identifiies all of these groupings?
Do not try to compute them.

I didn't use calendar table, and I couldn't think of the
appropriate database design. I don't know what table is needed, and
what computation is needed. I say I'm still blank. . Could you
give me some clue or hint? My database application could use ms access,
ms sql server, and mysql. I use this databases engine because in my
country most of the people use these three database engine. And now
I'm doing some research on oracle, because some of my client use
oracle as they database engine.