Course Overview
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
Domestic fees
$881.16
International fees are typically 3.4 times the domestic tuition. Exact cost will be calculated upon completion of registration.
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:
- Indicates programs accepting international students.
- Indicates programs eligible for students to apply for Post-graduation Work Permit (PGWP).
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
Course Offerings
Fall 2026
Below is one offering of GIST 7132 for the Fall 2026 term.
CRN 34251
Dates
Sep 10 - Nov 26 Loading
- CRN 34251
- $881.16 Domestic fees
Class meeting times
| Dates | Days | Times | Locations |
|---|---|---|---|
| Sep 10 - Nov 26 | N/A | N/A | Online |
Duration
12 weeks
Instructor
Rob Hewlett
Course outline
Course outline TBD — see Learning Outcomes in the interim.
Important information
- For more information about online courses at BCIT, please visit: www.bcit.ca/distance/foryou.shtml Students must check your my.bcit.ca e-mail account for start-up instructions sent upon registration of this course. To be successful in our online courses, plan to spend 4-6 hours per course each week on your studies, starting Week 1. Our courses are highly interactive with participation requirements weekly. Most of our online learning courses require a textbook. You can search for your course textbook at : www.bcitbookstore.ca/distance/ If no textbook is listed, course material will be provided via e-mail.
Confirmation
Required
To proceed with registration and add this course to the cart, please confirm:
Status
If you have any questions about this course, please contact us.
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.