Hi,

I have a problem designing a ressource allocation system.

Lets say I have a ressource that I want people to able to reserve for a specifik amount of time.
So for example i have a reservation table with the following structure: RessourceID, startTime, finishTime

How do I make that there aren't 2 people reservering the same item at the same time??

since each reservation is made in different transactions I can't make sure they aren't working on the same timespan for a specific ressource.