| Semester | Spring 2003 |
| Class Sessions | Thursday 2:00 - 4:20 pm |
| Class Location | Gullickson Hall - Room 206A Huntington Campus |
| Course Description | Conceptual and logical database design; physical implementation including data storage and retrieval mechanisms. Application of databases to Geographic Information Systems (GIS) including current web-based data retrieval and presentation technologies. Combination of lecture and hands-on lab activities. |
| Prerequisite | Permission of Instructor |
| Text | Connolly and Begg, Database Systems (3rd Ed), Addison Wesley |
| ISBN | 0-201-70857-4 |
| Instructor | Jonathan Thompson |
| Office Phone | 304-696-6349 |
| Office Fax | 304-696-5454 |
| ThompsonJ@marshall.edu | |
| Office Location | Gullickson Hall - Room 116 Huntington Campus |
| Office Hours | By appointment |
Absences are not excused unless prior arrangements are made, or in the event of illness or hazardous driving conditions.
Hand in lab assignments at the end of class. They must be turned in no later than the beginning of the next class for those who need more time.
There will be a project assigned in the second half of the course. Students will work in pairs (with a possible trio) and topics will be provided.
Additional textbooks of note:
Rigaux, Scholl, and Voisard, Spatial Databases, Morgan Kaufmann Publishers ISBN 1-55860-588-6
Shekhar, Shashi, Spatial Databases: A Tour, Prentice Hall, ISBN 0-13-017480-7
Worboys, Michael F., GIS: A Computing Perspective, Taylor Francis, ISBN 0-7484-0065-6
Ormsby, Tim, et. al., Getting to Know ArcGIS Desktop, ESRI Press, ISBN 1-8791-0289-7
| Grading Components | Grading Scale | |||
| Homework | 11% | A - For achievement of distinction. | 90-100% | |
| In-class Quizzes | 11 | B - For competent and acceptable work. | 80-89 | |
| Mid-Term Exam | 20 | C - For below average performance. | 70-79 | |
| Final Exam | 8 | D - For patently substandard work. | 60-69 | |
| Lab Exercises | 27 | F - Failure, given for unsatisfactory work. | 0-59 | |
| Project | 23 | |||
| Total | 100% | |||
| Session | In-Class Activity | CD Lecture Topic | Reading | |
| 1 | 28-Aug | Course Introduction Introduction to Relations |
Relational Model | 1, 3 |
| 2 | 04-Sep | Forming Relations | SQL Retrieval | 5, 9 |
| 3 | 11-Sep | SQL Retrieval | SQL Tables | 6, 10 |
| 4 | 18-Sep | SQL Tables and Views | E/R Modeling | 11, 14 |
| 5 | 25-Sep | E/R Modeling | Normalization | 13, 15 |
| 6 | 02-Oct | Normalization | Physical Design | 16, 18 |
| 7 | 09-Oct | Access Database | ||
| 8 | 16-Oct | Midterm | ||
| 9 | 23-Oct | Midterm Review Project Assignments |
Handout 1 | |
| 10 | 30-Oct | Client Server: Access/ArcSDE | Handout 2 | |
| 11 | 06-Nov | Client Server: Web/ArcIMS | ||
| 12 | 13-Nov | Project Work | ||
| 13 | 20-Nov | Project Work | ||
| 27-Nov | Thanksgiving Break | |||
| 14 | 04-Dec | Project Work | ||
| 15 | 11-Dec | Project Presentations Final Exam |
||