DIGA610 Relational Database Design and Administration (3 cr.)

Prerequisite(s): DIGA605  
This course follows a logical progression from basic data types into normalization and relational database design.  The course explores the role of various tabular structures, from simple flat files to the relational database.  The course explores implementing methods to promote spatial and tabular data integrity and facilitate analytical workflows. Standard query language (SQL) for querying, modifying, and managing data is also covered. The course includes enterprise geodatabase topics such as permissions, versioning, replication, and archiving.

Upon completion of this 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.
5. Use basic standard query language to manage and query databases.
6. Plan and implement databases to meet specifications of various stakeholders.