Client Server Systems
Curriculum guideline
Effective Date:
Course
Discontinued
No
Course code
CSIS 3540
Descriptive
Client Server Systems
Faculty
Commerce & Business Administration
Credits
3.00
Start date
End term
201430
PLAR
Yes
Semester length
15 Weeks X 4 Hours per Week = 60 Hours
Max class size
35
Contact hours
Lecture: 2 Hours per week
Seminar/Lab: 2 Hours per week
Total: 4 Hours per week
Method(s) of instruction
Lecture
Lab
Seminar
Learning activities
Lecture, seminar, and hands-on projects
Course description
This course will provide the student with practical knowledge of developing and implementing database applications. The student will learn Visual Basic .NET and SQL Server using ADO .NET. Topics will include DDL, DML, host based processing, designing queries and using commands, stored procedures, triggers, and extensive coverage of ADO .NET. Along with the coverage of database access using SQL Server, these topics will be covered: XML and XML integration with ADO .NET. The course will use Visual Basic .NET to build database applications.
Included in this course will be extensive documentation and verbal communication skills required to succeed in the development process.
Note: Students who have received credit for CISY 3540 will not receive further credit by taking CSIS 3540.
Included in this course will be extensive documentation and verbal communication skills required to succeed in the development process.
Note: Students who have received credit for CISY 3540 will not receive further credit by taking CSIS 3540.
Course content
- Introduction to client server computing
- SQL Server environment
- DDL and MDL
- Stored procedures and triggers
- Connecting to SQL server with VB .NET
- Work with ADO data sets
- Conflict resolution in a programming environment
- Effective communication with team members
- Documentation process during the programming phase
Learning outcomes
The student will be able to:
- explain differences between client server and traditional database;
- explain and demonstrate the use of environment;
- demonstrate the use of a VB .NET to build a client server application;
- demonstrate the use of ADO .NET within the application;
- describe ADO data providers, datasets, data adapters, connections;
- explain the basic concepts of reading/writing XML;
- explain how XML is incorporated in the .NET environment;
- demonstrate the use of SQL Server incorporated with VB .NET;
- demonstrate the documentation process of building an application;
- explain the uses and purpose of work related documentation;
- work with team members and understand the communication process that occurs during the implementation phase of the development life cycle.
Means of assessment
| Assignments/Projects (Minimum: 3) | 30% - 50% |
| Participation | 0% - 5% |
| Test/Quizzes (Minimum: 2) | 25% - 40% |
| Final Examination | 25% - 30% |
| Total | 100% |
Textbook materials
Textbooks and Materials to be Purchased by Students
Morrison. Creating SQL Server 2005 Applications with Visual Studio. Latest Edition. Pearson Prentice Hall.