People can make a request for a room, but that does not mean this person is guaranteed to get the room. People can cancel their request, or not perhaps they don’t show up.

A request is confirmed if there is an entry in the bookings data for it.

Let’t take a closer look at the data:

Data from the room requests:

request id|client name|room type|request type|start date|end date|#adults|#children
...
35|Cristopher Schmidt|double_room|holiday|2016-02-12|2016-02-15|4|0
36|Alena Kassulke MD|conference_room_small|conference|2016-01-13|2016-01-17|25|0
37|Danial Oberbrunner|normal_room|holiday|2016-03-02|2016-03-10|5|1
...


Data from the room bookings:

id|room|start date|end date|request id
...
69|D12|2016-02-12|2016-02-15|35
70|N0|2016-03-02|2016-03-10|37
71|N1|2016-03-02|2016-03-10|37
72|N2|2016-03-02|2016-03-10|37
73|N3|2016-03-02|2016-03-10|37
74|N4|2016-03-02|2016-03-10|37
75|N5|2016-03-02|2016-03-10|37
...

Here we notice two things:

1. Request ID 36 has not been confirmed, because it is not in the booking data.
2. Request ID 37 has been translated into bookings 70 through 75, because this person wants normal roomsfor 6 people, while the room capacity for a normal room is 1 person.