Re: Impossible Database Design?

From: Nikolai Onken <nikolai.onken_at_gmail.com>
Date: 17 May 2006 01:51:28 -0700
Message-ID: <1147855888.068190.203250@j55g2000cwa.googlegroups.com>

> Ask your client what events will want to store in the computer and what is
> the best way for him to input that data.

Hehe :) the client wants:
- 'infinitely repeating dates' (whatever thats supposed to mean in the end)
- being able to predict whether courses overlap - having exceptions to series (every monday except xxx)

My conclusion would be that probably the best way would be to simply not support queries for predicting overlaps for dates without ending point..
This probably makes most sense anyways since the only type of never ending event is something like a birthday or memorial or so.. and there you probably don't really need to know whether it overlaps with another never ending event.. Received on Wed May 17 2006 - 03:51:28 CDT