How avoid overbooking appoitment

[Oscar_Rossini]

Hi,

I am creating an application to manage reservations for a hostel,

I cannot allow overbooking.
Unfortunately, I cannot find examples or explanations on this particular topic on the web.
I only have two tables, one of guests where the basic data are loaded, name, date of entry, date of departure and another table that contains the data of the different rooms and their prices.
Can someone help me please, thank you very much