Client Server Systems

Faculty
Commerce & Business Administration
Department
Computing Studies & Information Systems
Course Code
CSIS 3540
Credits
3.00
Semester Length
15 Weeks
Max Class Size
35
Method Of Instruction
Lecture
Lab
Typically Offered
To be determined
Campus
New Westminster

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
Methods Of Instruction

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

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

or

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

Requisite for

None

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.

Course Transfers

Institution Transfer Details Effective Dates
Athabasca University (AU) AU COMP 3XX (3) 2015/01/01 to -
Coast Mountain College (CMTN) CMTN CPSC 1XX (3) 2015/01/01 to -
Coquitlam College (COQU) No credit 2015/01/01 to -
Kwantlen Polytechnic University (KPU) KPU CISY 2XXX (3) 2007/09/01 to -
Langara College (LANG) LANG CSIS 2XXX (3) 2007/09/01 to -
Okanagan College (OC) OC COSC 331 (3) 2015/01/01 to -
Simon Fraser University (SFU) SFU CMPT 354 (3) 2015/01/01 to -
Simon Fraser University (SFU) No credit 2007/09/01 to 2014/12/31
Thompson Rivers University (TRU) TRU COMP 3XXX (3) 2015/01/01 to -
Thompson Rivers University (TRU) TRU COMP 2640 (3) 2010/09/01 to 2014/12/31
Thompson Rivers University (TRU) TRU COMP 264 (3) 2007/09/01 to 2010/08/31
University Canada West (UCW) UCW CPSC 3XX (3) 2005/05/01 to 2014/12/31
University Canada West (UCW) No credit 2015/01/01 to -
University of Northern BC (UNBC) No credit 2015/09/01 to -
University of the Fraser Valley (UFV) UFV CIS 2XX (3) 2007/09/01 to -
University of Victoria (UVIC) UVIC CSC 2XX (1.5) 2007/09/01 to -
Vancouver Community College (VCC) No credit 2015/01/01 to -

Course Offerings

Fall 2020

There aren't any scheduled upcoming offerings for this course.