GIST 2120 Geographic Information System Databases
This course presents and introduction to the structure and use of geodatabases. Topics include general database theory; and the creation, editing, and management of relational databases and geodatabases. Prerequisites: Completion of GIST 1200, GIST 2310 and GIST 2410. (3 lect.)
Major Topics
- Fundamentals of Relational Databases
- Layout and Creation of Relational Databases
- Techniques in Database Querying
- Techniques for Optimizing Relational Databases
Outcomes
In order to successfully complete this course, the student will:
1. Describe different types of databases; differentiate the appropriate usages of the database types; examine a database schema; express the various table keys; describe the relationship types
2. Model the database design through the use of entity relationship diagrams (ERD's); create a relational database; create the schema for a relational database; import data into the relational database management
3. Summarize structured query language (SQL) query syntax and the fundamental statements; query a database using SQL statements; discuss and perform advanced queries such as perimeter and crosstab to extract information from a database
4. Describe and apply normalization techniques to a relational database; establish database keys and relationships in a relational database; enhance table design through the use of lookup fields, input masks and validation rules; create pivot tables and pivot charts; perform inner and outer joins between tables