Niagara College Toronto
Computer Programming
Semester-2
Teaching and Learning Plan
COURSE INFORMATION
Course Title Client Course PROG1198
Server Web Code
Solutions
Requisites/Restrictions (PROG1735 Credit 3
- Database Value
Essentials
OR
BTGD9101
- Database
Essentials)
Delivery Type In-Person
Program Manager Subagini Program subagini.manivannan@niagaracollegetoronto.ca
Manivannan Manager
Contact
Developed by Indranath Approved Subagini Manivannan
Banerjee by
COURSE OUTLINE
Course Outline | Niagara College Canada
COURSE DESCRIPTION
In this course students build on the database design, development and programming techniques
learned in previous courses, to develop integrated client/server applications. The students will
create and manage databases, program database objects in SQL Server, and incorporate them
into a client application using Universal Windows Platform (UWP).
LEARNING OUTCOMES
Upon successful completion of this course, the student has reliably demonstrated the ability to:
1. Design and implement the relational database structure required to maintain the data for a
given business application and translate it into an appropriate physical database design.
2. Create appropriate Views, Triggers, Stored Procedures and User-Defined Functions to
support enterprise development of multiple client interfaces
3. Design and implement basic Universal Windows Platform applications.
4. Develop integrated data-driven applications such using SQL Server and UWP.
LEARNING RESOURCES
Type Aut Title Publ ISBN Edi URL, Other
hor isher tio
n
Required texts, No Resource Information has been defined for this course.
resources and
materials
Supplemental/ Ben T-SQL Micr 978- 3rd https://www.amazon.ca/T-SQL-
Recommended - Funda osoft 15093 Fundamentals-Itzik-Ben-Gan-
Resources Ga mental Press 02000 ebook/dp/B01J89I7PI/ref=sr_1_4?crid
n s =1M1DHLKX0KIUN&keywords=t-
Itzi sql+fundamentals&qid=1677867939&
k s=digital-text&sprefix=T-
sql%2Cdigital-text%2C77&sr=1-4
Recommended SQL Server with all its components – SSMS, SSIS etc.
Software Visual C# with all components – UWP, DB Tools etc.
Applications
Hardware Laptop with Windows OS
COMPUTER/TECHNOLOGY REQUIREMENTS
✔ In order to successfully complete your studies at Niagara College - Toronto (NCT), it is
recommended that you have access to a laptop or desktop with a Microsoft Windows operating
system (PC). The Computer Programming program is PC-based as several key software are not
supported by Mac operating systems.
✔ We recommend students buy PC laptops or desktops with the same specifications as or higher
than the machines in our labs. Our labs have the following minimum configuration:
>i7 processor
>16 GB of RAM
>512 GB SSD
> Smallest 17-inch screen (21.5-inch recommended)
✔ NCT offers access to computer labs on campus, but availability cannot be guaranteed, and some
software may not be available on all open- access computers on campus.
EVALUATION DETAILS
Number Percentage of
Type of Evaluation/Assessment
Final Grade
1. Assignments:
Assignment 1 – 10% Week 5,
30%
Assignment 2 – 10% Week 9,
Assignment 3 – 10% Week 11
2. Tests:
Test 1 – 20% Week 4,
70%
Test 2 – 20% Week 7,
Test 3 – 30% Week 15
Total
100%
STANDARD COURSE PLAN
Topic Assessments and Learning Objectives
/Theme/Chapter Activities
Week
Week 1 Introduction Hands-On Lab on Intro – Students will learn about
Session Canvas the LMS - Canvas
▪ Icebreaker
Activity and 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
Week 2 ▪ Describing Discussion on SQL 1. Design and implement the
different SQL Server Software relational database structure
Server packages, Editions and required to maintain the data
Components features for a given business
and utilities application and translate it
(DB Engine, into an appropriate physical
▪ SQL Server
database design.
Agent,
▪ Browser, 1.1 Describe the
▪ VSS Writer software components
▪ Etc.) and utilities that make up
Topic Assessments and Learning Objectives
/Theme/Chapter Activities
Week
▪ Understanding the SQL Server software
the SQL package.
Server
architecture 1.2 Identify the features
▪ Identifying the and limitations of the
features and different versions of
limitations of SQL Server and
the different determine which version
versions of would be appropriate to
SQL Server implement in a given
(2019 - business environment.
Express, Web ,
Standard,
Developer and
Enterprise )
▪ Understanding
why SQL
Server’s
Developer
version is used
for the Lab
Demonstration
Environment.
Week 3 ▪ Designing the Group Work on 1. Design and implement the
SQL Server Deriving ER Diagram relational database structure
table from a given business required to maintain the data
structures. Scenario for a given business
▪ Understanding application and translate it
the Entity- into an appropriate physical
Relationship
database design.
Diagrams
using a 1.3 Design the SQL
Business case Server table structures,
scenario. relationships and entity,
▪ Understanding domain and referential
Domain and integrity constraints
referential required for a business
Integrity, application.
Primary Key
and Foreign 1.4 Describe the
Key in a Client/Server Model for
business enterprise development
environment. including 2-tier, 3-tier
Topic Assessments and Learning Objectives
/Theme/Chapter Activities
Week
▪ Describing the and n-tier systems and
Client Server determine which system
Model (2 tier , would be appropriate in
3 tier ,n - tier ) a given business
architecture environment.
including the (
Presentation,
Application
and Database
Tier) and
determining
which system
would be
appropriate in
a given
business
environment.
Week 4 ▪ Writing T-SQL Test 1 – 20% 2. Create appropriate Views,
Statements Triggers, Stored Procedures
inside SQL and User-Defined Functions to
Server support enterprise
Management development of multiple client
Studio interfaces.
▪ Declaring
Local 2.1 Write scripts using
Variables, variables, comments,
using statement blocks, and
Comments. conditional statements in
▪ Creating T-SQL.
Conditional If
Else 2.2 Use transactions to
Statements enforce procedural
▪ Using Commit business logic.
and Rollback
in Transactions
to enforce
procedural
business logic.
Topic Assessments and Learning Objectives
/Theme/Chapter Activities
Week
Week 5 ▪ Understanding Assignment 1 – 10% 2. Create appropriate Views,
System Triggers, Stored Procedures,
Defined Errors Lecture on Error
and User-Defined Functions to
▪ Creating the Handling with TRY
support enterprise
TRY and and Catch Block
development of multiple client
Catch Block interfaces.
for statements
suspected to 2.3 Use both system and
throw errors. user-defined error messages to
▪ Defining monitor data manipulations.
Errors (User
Defined) with
Message
Number, level,
State, Line
▪ Defining Run
time errors and
Global
Variable errors
Week 6 ▪ Creating a Mid-term Review and 2. Create appropriate Views,
(Monday Virtual Table Lab Activity Group Triggers, Stored Procedures,
October 9 th called View Work on Creating and User-Defined Functions to
Statutory from an Actual Views, Cursor, Stored support enterprise
Holiday: Table Procedure and User development of multiple client
Thanksgiving ▪ Declaring Defined Functions interfaces.
Day) Cursor (Open,
Fetch, 2.4 Develop and
Deallocate) implement Views,
▪ Create Stored Triggers, Stored
Procedures and Procedures and User-
Triggers for a Defined Functions.
Specific Event
▪ Creating User
Defined
Functions
Week 7 Mid Term Test 2 Mid Term Test 2 –
– 20% 20%
Week 8 Reading Week (No
Classes)
Topic Assessments and Learning Objectives
/Theme/Chapter Activities
Week
Week 9 ▪ Installing and Assignment 2 – 10% 3. Design and implement basic
Creating new Universal Windows Platform
UWP Lecture and Lab
applications.
application in Activity on creating
Visual C (#) UWP applications 3.1 Develop dynamic
Sharp using Visual c # applications using UWP.
▪ Designing a
Form with 3.2 Use XAML Controls
common form in pages to create
elements common form elements.
▪ Using XAML
Editor controls
create a form
with Labels,
Textbox etc.
▪ Develop
dynamic
applications
using UWP.
Week 10 ▪ Creating Data Discussion on how to 3. Design and implement basic
bound controls validate UWP Universal Windows Platform
to display data. input/output controls applications.
▪ Adding Code
in the event 3.3 Create data-bound
Handler for controls to display data.
(Check box,
Radio Buttons) 3.4 Validate user input
and using text and respond to errors.
boxes to
Display
Username,
Input
Encrypted
Password etc.)
▪ Checking and
validating the
user inputs.
▪ Displaying
appropriate
Error message
or Success
messages.
Topic Assessments and Learning Objectives
/Theme/Chapter Activities
Week
Week 11 ▪ Develop a Assignment 3 – 10% 4. Develop integrated data-
client system driven applications such using
to use a Lecture on Discussion
SQL Server and UWP.
database and on Developing client
SQL system to use database 4.1 Develop a client
commands. via SQL commands system to use a database
▪ Using SSMS and SQL commands.
to configure
tools.
▪ Checking
whether the
Connection to
the Server was
successful or
not.
▪ Registering the
Local Server to
connect to the
DB Engine via
Windows
Authentication.
Week 12 ▪ Design and use Group Work on How 4. Develop integrated data-
a Business to Connect the SQL driven applications such using
Data Layer to Server to the Front SQL Server and UWP.
communicate End using UWP
between client 4.2 Design and use a
and server. Business Data Layer to
▪ Adding a communicate between
connection client and server.
string to the
connected SQL
Server.
▪ Entering SQL
Server
Authentication
Credentials.
▪ Selecting the
database and
checking the
Client and
Topic Assessments and Learning Objectives
/Theme/Chapter Activities
Week
Server
Connection.
Week 13 ▪ Using SQL Discussion on 4. Develop integrated data-
Mapping Accessing SQL DB driven applications such using
frameworks. and Inserting and SQL Server and UWP.
▪ Creating a Updating the Tables
class to hold 4.3 Use SQL Mapping
product data. frameworks to access
▪ Retrieving data from a database.
products from
the SQL
Server
database.
▪ Accessing
Data From
Database.
Week 14 ▪ Using Final Exam Review 4. Develop integrated data-
Application to driven applications such using
display SQL Server and UWP.
database.
▪ Adding a basic 4.4 Use the application
user interface. to display and maintain
▪ Populating the database data.
UI with
Products.
▪ Maintaining
the database
data.
Week 15 Final Exam Test 3 – 30%
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 Community Services (HWCS) 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: hwcs@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)
