Courses list

Wersja polska

Course code: IGS20038o11
Semester: 2011/2012 winter
Name: Relational databases
Major: Geodesy and Cartography
Study Type: second cycle
Course type: compulsory
Study Semester: 2
ECTS points: 4
Hours (Lectures / Tutorials / Other): 30 / 30 / 0
Lecturer: dr inż. Adam Iwaniak
Language of instruction: Polish


Learning outcomes: Student gets a theoretical knowledge about relational databases’ designing, controlling, and handling with practical skills in VB.NET in this context. In particular: the student posses practical knowledge on how to build database’s queries in SQL language; is able to design a relational data base; can implement database oriented applications in VB.NET and simple active pages in ASP.NET; knows the bases of XML language.

Competences: On completion of this course the student can participate in IT projects connected with designing, building and using relational databases.

Prerequisites: Introduction to GIS programming

Course content: Relational databases and DBMS – theoretical bases, relational algebra, model building, process of database normalization; database languages – in particular SQL and T_SQL languages; client-server architecture and problems related to concurrency, methodology of database design and supporting technologies including: VB.NET language, ADO.NET classes, XML language, ASP.NET pages

Recommended literature: Supporting materials prepared by the lecturer
and
Beynon-Davies P. Systemy baz danych, WNT, Warszawa 1998;
Delobel C., Adiba M. Relacyjne bazy danych, WNT, Warszawa 1989;
Date C.J., SQL - omówienie standardu, WNT, Warszawa, 1999;
Date C.J. Wprowadzenie do systemów baz danych, WNT, Warszawa 2000;
Thomsen C. Programowanie baz danych w Visual Basic .NET, seria: Biblioteka Programisty, MICOM, Warszawa 2003, wydanie I;
Pankowski T. Podstawy baz danych, PWN, Warszawa 1992;
Ullman J.D., S.Widom, Podstawowy wykład z systemów baz danych, WNT Warszawa 2000

Assessment methods: completing all laboratory assignments, and passing written exam

Comment: