How do you prevent overlapping reservations at the database level?

Write or say your answer first, then compare it with the model answer.