Design and Development of Databases
space
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 2022/2023 Autumn semester
Inga Petuhhov (language of instruction:Estonian)
lecturer of 2022/2023 Spring 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
space