Subject what's the best database design for this problem...
Author zifnabbe
Hi,

I'm developing an appointment system. The users are able to enter
holidays on which no appointment is possible. They are also capable
of telling which periods in a day are possible to make appointments
(overbooking parameter, etc)...
The holidays and time periods should be adaptable.

Now, so far I made for this problem 3 tables:

1. The appointment table (containing the appointments)
2. The Holiday table (containing the days on which no appointments
are possible)
3. The Planning Table (containing the periods on which an appointment
is possible)

With code I would find a correct appointment and add that into the
appointment table.

Now, I don't know if this is the right approach... Are there better
approaches?

Eg. Usage of only one table, in which you have a parameter which says
the entry is an appointment or a not possible day,period.

Or, just I make a temporary, view table, which combines the three
tables into one?

I imagine some of you, more experienced database applications, know
how to tackle such problem in the best way. I hope you would like to
share your knowledge with me.

Thanks in advance!

Tom.