In Class Exercises
1. Watch the Hans Rosling video at http://www.youtube.com/watch?v=jbkSRLYSojo
2. Dr. Rosling concludes that the analysis involved plotting “120,000 numbers.” Explain where the 120,000 count came from.
3. List the attributes that you believe must be stored in a database that supports this analysis (and perhaps similar analyses)
4. Give candidate (tentative) relational schema (at least two) for a database that would support this and similar analyses
5. Give three queries in relational algebra over the schema that you give in part 4, which you think would be useful for the video’s analysis or a similar analysis