The following problems will all result in either 1-many (2 tables) or many-to-many solutions (3 tables). I have provided both a 1-many and many-to-many templates. Do not fill them both in; instead, decide which one to fill in based on the problem description and your understanding of the entity to entity relationship. Do not make them more complicated than that. More details of the problems will not be provided (be sure to read the Hints section below).

Question: A chain of hotels may have many guests and a guest may stay with each of the hotels more than once. For each hotel, we need the hotel name, address, and phone number. The hotel needs to keep track of the guest's name, address, phone, check-in, and check-out dates. Prices may fluctuate based on seasonality (or coupons, etc.). Because of this, a guest may pay different prices when they stay with the hotel at different times.

\f