GIST 8132
GIS Database Systems 2
| School | School of Construction and the Environment |
|---|---|
| Program | Geographic Information Systems (GIS) |
| Course Credits | 3 |
| Minimum Passing Grade | 50% |
| Start Date | January 08, 2018 |
| End Date | March 26, 2018 |
| Total Hours | 45 |
| Total Weeks | 12 |
| Hours/Weeks | 3.75 |
| Delivery Type | Other |
| Prerequisite(s) | GIST 7132 |
| CRN | 71718 |
Acknowledgement of Territories
The British Columbia Institute of Technology acknowledges that our campuses are located on the unceded traditional territories of the Coast Salish Nations of Sḵwx̱wú7mesh (Squamish), səl̓ilwətaɁɬ (Tsleil-Waututh), and xwməθkwəy̓əm (Musqueam).
Instructor Details
| Name | Mike Hill |
|---|---|
| Instructor to provide | |
| Location | SW3 2079 |
| Office Hours | Instructor to provide |
Course Description
Develops skills for using database software with GIS. Topics include the Oracle RDBMS architecture, ArcGIS Enterprise Geodatabase architecture, Database Versioning and GIS database Web server programs.
Course Learning Outcomes/Competencies
Upon successful completion, the student will be able to:
- Describe the Oracle database server architecture.
- Create and query Oracle tables.
- Use utilities and scripts to import and export data from Oracle.
- Write web server-side scripts to display database tables over the web.
- View spatial data stored in Enterprise Geodatabase.
- Load vector and raster data into Enterprise Geodatabase.
- Create and reconcile database versions.
Learning Resources
Required:
· Oracle & ArcGIS computer texts change frequently. The most up-to-date information will be found on-line.
· Reference Material: See Internet URLs listed in the on-line course notes.
Evaluation Criteria
|
Component |
Total Allocated (%) |
Individual Elements |
Element Percent (%) |
|
Assignment |
40% |
9 assignments If an assignment is dropped (not given), then the weighting for that assignment is equally distributed amongst all of the completed lab assignments. |
Asgmt 1: 10% of 40% Asgmt 2 10% of 40% Asgmt 3: 10% of 40% Asgmt 4: 10% of 40% Asgmt 5: 20% of 40% Asgmt 6: 10% of 40% Asgmt 7: 10% of 40% Asgmt 8: 10% of 40% Asgmt 9: 10% of 40% |
|
Exam |
60% |
Midterm Exam Final Exam |
Midterm: 30% Final: 30% |
|
Components Passed |
Academic Transcript Shows |
|
assignments and exams |
Your overall % given. Course credit. |
|
assignments or exams but not both |
49F - if your overall % is 50% or greater. No course credit. |
|
%F - if your overall % is less than 50%. No course credit. |
|
|
none |
%F - your overall % is given. No course credit. |
Attendance Requirements
Assignments must be completed by the due date and time.
Late assignments will receive zero marks. Exceptions may be made due to illness or personal situations.
It is the responsibility of the student to inform the instructor of any extenuating circumstances.
Course Schedule and Assignments
As specified on Desire2Learn (see content, quizzess and dropbox dates).
BCIT Policy
The following statements are in accordance with the BCIT Policies 5101, 5102, 5104, and 7507, and their accompanying procedures. To review these policies and procedures please click on the links below.
Attendance/Illness:
In case of illness or other unavoidable cause of absence, the student must communicate as soon as possible with his/her instructor or Program Head or Chief Instructor, indicating the reason for the absence. Students who are seeking accommodation for a medical absence must have a BCIT approved medical certificate submitted to the department, substantiating the reason for absence. For other absences, the student should be prepared to provide appropriate supporting documentation. Unapproved absence in excess of the prescribed regulations within this outline may result in failure or forced withdrawal from the course or program. Please see Policy 5101 - Student Regulations, and accompanying procedures.
Academic Integrity:
Violation of academic integrity, including plagiarism, dishonesty in assignments, examinations, or other academic performances are prohibited and will be handled in accordance with Policy 5104 - Academic Integrity and Appeals, and accompanying procedures.
Accommodation:
Any student who may require accommodation from BCIT because of a physical or mental disability should refer to BCIT's Policy on Accommodation for Students with Disabilities (Policy #4501), and contact BCIT's Disability Resource Centre (SW1 2360, 604-451-6963) at the earliest possible time. Requests for accommodation must be made to the Disability Resource Centre, and should not be made to a course instructor or Program area.
Any student who needs special assistance in the event of a medical emergency or building evacuation (either because of a disability or for any other reason) should promptly inform their course instructor(s) and the Disability Resource Centre of their personal circumstances.
Human Rights, Harassment and Discrimination:
The BCIT community is made up of individuals from every ability, background, experience and identity, each contributing uniquely to the richness and diversity of the BCIT community as a whole. In recognition of this, and the intrinsic value of our diversity, BCIT seeks to foster a climate of collaboration, understanding and mutual respect between all members of the community and ensure an inclusive accessible working and learning environment where everyone can succeed.
Campus Mediation Services is a supportive resource for both students and employees of BCIT, to foster a respectful learning and working environment. Any student who feels that they are experiencing discrimination or harassment (personal or human rights-related) can confidentially access this resource for advice and support. Please see Policy 7507 – Harassment and Discrimination and accompanying procedure.
Students should make themselves aware of additional Education, Administration, Safety and other BCIT policies listed at https://www.bcit.ca/about/administration/policies.shtml
Guidelines for School of Construction and the Environment
Attempts:
Students must successfully complete a course within a maximum of three (3) attempts at the course. Students with two attempts in a single course will be allowed to repeat the course only upon special written permission from the Associate Dean. Students who have not successfully completed a course within three attempts will not be eligible to graduate from their respective program.
Approved
I verify that the content of this course outline is current.
Mike Hill, Instructor
January 05, 2018
I verify that this course outline has been reviewed.
Carmen Heaver, PTS Coordinator
January 05, 2018
I verify that this course outline has been reviewed and complies with BCIT policy.
Dave Rutherford, Associate Dean
January 07, 2018
Note: Should changes be required to the content of this course outline, students will be given reasonable notice.