Name: _____________________

Section: _____

Ed Tech I
DB1
Exercise for Databases

You will need to copy the ClarisWorks database file called Country from the MAC: Ed Tech I: Data folder on the MAC volume to your personal floppy disk.

Open the Country database and use sorting and querying to answer the following questions.

  1. What country is the fifth most populated? ____________________

    2.  
     
  2. What are the three countries with the smallest area in the database?

    3.  

    __________________________________________________________________
     

  3. How many countries use either the ruble or the pound as their currency? _______

    4.  
  4. Which countries with areas over 3 million use the dollar as their currency?

    5. __________________________________________________________________
     

  5. Which countries have a population between 50,000 and 80,000?

    6.  

    __________________________________________________________________
     

  6. Which countries using the franc as their currency have areas less than 15,000?

    7.  

    __________________________________________________________________
     

  7. Of the countries that use either the franc or the pound as their currency, which has the largest area?

    8.  

    _________________________________
     

    Add to your database a calculated field for Population Density
  8. Of the countries that use the pound as their currency, which one has the greatest population density?

    9. _________________________________