Explore BrainMass

Data Warehousing

Homework help from our online tutors - BrainMass.com

You have been asked to design a star schema for a large hotel chain. Review the information package given for a hotel chain in Figure 5-6 in the attached file. Use this information package to design the STAR schema.


- Draw the star schema.
- List the attributes for each table.
- Designate a primary key for each table.

© BrainMass Inc. brainmass.com September 18, 2018, 9:35 am ad1c9bdddf


Solution Summary

Data Warehousing is exemplified.