Computer Science Homework Solutions
Problem
#107062

Data Warehousing

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.

Problem:

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

Attached file(s):
Attachments
Data Warehousing 1.doc  View File
Solution
What is this?
By OTA - Overall OTA Rating
Xiao Liu, MS - 4.7/5
Purchase Cost Now
$2.19 CAD (was ~$59.85)
Included in Download
  • Plain text response
  • Attached file(s):
    • starSchema.doc
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • Computer Information Systems data warehousing/data mining - I need to know how are data warehousing and data mining related?
  • Trailways Bus Lines - Last week, you and the owner of Trailways Bus Lines sketched out a basic table format to use on the Updated Prices Web page of the Trailways Bus Lines Web site. As you begin to build the Web page, yo ...
  • Databases-derived attribute - Hi, What is derived attribute? Give an example. I require a detailed example and definition of this problem with referencing please. Regards,
  • Excel S3-P5 - 1. Melissa Gehring, manager of the Los Angeles office for First Choice Travel, has prepared a worksheet listing European destinations and the current package pricing options. Melissa has requested tha ...
  • Data Warehousing - What is data warehousing? How are databases and data warehousing related? Do you believe data warehousing is a fad or a "real" technology which will benefit organizations? What are XML databases? A ...
Browse