1 / 9

Test 2 Sample

Test 2 Sample. note: not necessarily covers all the questions in the exam. Given a database (see next slide), how do you add/change rows in one or more tables.

adler
Download Presentation

Test 2 Sample

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Test 2 Sample note: not necessarily covers all the questions in the exam

  2. Given a database (see next slide), how do you add/change rows in one or more tables

  3. There is a new faculty member named “Dr. Martha Henderson.” She is a new Assistant Professor in the Accounting department and her office is 535 Alter Hall. Her phone number is 214-204-5432. Her email address is mhenderson@temple.edu.

  4. Given a star schema (see next slide) • What is the fact in this schema? • Which one is the fact table?

  5. Smoking Smoking_code Smoking_YN Guests Guest_number Guest_firstname Guest_lastname Guest_address Guest_city Guest_zipcode Guest_email Hotels Hotel_id Country_code Hotel_name Hotel_address Hotel_city Hotel_zipcode Average_star_rating Reservation Reservation_id Hotel_id Guest_number Time_id Smoking_code (Average) room_rate Number_days Time TimeID Month Day Year

  6. Choose fields to draw a Pivot Table to answer the following questions (see next slide): • Which products sold most in January in zip code 19122 • Which product did 20 year old customers buy most in Northeast Region?

  7. BMW Dealerships • Dimension 1: LocationThere are locations: Philadelphia, Atlanta, San Francisco, New York • Dimension 2: ProductThere are four models of cars: X5, 3 series, 5 series, 7 series • Dimension 3: Time There are three time periods: October 2011, November 2011, December 2011 • Fact: Quantity and Revenue

  8. Represent this information in the data cube. What does the shaded area represent?

More Related