Re: Impossible Database Design?

Hehe.. thats absolutely true!!
I probably have not enough experience to really start arguing but I am still curious whether there actually is a way to set up a db which would

1. allow infinite events (thats what the client wants or it should at least I should make him believe he got it)
2. allow the calculation whether ('infinitly') repeating events overlap (Is required because I have to see whether a repeating event conflicts with another one when adding)
3. Not have lots of entries per year (say you have a university with 5000 students having 12 lessons 40 weeks a year), and is performant
4. (allow exceptions: repeat every monday except monday 15th of May 2006)

> Pointing that out usually quiets them down.

Pointing out the limits of the computer definitely moves the whole issue into perspective - though the problem remains the same and I am still curious as to how a workable solution would look like..

It would be quite simple to write a calendar supporting true infinite events by just leaving the end date empty but as far as I can think of it won't be possible anymore to calculate overlaping events.. Anyways I apprechiate your posts and if you have any links or working examples I would be more than happy to try them out..

Nikolai Received on Tue May 16 2006 - 16:41:32 CDT