| Searching Current Courses For Fall 2016 |
|
Course: |
GIS 150
|
|
Title: | Relational Database Mgmt |
|
Long Title: | Relational Database Management for Geographic Information Systems |
|
Course Description: | Develop methods and procedures for geographic information systems data, data management, and the complex relationships between data files and a GIS. This course teaches several essential components and methods of successful data and project data management. The objective is to give students a basic understanding of databases, how they are used in a professional GIS environment, and practical experience in designing and implementing the GIS database portion of a GIS. |
|
Min Credit: | 3 |
|
Max Credit: | |
|
Origin Notes: | FRCC |
|
General Notes: | revised-ttl,dscrptn,cmptncs,outln 5/16/12 LK |
STANDARD COMPETENCIES:
1. Characterize essentials of data, data base mechanics and organization, storage, and metadata
2. Select data models - hierarchical model, network model, relational model, object model
3. Develop spatial data models - raster models, vector models
4. Explore relational data - structure of a relational database, matching data, archiving/retrieval
5. Manage and organize spatial and attribute data, connect independent data, relate various file types and manage the database.
6. Characterize methods of geographic data layers, partitioning data, and classifying data
7. Apply spatial editing and querying, editing attribute files and attribute query functions
8. Identify data quality and integration problems associated with geospatial and attribute data acquired with legacy systems and processes
9. Assess data quality
10. Develop conceptual, logical, and physical models of a geospatial database designed in response to user requirements
TOPICAL OUTLINE:
I. Introduction
II. Database Systems
III. Data Models / Design Concepts
IV. Entity relationship modeling
V. SQL
VI. Advanced SQL
VII. Creating Geodabases
VIII. Working with Geodatabases
IX. Domains
X. Querying Geographic Data
XI. Relationships and Joins
XII. Field Manipulations
XIII. Geocoding
|
Front Range Community College |
FRCC |
|
Pikes Peak State College |
PPCC |
Skip to top of page