Client Server Systems

Curriculum guideline

Effective Date:
Return to Course
Print Guideline
Course
CSIS 3540
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
202010
PLAR
No
Semester length
15 Weeks X 4 Hours per Week = 60 Hours
Max class size
35
Contact hours
Lecture: 2 Hours per week Labs/Project: 2 Hours per week Total: 4 Hours per week
Method(s) of instruction
Lecture
Lab
Learning activities

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

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
Means of assessment

Labs/Assignments

10% - 15%

Project   

15% - 25%

Midterm Examination

30% - 35%

Final Examination

30% - 40%

Total

100%

 

 

 

 

 

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

Corequisites

No corequisite courses.

Equivalencies

CISY 3540

Which prerequisite

None