Topic outline

  • General

    Professor: Aleksejs Zorins

    Introduction

    The students will be able to create a simple database and a user application for operating with a database. The database application will be implemented using MS SQL Server database management system and MS Visual Studio with C# programming language will be used for creation of user application. This will bring students deeper understanding of digital library theory as well as knowledge integration with practical skills. 

    Content
    1. Introduction to MS SQL Server and relational databases. 
    2. Working with SQL Server in SQL Server Management Studio environment 
    3. Creating digital library: database, database files, tables 
    4. Implementing data integrity by using constraints 
    5. Creating simple database user application using MS Visual
Studio and C# programming language 

    Readings

    1. Course 4994A: Introduction to programming Microsoft .NET Applications with Microsoft Visual Studio 2005. Microsoft Official Course, 2007. 
    2. Course 2541B: Core Data Access with Microsoft Visual Studio 2005. Microsoft Official Course, 2006. 
    3. Troelsen A. Pro C# 2005 and .NET 2.0 Platform. Apress, 2005 (e-book). 

    Requirements
    Computer classroom with MS Visual Studio and MS SQL Server (may be Express Edition) and SQL Server Management Studio installed.

  • Topic 1