In this exercise, you will create a table to store the population and land area of the Canadian provinces and territories according to the 2001 Census. Our data is taken from http://www12.statcan.ca/ english/census01/home/index.cfm.
a) Create a new database called census.db.
b) Make a database table called Density that will hold the name of the province or territory (TEXT), the population (INTEGER), and the land area (REAL).
c) Insert the data from Figure 15.14.
d) Display the contents of the table.
e) Display the populations.
f) Display the provinces that have populations of less than 1 million.
g) Display the provinces that have populations less than 1 million or greater than 5 million.
h) Display the provinces that do not have populations less than 1 million or greater than 5 million.
i) Display the populations of provinces that have a land area greater than 200,000 square kilometers.
j) Display the provinces along with their population densities (population divided by land area).