simple database modelling problem

Hi,

Im trying to solve following problem.

There is a team of people (7) that need get together every now and than.
The problem is that every individual has a lot of obligations

and it is very difficult to manage their meatings. One has time on
mondays from 16-19 others have time some other days etc.

So, I came up with an idea of building a database (+web app) of their
free/busy time during a week.

Is this concept ok?

Build a table for every member with attributes R (day, hour, state ) and
than just intersect tables and

get my resault or, maybe, you have a better idea?

Second question is how to INTERSECT in MySql since MySql doesn't
support INTERSECT

Thanx, Luka, Croatia

Re: simple database modelling problem

Give each of them a sheet of acetate with a 5-day calendar (divided
into 1/2 hour slots from say, 8.00 - 20.00) photocopied onto it. Ask
each of them to colour in all busy slots. Collect them together and
hold them up to the light.

Bingo