Curriculum Guideline

Client Server Systems

Effective Date:
Course
Discontinued
No
Course Code
CSIS 3540
Descriptive
Client Server Systems
Department
Computing Studies & Information Systems
Faculty
Commerce & Business Administration
Credits
3.00
Start Date
End Term
Not Specified
PLAR
No
Semester Length
15 Weeks
Max Class Size
35
Contact Hours
Lecture: 2 Hours per week Labs/Project: 2 Hours per week Total: 4 Hours per week
Method Of Instruction
Lecture
Lab
Methods Of Instruction

Lecture, seminar, and hands-on projects

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

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

Prerequisites

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

Equivalencies

CISY 3540

Which Prerequisite

None