Scenario 2 - a hotel reservation system

In this scenario, we need to provide the ability to book hotel rooms through the system. We can use a custom post type called rooms to keep the details of various types of room inside the wp_posts table. All the additional room-specific data, such as room type, check-in and check-out dates, and number of people, can be created using additional fields in the wp_postmeta table.