Exam02 Joins

Joins and Relates (9)


  1. What is the difference between a join and a relate?
  2. What is the difference between one-to-one, one-to-many, many-to-one relationships of data tables?


  1. Open a blank map and add countries from Exercise 3.
  2. Add the "Data" worksheet from the data table HigherEducationData2002 (data source: NSF) in the Exam02 folder.
  3. Examine both data files. How many countries in the geographic layer? How many in the education data table?
  4. What field names contain country names in the two files?
  5. Do a join between them using these fields. Keep only records that match (so that we can track how many do match).
  6. What would you suggest as the next step if you were trying to create this as a research data set?
  1. Add a fresh copy of countries to the map, color its polygons light grey with no borders and move it to the bottom.
  2. Make a shade by quantity map of the data using the field that gives ratio of first university degrees to size of 24 year old population.