Databases 06-ZBADLM0

The aim of this course is to provide the students with fundamentals concepts and technologies necessary for designing, using and implementing database systems.
Students acquaint themselves with key issues concerning database modeling and designing. They have ability to use the learned material to create conceptual model of an application domain using ER (EER) model and then transform it to a relational database schema.
The student is able to analyze correctness of relational schema, identify and check functional dependencies and decompose a given schema into the expected normal form. The student is skilled in using the database language SQL - he/she is able to define database objects (tables, views, stored procedures, triggers, etc.) and use them to create database logic.
Database programming is taught in the environment of the newest version of MS SQL Server.
The student understands issues concerning efficiency of database organization and query processing. Is able to improve this tasks using database indexes. The course provides information about processing concurrent transactions and using mechanisms to control them. Students are also able to control database security and authorization. The student can design and implement a simple database application using a database provider (like ODBC and/or ADO.NET).