GIS 314 Databases II

School of Environment and Geomatics

GIS 314 Database II. This course is a continuation of Database Systems I, and will cover relational database geodatabase skills using mainly Microsoft Access and ESRI Geodatabases with ArcSDE and a PostgreSQL backend. The purpose of this course is to introduce both conceptual and practical aspects of designing and developing both a database and a geodatabase. The course will provide an overview of some design methodologies and models. Following this overview, the course will cover database and geodatabase design and implementation using Access/Geodatabases and optionally ArcSDE on top of PostgreSQL.

Prerequisites: GIS 313 with a minimum grade of 60%

Accessibility Services Notice

Students who would like an academic accommodation and who have a documented disability should contact Accessibility Services, if they have not already done so.

Transfer Agreements

Course to Course transfer – NoBlock Transfer – Nobctransferguide.ca
Course Details
Total number of weeks15
Total Credits
Total Hours45
Typical hours per week breakdown
Lecture3

Learning Outcomes

Upon successful completion of this course, the learner will be able to:

  1. Design Database
  2. Creating E-R diagrams
  3. Access proficiency
  4. Designing databases and geodatabases
  5. Loading and manipulating data through ArcSDE via PostgreSQL
  6. Building projects in ArcSDE
  7. Loading a database and querying
  8. Database project management
  9. Use standard SQL and PostGIS for geoprocessing
  10. Loading
  11. Manipulating
  12. Geodatabase creation/manipultion
  13. ArcSDE
  14. PostGIS
  15. Entity Relationships
  16. Data desing/dictationaries
  17. Attribute subtypes and domains

Grading Table

Standard Academic and Career Programs Grading Table

PercentageLetter GradeGPA
90-100A+4.33
85-89A4.00
80-84A-3.67
76-79B+3.33
72-75B3.00
68-71B-2.67
64-67C+2.33
60-63C2.00
55-59C-1.67
50-54P1.00
0-49F0.00
DNW0.00



See the Academic Calendar for General Information including how to withdraw from course(s) and other regulations.

Disclaimer

Information contained in this course outline is correct at the time of publication. Content of the course is revised on an ongoing basis to ensure relevance to changing educational, employment and market needs. The instructor will endeavor to provide notice of changes to students as soon as possible. The instructor reserves the right to add or delete material from courses.