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.