Design of Databases
Course code
IFI6239.DT
old course code
Course title in Estonian
Andmebaaside projekteerimine
Course title in English
Design of Databases
ECTS credits
4.0
Assessment form
Examination
lecturer of 2025/2026 Autumn semester
Inga Petuhhov (language of instruction:Estonian)
lecturer of 2025/2026 Spring semester
Not opened for teaching. Click the study programme link below to see the nominal division schedule.
Course aims
Create prerequisites for logical and physical modeling of data. Support development of the concepts of the relational model and relational databases. Support development of relational database design, quality assessment and improvement, and documentation skills. Enable initial acquisition and practice of database query language SQL.
Brief description of the course
Databases and database management systems. Conceptual data model. Entity-relationship model. Relational model. Converting an entity-relationship model to a relational model. Characteristics of a good data model. Data model normalization and normal forms. Data model formalization and patterns in data modeling. A relational database as a collection of tables. SQL - relational database manipulation language. Indexes and their use.
Learning outcomes in the course
Upon completing the course the student:
- has an overview of relational database concepts and usage in various applications;
- knows normalization (normal forms) and formalization (patterns) when creating a data model;
- can model data - create a conceptual and relational model using Chen and "crow's foot" notation;
- can use the SQL language to create a database and make queries, including through several tables;
- has an overview of the use of indexes in databases.
- has an overview of relational database concepts and usage in various applications;
- knows normalization (normal forms) and formalization (patterns) when creating a data model;
- can model data - create a conceptual and relational model using Chen and "crow's foot" notation;
- can use the SQL language to create a database and make queries, including through several tables;
- has an overview of the use of indexes in databases.
Teacher
Inga Petuhhov
Study programmes containing that course