Database II

Faculty
Commerce & Business Administration
Department
Computing Studies & Information Systems
Course Code
CSIS 3300
Credits
3.00
Semester Length
15 Weeks
Max Class Size
35
Method Of Instruction
Lecture
Seminar
Typically Offered
To be determined
Campus
Online

Overview

Course Description
This course will continue on from CSIS 2300 exploring advanced features of database systems. Topics covered will include indexing; query processing and optimization; transaction processing; denormalization; star schema; DW/OLAP cubes; security. NoSQL and MapReduce will also be covered.
Course Content
  1. Course overview and review of database fundamentals;
  2. Working with DB indexes;
  3. Introduction to query processing and optimization;
  4. Query optimization case studies;
  5. Working with DB transactions;
  6. Denormalizing a DB - why, when, and how;
  7. Introduction to dimensional modeling;
  8. Designing a star schema;
  9. Working with DW/OLAP cube;
  10. Introduction to noSQL databases;
  11. CRUD operations in noSQL;
  12. Analytics in noSQL (MapReduce);
  13. Securing a database system.
Methods Of Instruction

Lecture, seminar and hands-on exercises in the lab.

Means of Assessment
   
Assignments/Project:    10% - 25%
Quizzes (Minimum 2) 10% - 20%
Midterm exam  20% - 30%
Final Exam * 30% - 40%
Total 100%

Some of the assessments may involve group work.

* Practical hands-on computer exam

In order to pass the course, students must, in addition to receiving an overall course grade of 50%, also achieve a grade of at least 50% on the combined weighted examination components (including quizzes, tests, exams).

Learning Outcomes

At the end of this course, the successful student will be able to:

  1. Explain the purpose of indexing;
  2. List different types of indexes;
  3. Evaluate and explain when to use an index on a column;
  4. Describe how a SQL query is processed by the DB engine;
  5. Generate a more efficient query which reduces resource consumption but provides same data results;
  6. Explain situations when DB transactions should be used;
  7. Plan a set of queries which could be executed as part of a transaction - including both the success and failure scenarios;
  8. Describe why and when denormalization is beneficial for a DB system;
  9. Execute the denormalization process;
  10. Design a star schema;
  11. Use a DW/OLAP cube to extract information from data;
  12. Use a noSQL DB to perform CRUD (Create, Retrieve, Update, Delete) operations;
  13. Demonstrate application of MapReduce functions;
  14. Describe common DB security issues and their solutions.
Textbook Materials

Instructor compiled materials

and/or

other textbooks as approved by the department

Requisites

Prerequisites

Min grade C in CSIS 2300 

Corequisites

No corequisite courses.

Equivalencies

No equivalent courses.

Requisite for

This course is not required for any other course.

Course Guidelines

Course Guidelines for previous years are viewable by selecting the version desired. If you took this course and do not see a listing for the starting semester / year of the course, consider the previous version as the applicable version.

Course Transfers

Institution Transfer Details Effective Dates
Alexander College (ALEX) ALEX CPSC 2XX (3) 2015/01/01 to -
Athabasca University (AU) DOUG CSIS 2300 (3) & DOUG CSIS 3300 (3) = AU COMP 378 (3) & AU COMP 3XX (3) 2015/01/01 to -
Athabasca University (AU) DOUG CSIS 2300 (3) & DOUG CSIS 3300 (3) = AU COMP 378 (3) & AU COMP 3XX (3) 2015/01/01 to -
Coquitlam College (COQU) No credit 2015/01/01 to -
Kwantlen Polytechnic University (KPU) KPU INFO 2XXX (3) 2019/05/01 to -
Langara College (LANG) LANG CSIS 2XXX (3) 2015/01/01 to -
Okanagan College (OC) No credit 2015/01/01 to -
Simon Fraser University (SFU) No credit 2015/01/01 to -
Thompson Rivers University (TRU) TRU COMP 3610 (3) 2015/01/01 to -
Trinity Western University (TWU) No credit 2019/05/01 to -
University Canada West (UCW) UCW CPSC 3XX (3) 2006/01/01 to 2014/12/31
University Canada West (UCW) No credit 2015/01/01 to -
University of British Columbia - Okanagan (UBCO) UBCO COSC 3rd (3) 2015/01/01 to -
University of British Columbia - Vancouver (UBCV) UBCV CPSC 2nd (3) 2015/01/01 to -
University of Northern BC (UNBC) UNBC CPSC 3XX (3) 2015/01/01 to -
University of Victoria (UVIC) UVIC CSC 2XX (1.5) 2015/01/01 to -
Vancouver Community College (VCC) No credit 2015/01/01 to -

Course Offerings

Fall 2020

CRN
Days
Dates
Start Date
End Date
Instructor
Status
Location
35023
Tue
08-Sep-2020
- 07-Dec-2020
08-Sep-2020
07-Dec-2020
Bhardwaj
Nikhil
Waitlist
Online
This course will include synchronous on-line activities. Students should plan to be available on-line at scheduled course times.
Max
Enrolled
Remaining
Waitlist
35
35
0
10
Days
Building
Room
Time
Tue
9:30 - 12:20
CRN
Days
Dates
Start Date
End Date
Instructor
Status
Location
35581
Fri
08-Sep-2020
- 07-Dec-2020
08-Sep-2020
07-Dec-2020
Bhardwaj
Nikhil
Waitlist
Online
This course will include synchronous on-line activities. Students should plan to be available on-line at scheduled course times.
Max
Enrolled
Remaining
Waitlist
35
35
0
10
Days
Building
Room
Time
Fri
9:30 - 12:20