INLS 490-154: Information Retrieval Systems Design and Implementation

Spring 2009. Thursdays 5:30-8:00pm, Greenlaw Hall 104

[ Home ] [ Syllabus ] [ Assignments ] [ Project ] [ Resources ]

Assignment-1: IR from a MySQL database
Assigned on: 01/15/2009, Due on: 01/20/2009
Answer the following questions using the 'world' database. Present your SQL queries and/or processes that you use to derive the answers.
Email your answers to the instructor with "INLS 490: Assignment-1" in the subject field.

1. How many countries have English as their official language? (1 point)
2. How many countries became independent in the 20th century? (1 point)
3. How many people in the world are expected to live 75 years or more? (1 point)
4. List the 10 most populated countries in the world with their population as % of the world population. (2 points)
5. List the top 10 countries with the highest population density. (2 points)
6. List the capitals of all the Baltic Countries. (3 points)

| Chirag Shah | Last update: May 3, 2009 |