1
1.5kviews
Information requirements are recorded for Hotel occupancy considering dimensions like Hotel, Room and Time.
written 5.0 years ago by | • modified 2.4 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