Databases

Course was designed and taught by Georgiy Korneev at ITMO University in 2021 (year2018, 7th semester).

Homeworks

1. Setting up and using DBMS (statements (ru))
2. «University» database modeling (statements (ru), solution)
3. Functional dependencies in «University» database (statements (ru), solution)
4. Normalization of «University» database (statements (ru), solution)
5. Relational algebra (statements (ru), solution)
6. Relational calculus (statements (ru), solution)
7. Modifying data (statements (ru), solution)
8. Indexing (statements (ru), solution)
9. Stored procedures (statements (ru), solution)
10. Transactions (statements (ru), solution)

Project

The course also involves the implementation of the project on the selected topic. Statements (ru) and solution are also available in the repository.

Useful links

• Course page on the site of Georgiy Korneev (ru)
• PostgreSQL documentation

Literature

• C.J. Date An Introduction to Database Systems
• J. Widom, J. Ullman A First Course in Database Systems