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
201830
PLAR
Yes
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 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, and extensive coverage of ADO .NET. Along with the coverage of database access using SQL Server/MySQL, these topics will be covered: XML and XML integration with ADO .NET. The course will use Visual Studio .NET to build client-server systems.

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

a. Environment

b. Tables and views

c. DDL and DML

d. Stored procedure and triggers

2. ADO.NET
3. LINQ
4. Data Query and Manipulation with Visual Studio .NET
5. Effective communication with team members
6. Advance topics (if time permits)
       a.   Web Service and SOA Fundamentals
       b.   Web Service with ASP .Net

Learning Outcomes

The student will be able to:

  1. Construct complex queries, set operators, and user-defined stored procedures
  2. Demonstrate the use of a Visual Studio .NET to build a client-server system
  3. Demonstrate the use of ADO .NET within the application
  4. Describe ADO data providers, datasets, data adapters, connections
  5. Explain the basic concepts of reading/writing XML
  6. Explain how XML is incorporated in the .NET environment
  7. 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%

Textbook Materials

Instructor will prepare course reference material

or

other textbook(s) as approved by the department

Prerequisites

Database (CSIS 2300) and programming (CSIS 1175 or CMPT 1110)

Corequisites

nil

Equivalencies

nil

Which Prerequisite

nil