lecturer of 2022/2023 Spring semester
Not opened for teaching. Click the study programme link below to see the nominal division schedule.
The objective of the course is to give general theoretical knowledge about database management systems and databases. Also this course gives theoretical knowledge and practical skills for designing, implementing and managing databases.
Brief description of the course
Overview of a Database Management System. Structure of database, data models. The Entity-Relationship Data Model. The Relational Data Model. The Database Language SQL. Normalization. Concurrency, transactions, security.
Learning outcomes in the course
Upon completing the course the student:
- knows the construction principles of realtional database models;
- can create ER-datamodels and use it for the logical design of a database;
- knows the problems regarding database security;
- knows how to use SQL for making enquiries from the database.