GEO 426/595 - Database Design for Geographic Information Systems

Textbooks

Required Text

Frank, Egenhofer and Hudson - Part 1

Frank, Egenhofer and Hudson - Part 2

Strongly Recommended Text

Syllabus

Class Lectures

August 25 - Introduction August 27 September 1 -
Labor Day,
No Class
September 3
September 8 September 10 September 15 September 17
September 22 September 24 September 29 October 1
October 6 - Yom Kippur - No Class October 8 October 13 October 15
October 20 October 22 October 27
Normalization
October 29
Making Objects
November 3
SQL Commands
November 5 November 10 November 12
November 17 November 19 November 24 November 26 - Thanksgiving
No Class
December 1 December 3 - Final Exam Distributed December 8 - Last Class December 15 - Final Exam Due by 12:00 Noon E.S.T.

Practical Exercises

Exercise Distributed On Due By
1 - Say It Without Meaning. Sept. 3 Sept. 10
2 - True or Not True? You be the Judge. Sept. 15 Sept. 24
3 - In the Family Way, Say It's True. Sept. 24 Oct. 6
4 - By "Uncle," I mean... Oct. 8 Oct. 20
5 - Universally Understood: UML Design Oct. 15 Nov. 12
6 - Who's My Mother? Relational Relatives

Lab 6 Solution

Nov. 5 Nov. 17
7 - Say It With SQL. Connect to Oracle Server Nov. 17 Nov. 24
8 - Yes, You Can Be a Consultant. Dec. 1 Dec. 8

Software and Documentation

To download a trial version of WINProlog go to http://www.lpa.co.uk/ind_dow.htm

The main website for GNU Prolog can be found here http://pauillac.inria.fr/~diaz/gnu-prolog/

Oracle Corporation has a variety of software products that are available for
educational download at: http://otn.oracle.com/software/index.html

In class we will be using the iSQL*Plus Reference Guide and SQL Language Reference