Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems

by Martin Kleppmann

You create rows for all possible combinations of rooms and time periods ahead of time, e.g. for the next six months.