Douglas College wordmark
Facebook logo Twitter logo Instagram logo Snapchat logo YouTube logo Wordpress logo

Registration for the Fall 2019 semester begins June 25.  Watch your email for more details.

back to search

Client Server Systems

Course Code: CSIS 3540
Faculty: Commerce & Business Administration
Credits: 3.0
Semester: 15 Weeks X 4 Hours per Week = 60 Hours
Learning Format: Lecture, Lab
Typically Offered: TBD. Contact Department Chair for more info.
course overview

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%

Learning Outcomes

The 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

course prerequisites

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

Corequisites

No corequisite courses.

Equivalencies

Note: Students who have received credit for CISY 3540 will not receive further credit by taking CSIS 3540.

curriculum 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 schedule and availability
course transferability

Below shows how this course and its credits transfer within the BC transfer system. 

A course is considered university-transferable (UT) if it transfers to at least one of the five research universities in British Columbia: University of British Columbia; University of British Columbia-Okanagan; Simon Fraser University; University of Victoria; and the University of Northern British Columbia.

For more information on transfer visit the BC Transfer Guide and BCCAT websites.

assessments

If your course prerequisites indicate that you need an assessment, please see our Assessment page for more information.

noticecurriculum notice

There is an upcoming curriculum change scheduled for .
View upcoming changes