TLÜ ÕIS

Design and Development of Databases

Course code

IFI6013.DT

old course code

IFI6013

Course title in Estonian

Andmebaaside projekteerimine

Course title in English

Design and Development of Databases

ECTS credits

3.0

Assessment form

Examination

lecturer of 2023/2024 Spring semester

Not opened for teaching. Click the study programme link below to see the nominal division schedule.

lecturer of 2024/2025 Autumn semester

Not opened for teaching. Click the study programme link below to see the nominal division schedule.

Course aims

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.

Teacher

Inga Petuhhov

The course is a prerequisite

Databases (IFI6106.DT)

Study programmes containing that course