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
201820
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

The 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/Projects (Minimum: 3)     25% - 45%
Participation 0% - 5%
Tests/Quizzes (Minimum: 2) 10% - 40%
Final Examination 25% - 30%
Total 100%
Textbook Materials

Raghu Ramakrishnan and Johannes Gehrke. Database Management Systems, 3rd Edition,
McGraw-Hill, current version

and

Instructor compiled materials (if applicable)

or

other textbooks as approved by the department

Prerequisites

CSIS 2300 or CISY 2300