Course details
This course is an introduction to databases, their terminology and an overview of various data models and modelling techniques. Topics include relational database design, Codd's rules, constraints, relationships, normalization, and the structured query language (SQL). Examples will be GIS-based, use an ORDBMS for storage and web-based customizations.
Prerequisite(s)
- 50% in GIST 7010† († may be taken concurrently)
Credits
3.0
- Not offered this term
- This course is not offered this term. Please check back next term or subscribe to receive notifications of future course offerings and other opportunities to learn more about this course and related programs.
Learning Outcomes
Upon successful completion, the student should be able to:
- Navigate the ORDBMS graphical user interfaces.
- Import and export various data formats.
- Normalize data into the first, second and third normal forms.
- Compare the hierarchically, network and relational database models.
- Read and create data models.
- Create database queries using the Structure Query Language (SQL).
- Create application that integrate ORDBMS libraries.
- Create Forms and Reports for an ORDBMS.
Effective as of Fall 2008
Related Programs
GIS Database Systems 1 (GIST 7132) is offered as a part of the following programs:
School of Construction and the Environment
- Geographic Information Systems
Advanced Diploma Full-time
- Geographic Information Systems
Advanced Diploma Part-time
- Geographic Information Systems
Bachelor of Technology Full-time/Part-time
Subscribe
Interested in being notified about future offerings of GIS Database Systems 1 (GIST 7132)? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.
Programs and courses are subject to change without notice.