Niagara College Toronto

Computer Programing
Semester 2

Teaching and Learning Plan

COURSE INFORMATION

Course Title Contemporary Storage Systems Course Code PROG1870

Programming
Requisites/Restrictions (PROG1735 - Database Credit Value 4
Essentials OR
BTGD9101 - Database
Essentials) AND
(PROG1195 - Programming
Essentials OR
BTGD9103 - Programming
Essentials OR
COMP1268 - Scripting and
Automation OR
PROG1124 - Software
Development)
Delivery Type In-Person
Program Coordinator Subagini Manivannan Program subagini.manivannan@ni
Coordinator agaracollegetoronto.ca
Contact
Developed by Indranath Banerjee Approved by Subagini Manivannan

COURSE OUTLINE
Course Outline | Niagara College Canada
COURSE DESCRIPTION
As trends toward integrating smart devices, social media, and streaming technologies increases,
so too does the volume, velocity, and variety of an organization's data. In this course, you will
explore how various databases scale and flex to accommodate these types of semi-structured,
sparse, and/or massive data sets - from document-oriented data, to data that are best organized in
column families, key-value pairs, or for predictive analysis. In this course, students will learn how
to work with several NoSQL databases, and they will learn how to use a relational database's
platform to extract, load, and transform data into a NoSQL environment. By the end of the course,
students will be able to match various business problems to their best and most fitting database
solutions.
LEARNING OUTCOMES
Upon successful completion of this course, the student has reliably demonstrated the ability to:
Select an appropriate database solution for a given business problem
1.
2. Perform extraction, transform, and load (ETL) operations using a relational database

3. Organize and maintain various NoSQL data stores

4. Analyze large sets of data

LEARNING RESOURCES
Type Author Title Publisher ISBN Edition URL, Other
Required texts,
resources and No Resource Information has been defined for this course.
materials
https://www.amazon.ca/SQ
Supplemental/ Michael SQL and Springer 978- Second L-Nosql-Databases-
Architectures-
Recommended Kaufma Nosql 303127 Management/dp/30312790

Resources nn, Databases: 9072 77/ref=sr_1_fkmr3_1?key

words=Enhancing+Availab
Andreas Modeling, ility+for+NoSQL+Databas
e+Systems+using+Failover
Meier +Techniques&linkCode=gs
Languages, 3&qid=1677609268&sr=8-
1-fkmr3
Security and
Architectures
for Big Data
Management
Recommended DataStax – Cassandra - DB
Software DataStax | NoSQL Database Built on Apache Cassandra | DataStax
Applications
Aura DB
Fully Managed Graph Database Service | Neo4j AuraDB
EVALUATION DETAILS
Number Percentage of
Type of Evaluation/Assessment
Final Grade
1. Labs:
Lab 1 – 5% Week 4,
Lab 2 – 10% Week 6, 25%
Lab 3 – 5% Week 10,
Lab 4 – 5% Week 11
2. Quizzes:
Quiz 1 – 5% Week 5, 10%
Quiz 2 – 5% Week 9
3. Hands-On-Tests:
Test 1 – 20% Week 7, 40%
Test 2 – 20% Week 15
4. Final Project – Week 12 – 25%
25%
Total
100%

STANDARD COURSE PLAN

Topic /Theme/Chapter Assessments and Learning Objectives

Activities
Week

Week 1 ▪ Introduction Session Hands-On Lab on Intro – Students will learn

▪ Icebreaker Activity and Canvas about the LMS - Canvas
self-introduction
▪ Explore LMS(Canvas)
features, learn to
communicate with
instructors and peers
through Canvas
▪ Familiarize with the TLP:
Introduction to the
learning objectives and
outcome, Familiarize with
the evaluation methods
and weightage
▪ Basic definitions related
to the subject
 Topic /Theme/Chapter Assessments and Learning Objectives
Activities
Week

Week 2 ▪ Analyzing the nature of Discussion on 1. Select an appropriate

organization’s data. Organization’s Data database solution for a
▪ Integrating smart devices, Analysis and given business problem
Social Media, Streaming Business Cases 1.1 Analyze the
Technology. nature of an
▪ Accommodating organization’s data
dynamically changing
data (volume, velocity 1.2 Research the
and variety). kinds of problems
▪ Understanding the Data that a business case
Integration problem as needs to solve
different departments
store data in different
databases and software.
▪ Finding a Solution to
integrate scattered data for
Trend and Predictive
Analysis.
Week 3 ▪ Characterizing the types Group Work on 1. Select an appropriate
of outputs required within Understanding DB database solution for a
the business context characteristic and given business problem
▪ Understanding how how they Scale and
different Databases Scale 1.3 Characterize
Flex
and Flex to accommodate the types of
dynamically changing outputs required
data. within the business
▪ Gathering the semi context
structured , sparse or
massive Dataset and
changing them to the
following format:-
▪ Key Value Pair
▪ Column Based
▪ Document Based
▪ Graph Based
Week 4 ▪ Comparing the Relational Lab 1(5%) 1. Select an appropriate
vs Non Relational No- database solution for a
SQL architectures. Discussion on given business problem
▪ Understanding the ACID different
property for RDBMS and characteristics of 1.4 Compare
BASE Property for NO – Relational and Relational and
SQL Architectures.
 Topic /Theme/Chapter Assessments and Learning Objectives
Activities
Week

▪ Comparing the NOSQL DB various No-SQL

Consistency and architectures architectures
Availability features of
RDBMS with NO SQL
▪ Understanding the
concept of Horizontal and
Vertical Scaling
Week 5 ▪ Understanding Quiz 1 (5%) 2. Perform extraction,
Operational Data, transform, and load (ETL)
Workflow and Scrub. Lecture on ETL and operations using a
▪ Creating SSIS flat file how to transfer raw relational database
connection data into DB 2.1 Transfer data
▪ Connecting Flat File to structural format via in import and
ADO.Net Destination Import export routines that
▪ Successfully Transferring use wizards or
the data from Flat File scripts
(.CSV) to SSIS and
exporting it to SQL 2.2 Reorganize
Server to reorganize its data structures
data structure
Week 6 ▪ Deriving the column Lab 2 (10%) 2. Perform extraction,
Using the Transformation transform, and load (ETL)
Editor inside SSIS Midterm Review operations using a
▪ Making Sure that the Flat and Lecture on ETL relational database
File Source is connected outcomes
to the Derived Column 2.3 Apply data
which is further connected conversion
to ADO . NET routines
Destination
▪ Applying Data 2.4 Investigate the
Conversion Routines outcomes of ETL
▪ Investigating the ETL operations
operation’s successful
outcome
Week 7 Hands-on Test 1 Midterms - Hands-
on Test 1 – (20%)
Week 8 Reading Week (No
Classes)
Week 9 ▪ Designing Logical Quiz 2 (5%) 3. Organize and maintain
schema to fit a business various NoSQL data stores
problem via ER Diagram.
 Topic /Theme/Chapter Assessments and Learning Objectives
Activities
Week

▪ Creating a Data base with Lecture and

Tabular and Document, Discussion on
Key Value Pair and Graph 3.1 Design logical
creating physical
based Key space. schemas to fit a
schemas from business problem
▪ Creating Column Based logical schemas
and JSON Doc based
Schema. 3.2 Create physical
▪ Creating Key-value Pair stores from logical
Based and Graph Based schemas
Schema.
Week 10 ▪ Inserting Into Table Lab 3 (5%) 3. Organize and maintain
Values various NoSQL data stores
▪ Managing JSON taken Discussion on how
▪ Inserting into JSON doc to populate physical 3.3 Populate
values , Graph based data stores and physical stores
values and Key-Value query data stores with data
pair Values
▪ Querying different data 3.4 Query data
stores to retrieve data stores using a
values using High level variety of high-
Query language level languages
Week 11 ▪ Producing a NOSQL Lab 4 (5%) - 3. Organize and maintain
solution for LAN and various NoSQL data stores
cloud architecture Lecture on
▪ Creating a profile in DataStax providing 3.5 Produce
DataStax the solution for both NoSQL solutions
▪ Using Cassandra Query LAN and Cloud for LAN and
Language – CQL for Environment Cloud architectures
Supporting all 4 Types of
DB ( Column Based,
Graph based , Key –
Value Pair , JSON Doc )
▪ Understanding how
DataStax Cassandra
supports all 4 Types for
No SQL Architectures in
Cloud.
Week 12 ▪ Using SQL Server Final project 4. Analyze large sets of
Management Studio and (25%) data
DB Engine create 1-D and
2-D structures.
 Topic /Theme/Chapter Assessments and Learning Objectives
Activities
Week

▪ Using BI Intelligence Lecture on Creating 4.1 Create one-

Analyze Large Data Set and Analysing 2 D and two-
▪ Understanding semi- structures dimensional
structured, sparse, and/or structures
massive data sets
▪ Using Analysis Services
Analysing
Multidimensional and
Data Mining models
Week 13 ▪ Implementing Data Discussion on 4. Analyze large sets of
Science methods to clean Cleansing and data
and query data Querying Data
▪ Inspecting data for 4.2 Implement
missing values, Data Science
Inconsistency , methods to clean
Duplication etc. and query data
▪ Profiling data for
cleaning, verification and
reporting
▪ Querying data
Week 14 ▪ Investigating the future Final Review 4. Analyze large sets of
trends in Data. data
▪ Understanding Data
warehouse. 4.3 Investigate
▪ Understanding how AI trends in data
can help in
Datawarehouse
Management and
Outsourcing.
▪ Understanding Hadoop
Integration.
Week 15 Hands-on Tests 2 Hands-on Tests 2
(20%)
 POLICIES AND REGULATIONS
ACCOUNTABILITY & RESPONSIBILITY
Accountability includes completing all assignments on time and as requested, taking responsibility
for one’s actions, and assuming a pro-active approach to the course. It does not include making
excuses or forcing the instructor to follow-up on issues. Online learning, if applicable, requires
considerable self-discipline. It is strongly recommended that you view your online courses as
having a workload comparable to courses taught on campus.
Refer to Canvas under each chapter for Homework Assignments and Assignments pertaining to a
particular class.
Late or missed assignments maybe be accepted at the discretion of the instructor under the
College’s Practice for Missed or Late Assignments (see relevant section below for details).
All evaluations, assignments and quizzes are included in the final course grade calculations.
E-MAIL COMMUNICATION
All students are required to check their official student e-mail account regularly. E-mail
is the official route of communication between the College and its students.

ACADEMIC INTEGRITY
Students are subject to the College’s Practice on Student Academic Misconduct and should
therefore be aware of what constitutes academic misconduct and its consequences. Student
academic misconduct is a serious offence and will not be tolerated. It may take many forms and
not limited to, plagiarism, copying another student’s work or allowing others to copy one’s own
work, the use of unauthorized aids in assignments or examinations, falsifying identity and logging
into another student’s account, submitting substantially the same academic assessment work in
two or more courses without faculty permission, unauthorized group work for an individually
assigned assignment, the willful distortion or fabrication of experimental results or data, and the
use of generative artificial intelligence (AI), such as ChatGPT or other, to help complete any of
your work in this course.
If you are unsure of what constitutes academic integrity infringements such as plagiarism or others,
or you do not know whether an online resource or tool can be used in this course, you can seek
assistance from your instructor, program coordinator, academic advisors, or the library staff. You
can also refer to the library resources link Academic Integrity Introduction: NCT Library
(niagaracollegetoronto.ca).
Students agree that by taking this course all submitted assignments/papers may be reviewed by
Turnitin for textual similarity in support of academic integrity. All submitted assignments/papers
will be included as source documents in the Turnitin reference database solely for the purpose of
detecting plagiarism of such papers. Use of the Turnitin service is subject to the Usage Policy
posted on the Turnitin.com website. Students also agree that all the submitted assignment/papers
may be checked for any AI-produced material using AI detection tools and software.
CITATION
Students are expected to use proper citations techniques when submitting assignments. Citations
help students to avoid accusations of plagiarism and demonstrates a writer’s integrity and ability
to engage in a formal scholarly work. The College adopts the APA citation style (APA 7th Edition
https://apastyle.apa.org/) which was created by the American Psychological Association. In APA,
you must "cite" sources that you have paraphrased, quoted or otherwise used to write your work.
Cite your sources in two places:

• In the body of your assignment/paper where you add a brief in-text citation.
• In the Reference list at the end of your paper where you give more complete information
for the source.

CLASS CANCELLATION OR RESCHEDULING

On occasion, it may be necessary to cancel or reschedule a class. College Practice on Class
Cancellation and Rescheduling provides details on what students can expect in the event of a
change to a regularly scheduled class meeting.
STUDENT CLASS ATTENDANCE AND LATENESS
Students are responsible for understanding the College Practice on Attendance and Lateness and
are advised that unless they participate in course activities, it is unlikely that they will be able to
progress satisfactorily.

MISSED OR LATE ASSIGNMENTS

When you find yourself unable to meet an in-course requirement because of illness or
compassionate reasons, please fill out the Academic Consideration Request Form that can be found
in each course and send the form to the faculty teaching the course. Late assignments without
notice will be graded based on the following Late Submission penalty:

• 10% deduction of the assignment will apply for each day passed the assignment due date
until Day 7.
• Late submission passed Day 7 will automatically receive a zero grade.

ACADEMIC STANDING AND PROGRESSION

To progress to the next level of program study, a student must achieve all the following:

• A passing grade in a course is 50%

• A semester Grade Point Average of 60%
• Successful completion of prerequisite and/or co-requisite course(s) if applicable
 • Successful completion of mandatory course and/or semester requirements (such as non-
academic requirements among others) as determined by the program.
ACCESSIBILITY
The College is committed to the provision of an open and supportive learning environment. If you
are a student with a disability, please remember that it is your responsibility to contact Health,
Wellness and Accessibility Services (HWAS) and/or the Accessibility Consultant and provide
documentation pertinent to your disability. The earlier you ask for assistance, the more effective
we can be in facilitating the appropriate support. Do not wait until you are experiencing serious
difficulties to contact the above resources.
USEFUL LINKS AND RESOURCES
The contacts below may provide useful resources and information that support your academic and
overall progress as a student, don’t hesitate to reach out if you require any help or support:
• Academic Integrity Introduction: NCT Library (niagaracollegetoronto.ca)
• IT Issues and Support: support@nctorontostudents.ca
• Health Wellness Department: hwas@niagaracollegetoronto.ca
• Accessibility Consultant: accessibility@niagaracollegetoronto.ca
• Student Advising: academicadvising@niagaracollegetoronto.ca
• Career Services: NCT Career Services -1 (niagaracollegetoronto.ca)
• Library Services: NCT Library (niagaracollegetoronto.ca)
• Student Orientation: BE NCT Ready (niagaracollegetoronto.ca)