and 4 others joined a min ago.
1
1.9kviews
Information requirements are recorded for Hotel occupancy considering dimensions like Hotel, Room and Time.
written 6.7 years ago by
teamques10
★ 70k
|
• modified 4.1 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.
ADD COMMENT
EDIT
1 Answer