In Class Activity 01

Instructions

Watch the Hans Rosling video on YouTube and type the answers to the questions listed on today’s presentation.

http://www.youtube.com/watch?v=jbkSRLYSojo

Assignment

  1. Dr. Rosling concludes that the analysis involved plotting “120,000 numbers.” Explain where the 120,000 count came from.

  2. List the attributes that you believe must be stored in a database that supports this analysis (and perhaps similar analyses)

  3. Give candidate (tentative) relational schema (at least two) for a database that would support this and similar analyses

My Answers

  1. The 120,000 numbers came from two hundred countries with over two hundred years of data on life expectancy, population, and wealth.

    • 120,000 / 200 * 200 = 3 parameters

  2. The attributes that must be stored are year, continent, country, providence/state, city, average life expectancy, population, and wealth.

  3. Schema #1

    • TimeStampedCountry(Year, Country, Providence, City, Average_Life_Expectancy, Population, Wealth)

    Schema #2

    • TimeStampedCountry(RegionName, Year, Average_Life_Expectancy, Population, Wealth)
    • Region(SubRegionName, SuperRegionName)

Related Posts