Ask
Login
1
1.9kviews
Information requirements are recorded for Hotel occupancy considering dimensions like Hotel, Room and Time.
written 6.6 years ago by gravatar for teamques10 teamques10 ★ 70k •   modified 4.0 years ago

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.
data warehouse and mining
ADD COMMENT EDIT
1 Answer
0
77views
written 4.0 years ago by gravatar for teamques10 teamques10 ★ 70k

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

Create a free account to keep reading this post.

and 3 others joined a min ago.

ADD COMMENT EDIT
Please log in to add an answer.