Recurring Events

Question

Hi,

I have a module which displays events according to the date. Presently, these events are regular events (i.e.. they don't repeat).
I would like to implement the recurring events for this module. Where, the admin has the ability to enter a new event or edit the existing  event and choose whether it is recurring or not.
If its is recurring, it can repeat daily , weekly, monthly or yearly and their are different scenarios a event can repeat.
I'm trying to figure out the table design and logic to implement this.
Can some one tell me the best way to implement the recurring events.

Thank You in advance,

Naresh