Learning outcome

After successfully completing the course, the candidate will have achieved the following learning outcomes:

• knowledge of database usage
• knowledge of design, implementation and administration of databases
• basic knowledge of the theoretical foundation of relational databases
• knowledge of the architecture of database management systems
• skills in the use of SQL
• skills in data modeling and normalization
• skills in the use of tools for design, implementation and administration of databases

Course Description

Usage and functionality of database systems. The use of SQL; table definition, select queries and data manipulation. The relational model. Data modeling using E/R, normalization, implementation of data models. Physical storage of database tables; indexes. Database administration, user administration. Transactions and multi-user databases. Introduction to database application development.

Teaching and Learning Methods

4-5 hours of lectures, exercises and guidance per week.

Assessment Methods

A 4-hour written, individual examination. A number of obligatory assignments submitted during the course must be approved before the student will be permitted to sit the final examination.

Minor adjustments may occur during the academic year, subject to the decision of the Dean