Consider a data warchouse for hotel occupancy, where there are four dimensions namely (a) Hotel (b) Room (c) Time (d) Customer and two measures (i) Occupied rooms (ii) Vacant rooms. Draw information package diagram,star schema and Snowflake Schema.