I was wondering if anyone has any good or bad ideas to share from experience.
The only real problems I seem to have designing them are supporting the types of query to check and then display availability and the inevitable changes to the spec like scaling it up work with more products, different products.
One idea I have been experimenting with is using a de-normalised dimension table, to help out these queries:
tblDate ( #fulldate, day, month, year, weekNumber, season, quarter, custom1, custom2)
Anyone done anything like this, or have any general tips for designing booking systems?
tblDate ( #fulldate, day, month, year, weekNumber, season, quarter, custom1, custom2)
Not sure I understand why you would do this or how it would help (but then I've never built a 'bookings' db). Perhaps a small example may be useful?
