GIS642 Database Design and Administration (3 cr.)

Prerequisite(s): GIS605   or equivalent
This course follows a logical progression through basic data and database concepts into design theories, creation, and implementation of an enterprise spatial database. The course explores the role of various tabular structures, from simple flat files to the relational geodatabase. 

Upon completion of the course students are expected to be able to do the following:

1. Demonstrate knowledge of database terminology, design techniques, and data issues.
2. Collect, format, manage, and implement both spatial and tabular data within a GIS.
3. Design and develop geodatabases that promote data integrity and usability.
4. Demonstrate a basic knowledge of relational database management systems such as SQL Server and ArcSDE.
5. Use basic standard query language to manage and query databases.