CSc 8710. DDLP
Fall 2000, HW 7 (Geography Database in Oracle using Object-Relational Features)
Due: Monday, November 27th

The project consists of 3 parts:
  1. Part I: Design an object-relational database for the geo.xml database.
  2. Part II: Write a program in Java that populates an Oracle database consisting of object-relational tables with the data.
  3. Part III: Write a program in Java which implements the following menu-based system:
        MAIN MENU
    
      (1) Given the first letter of a state, print all states along
          with their capital city names.
      (2) Print the top 5 populated states in descending order of population.
      (3) Given a state name, list all information about that state,
          inlcuding capital city, population, state nickname, major
          cities, etc. The report should be formatted nicely.
      (4) Print an alphabetical count of number of states for each letter of
          the English alphabet. (Nicely formatted; 4 letter counts to a line).
          The count is the number of states whose names begin with the letter.
      (5) Quit
    
    The Java program should access the Oracle database created in Part II.