Database II

Curriculum Guideline

Effective Date:
Course
Discontinued
No
Course Code
CSIS 3300
Descriptive
Database II
Department
Computing Studies & Information Systems
Faculty
Commerce & Business Administration
Credits
3.00
Start Date
End Term
202030
PLAR
No
Semester Length
15 Weeks
Max Class Size
35
Contact Hours
Lecture: 2 Hours per week Seminar: 2 Hours per week Total: 4 Hours per week
Method(s) Of Instruction
Lecture
Seminar
Learning Activities

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

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.
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.
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).

Textbook Materials

Instructor compiled materials

and/or

other textbooks as approved by the department

Prerequisites

Min grade C in CSIS 2300