COURSE SYLLABUS

 

 

COURSE NUMBER:  GMT 220                                                                           

 

COURSE TITLE:        GIS Database Systems                                                   

 

LECTURE HOURS             LAB/SHOP/CLINIC             SEMESTER

PER WEEK   2.0                 HOURS PER WEEK  3.0   CREDIT HOURS  3.0

 

PREREQUISITES:    GMT 101, GMT210                                                

 

 

CATALOG COURSE DESCRIPTION

 

This course provides an Introduction to relational and object oriented database systems.  The course covers designing, customizing and managing geodatabases.  The course will introduce GIS data modeling.  Basic concepts of object oriented programming.

 

 

PURPOSE OF THE COURSE

 

Students will gain an understanding of advanced database systems and how they used to manage GIS data.  Customizing GIS will also be discussed.   Students will study the geodatabase structure and understand how it is used to model the real world.  The course will contain lectures as well as practical exercises using database and GIS software.

 

 

REQUIRED TEXT(S) OR OTHER MATERIALS

 

Modeling Our World: The ESRI Guide to Geodatabase Design, Zeiler, Michael, ESRI, 1999

 

 

DEVELOPED BY: Karen Robbins, Rev. A. Daniels       DATE: Rev. Aug. 20, 2002Aug. 14, 2007

 

APPROVED BY:  ______________________              DATE: ______________

                                    Department Head

 

APPROVED BY: ______________________               DATE: ______________

                                    Division Dean

 

 



INSTRUCTOR  INFORMATION

 

NAME:            Amy Daniels             

 

OFFICE HOURS:                 

 

LOCATION OF OFFICE:     ET317

 

PHONE NUMBER:               250-8141

 

FAX NUMBER:                     250-8419

 

EMAIL ADDRESS:               amy.daniels@gvltec.edu

 

 

COURSE OBJECTIVES    The student will learn:

 

1.         Spatial & Non-spatial databases (tables, queries, etc)

 

2.         Database Theory and Concepts

 

3.         Queries

 

4.         Data Quality Control

 

5.         Object Modeling

 

6.         How to Represent Geographic Data

 

7.         Data & Database structure

 

8.         Geodatabase tables

 

9.         Table & Spatial Data Relationships

 

10.       Smart features and attribute validation rules

 

11.       Geometric Networks

 

11.       Subtypes and domains

 

12.       Geodatabase topology

 

13.       Case Studies and Data Models


 

COURSE OUTLINE AND TEST SCHEDULE

 

TOPIC                                                                                                CLASS HOURS

 

Relational Databases & Microsoft Access                                                20

 

Test1 – Database Theory and Concepts/Intro to Geodatabase

 

 

Introducing the Geodatabase & Modeling the Real World                       13

 

            Test 2 – Geodatabases and Geographic Data    

 

 

Geodatabase Features & Relationships                                                   12

 

            Test 3 – Advanced Geodatabase Concepts

 

 

Geodatabase Design & The Depth of Features                                       20

 

            Test 3 – Case Studies

 

 

Geodatabase Project                                                                                   10

 

Final Exam                 (Comprehensive)

                                                                                                         ____

                                                                                                                        75

 

 

 

EQUIPMENT USED:

 

PCs in GIS Lab

 

 

 

 

LABORATORY SCHEDULE

 

Labs will typically be completed during regular class hours.

See lab schedule posted outside of room 404.

 

 

 

 

 

PROJECTS                                                                                      TIME FRAME

 

NoneGeodatabase Project                                                              11/29 – 12/15

 

                       

COMPUTER USAGE

 

Labs will depend heavily on computer in GIS lab

 

 

SOFTWARE USAGE

 

Microsoft Access 2003

ESRI ArcGIS 9.2

 

 

 

 

CAMPUS LIBRARY USAGE

 

Research for projects

 

 

 

 

DEPARTMENTAL LIBRARY USAGE

 

Research for projects

 

 

 

 

INTERNET LIBRARY USAGE

 

Research for projects

 

 

 

 

 

 

EVALUATION AND GRADING 

 

All Tests together count toward                               40%

            Test 1             100pts                                                           

            Test 2 `           100pts                                                           

            Test 3             100pts                                                           

Final Exam     (comprehensive)                               15%

Weekly Labs                                                              20%

Final Project                                                              10%

Participation                                                              15%

                                                                                    100%

 

 

 

EXPECTED STUDENT COMPETENCIES

 

Student will:

 

            Know how to design and build a geodatabase.

 

            Be able to manipulate a relational database directly or through GIS.

 

            Be able to incorporate a relational database into a GIS.

 

            Be able to combine spatial and non-spatial criteria when operating a GIS.

 

Have a working knowledge of tables and queries in Access 2003.

 

            Have an intermediate working knowledge of ArcGIS.

 

            Have an intermediate working knowledge of the quality control of data.

            Have been introduced to GIS programming and customization issues.

 

 

 

STUDENT CONDUCT\SAFETY REQUIREMENTS

 

1.  Students are expected to conduct themselves in a safe manner in the

     classroom and the laboratory.

 

2.  Horseplay may result in a grade reduction or disciplinary action by the

     school.

 

 

COURSE ATTENDANCE AND MAKE-UP TEST POLICY

 

It is the policy of Greenville Technical College that instructors may have students

administratively withdrawn if they miss more than 10 percent of the contact hours

in a given course without notifying the instructor and clarifying reasons for absences prior to exceeding the 10 percent limit.  The instructor will decide the

validity/acceptability of excuses in light of course requirements and student

performance.

 

Also, a student can withdraw or be administratively withdrawn (for absences) with

a grade of “W” until the 50th day of the 15-week semester.  After the 50th day,

withdrawals will not be processed and students will receive the earned course

grade.  For a 10-week semester, a student can withdraw or be administratively

withdrawn (for absences) with a grade of “W” until the 35th day.

 

A student missing an exam or test because of illness must:

 

1.         Call the instructor before the test period.  A valid excuse must accompany

            each request.

 

2.         Be personally responsible for setting up a make up date and time with the

            instructor.  The make up must be done within five class days of missed

            exam or test.

 

3.         Unexcused absences involving tests may be made up only at the discretion of the instructor.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

CALENDER OF IMPORTANT DATES

           

Classes Begin………………………………August 20

No Classes (Labor Day Holiday)……..…..September 1

No Classes (Fall Break)……………… …..October 15 - 16

Last Day to Withdraw………………………November 13

Thanksgiving Holidays……………………..November 21 - 23

Last Day of Class…………………………...December 10

Exams………………………………………..December 11-14

 

 

CONTACT INFORMATION

 

Department Head

Sid Shrum                           250-8423       sid.shrum@gvltec.edu                      ET-318

 

Dean of Engineering Technology

Sid Shrum                           250-8423       sid.shrum@gvltec.edu                      ET-111A

 

Administrative Assistant to Dean and Division

Pam Apple                          250-8189       pam.apple@gvltec.edu                    ET-111

 

Department Secretary

Teresa Ballard                    250-8838       teresa.ballard@gvltec.edu               ET-336

 

Academic Advisor

Chrislyn Hallums                 250-8273       chrislyn.hallums@gvltec.edu            ARC-410

 

Counselor

Dianne Granger Morris        250-8135         dianne.grangermorris@gvltec.edu     ET-120

 
Information

Greenville Technical College           250-8111

 

 

 

TUTORING RESOURCES

 

Math Center               Contact: Leigh Ann Wheeler            UT-104           250-8169

 

Writing Center           Contact: Robert Clardy                     UT-114           250-8571

 

 

 

Students with Disabilities:

 

All students who have a disability and need accommodations should visit, call or email Student Disability Services.  The office is located in the Student Center, Room 124 and can be reached by phone at 250-8202 or 250-8408 or by email at sharon.bellwood@gvltec.edu.  The disability service counselor is available to meet with students on satellite campuses by appointment. 

 

 

 

POLICY ON NONDISCRIMINATION

 

Greenville Technical College is committed to a policy of nondiscrimination involving equal access to education and employment opportunity to all, regardless of sex, race, age, religion, color, national origin or disability.  The college complies with the provisions of Titles VI and VII of the Civil Rights Act of 1964, as amended; Title IX of the Education Amendments of 1972 and the Higher Education Amendments of 1986; Sections 503 and 504 of the Rehabilitation Act of 1973; the South Carolina Human Affairs Law of 1972; and with the Americans with Disabilities Act (ADA) of 1990.  For assistance in these areas, contact Jackie Bradham, the college’s 504 and Title IX coordinator for students, at 250-8176 v/TDD or Helen Clarkson, ADA coordinator, at 250-8191.