Few Facts recorded are vacant rooms, occupied rooms, number of occupants, etc.

Answer the following questions for this problem:

i. Design the star schema.

ii. Can you convert this star schema to a snowflake schema? If yes, justify and draw the snowflake schema.

https://www.ques10.com/p/43680/information-requirements-are-recorded-for-hotel--1/