Client Server Systems

Overview

Course description

This course will provide the student with practical knowledge of developing and implementing client-server systems. Topics will include DDL, DML, host based processing, designing complex queries, stored procedures, triggers, using object-oriented programming and ADO .NET frameworks. Use of LINQ and lambda expressions will be covered. The course will use Visual Studio and C# to build client-server systems.

Course content

Review of Object-Oriented Programming in C# using Visual Studio
LINQ and lambda expressions in C#
Windows Forms programming
Database

Environment
Tables and Views
DDL//DML
Stored procedures and triggers

ADO.NET basics
Data Query and Manipulation with ADO.NET
Effective communication with team members

Learning activities

Lecture, seminar, and hands-on projects

Means of assessment

Labs/Assignments	10% - 15%
Project	15% - 25%
Midterm Examination	30% - 35%
Final Examination*	30% - 40%
Total	100%

*Will contain min 50% practical hands-on computer programming 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).

Students may conduct research as part of their coursework in this class. Instructors for the course are responsible for ensuring that student research projects comply with College policies on ethical conduct for research involving humans, which can require obtaining Informed Consent from participants and getting the approval of the Douglas College Research Ethics Board prior to conducting the research.

Learning outcomes

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

Construct complex queries, set operators, and user-defined stored procedures
Demonstrate the use of a Visual Studio .NET to build a client-server system
Demonstrate the use of ADO .NET frameworks in building an application
Describe ADO data providers, datasets, data adapters, connections, and frameworks
Explain the basic concepts of reading//writing XML
Explain how XML is incorporated in the .NET environment
Demonstrate the use of SQL Server//MySQL incorporated with Visual Studio .NET

Textbook materials

Troelsen, C# 6.0 and the .NET 4.6 Framework, Apress (Springer-Verlag), or latest edition

and/or

Instructor-prepared course reference material

other textbook(s) as approved by the department

Requisites

Prerequisites

A grade of C or better in the following courses: CSIS 2300 and (CSIS 1175 or CMPT 1110).

Corequisites

No corequisite courses.

Equivalencies

CISY 3540

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.

January 2021 (Current)

Course Transfers to Other Institutions

Below are current transfer agreements from Douglas College to other institutions for the current course guidelines only. For a full list of transfer details and archived courses, please see the BC Transfer Guide.

Institution	Transfer details for CSIS 3540
Athabasca University (AU)	AU COMP 3XX (3)
Coast Mountain College (CMTN)	CMTN CPSC 1XX (3)
Coquitlam College (COQU)	No credit
Kwantlen Polytechnic University (KPU)	KPU CISY 2XXX (3)
Langara College (LANG)	LANG CSIS 3XXX (3)
Okanagan College (OC)	OC COSC 331 (3)
Simon Fraser University (SFU)	SFU CMPT 354 (3)
Thompson Rivers University (TRU)	TRU COMP 3XXX (3)
University Canada West (UCW)	No credit
University of Northern BC (UNBC)	No credit
University of the Fraser Valley (UFV)	UFV CIS 2XX (3)
University of Victoria (UVIC)	UVIC CSC 2XX (1.5)
Vancouver Community College (VCC)	No credit