You are here: simple database modelling problem « PHP SQL « IT news, forums, messages
simple database modelling problem

Posted by luigi7up on 05/18/06 14:31

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация