How to tackle recurring events

Hey,

I wanna do something like an event system for teachers and wonder how to store the event data. For example, a teacher has many students. Each Student can have multiple (recurring) events, like the weekly lesson. Some events are rather generic, which apply for all students - like a summer party.

The following tasks should be accomplished:

1. Store each event. The event and additional data (like description) should be stored somehow. If necessary, there should be an association to the student.

2. Retrieve all events for a period On an overview page, I would like to display a calendar, an event list or an ical feed for the teacher. All events should be retrieved - the generic ones and the associated ones.

3. Retrieve all events for a student In the student details I would like to display all events for a period and provide a ical feed for the student.

I have no problem with single events. But recurring events makes me headaches. Do I need to store an origin event, and calculate the recurring ones in the view? Or should I create and persist the recurring ones, too?

Now the big question: how tackle recurring events?

best wishes, AxlF