Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news-han1.dfn.de!news-fra1.dfn.de!newsfeed.hanau.net!noris.net!news2.arglkargh.de!news.cnetm.de!news.mb-net.net!open-news-network.org!eleonora.aioe.org!emma.aioe.org!aioe.org!not-for-mail
From: "x" <x@not-exists.org>
Newsgroups: comp.databases.theory
Subject: Re: Impossible Database Design?
Date: Wed, 17 May 2006 11:41:32 +0300
Organization: Aioe.org NNTP Server
Lines: 24
Message-ID: <e4enfi$l28$1@emma.aioe.org>
References: <1147793576.656483.275490@j73g2000cwa.googlegroups.com>
NNTP-Posting-Host: s9btCjTiVvvsgWfav5q8uQ.user.aioe.org
X-Complaints-To: abuse@aioe.org
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Priority: 3
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MSMail-Priority: Normal
Xref: dp-news.maxwell.syr.edu comp.databases.theory:39632


"Nikolai Onken" <nikolai.onken@gmail.com> wrote in message
news:1147793576.656483.275490@j73g2000cwa.googlegroups.com...
> Hey,
>
> I was just wondering if it is possible to create a database design
> where you can have
>
> 1. Infinite repeating events like "every year, every last monday,..."
>
> 2. The possibility to test whether events overlap other events
>
> I would say it is not possible since I would need to run an infinite
> query to catch a singular event..
> Any ideas?
> What would be the 'nearest' approach?
> Cheers,

It's easy.
Ask your client what events will want to store in the computer and what is
the best way for him to input that data.
Work from there.