Is it common practice to maintain a 'Available Accommodations' table in a reservation system?
I'm maintaining a reservation's system for a holiday park. I was wondering if it is common practice to keep a Available Accommodations table which could look like this:

    Acc    AvailableFrom    AvailableTo
    1      7/1/2010         7/31/2010
    2      7/8/2010         7/15/2010
    3      7/15/2010        7/20/2010

Because I think it is easier to find an available accommodation this way. Everytime a reservation is made or changed, the Available Accommodations table is updated. 

Or is this cumbersome and inefficient?


Is it common practice to maintain a 'Available Accommodations' table in a reservation system?
===

I'm maintaining a reservation's system for a holiday park. I was wondering if it is common practice to keep a Available Accommodations table which could look like this:

    Acc    AvailableFrom    AvailableTo
    1      7/1/2010         7/31/2010
    2      7/8/2010         7/15/2010
    3      7/15/2010        7/20/2010

Because I think it is easier to find an available accommodation this way. Everytime a reservation is made or changed, the Available Accommodations table is updated. 

Or is this cumbersome and inefficient?

