B0B36DBS: Database Systems

Basic Information

Exam Dates

On-Site Exams

Zoom Exams

Lectures

Practical Classes

Timetable

Zdeněk Kouba
101
Martin Svoboda
102+103
Bogdan Kostov
104
Jana Ahmad
111
R. Černoch, G. Šír
109+110
Martin Řimnáč
105+106+107+108
01 - Conceptual Modeling Tuesday 18. 2. Tuesday 18. 2. Wednesday 19. 2. Wednesday 19. 2. Wednesday 19. 2. (GŠ) Thursday 20. 2.
02 - Conceptual Modeling Tuesday 25. 2. Tuesday 25. 2. Wednesday 26. 2. Wednesday 26. 2. Wednesday 26. 2. (GŠ) Thursday 27. 2.
03 - Conceptual Modeling Tuesday 3. 3. Tuesday 3. 3. Wednesday 4. 3. Wednesday 4. 3. Wednesday 4. 3. (GŠ) Thursday 5. 3.
04 - Relational Model Self-study Self-study Self-study Self-study Self-study (GŠ) Self-study
05 - SQL: Data Definition Tuesday 24. 3. Tuesday 24. 3. Wednesday 25. 3. Wednesday 25. 3. Wednesday 25. 3. (RČ) Thursday 26. 3.
06 - SQL: Data Querying Tuesday 31. 3. Tuesday 31. 3. Wednesday 1. 4. Wednesday 1. 4. Wednesday 1. 4. (RČ) Thursday 2. 4.
07 - SQL: Data Querying Tuesday 7. 4. Tuesday 7. 4. Wednesday 8. 4. Wednesday 8. 4. Wednesday 8. 4. (RČ) Thursday 16. 4.
08 - SQL: Advanced Constructs Self-study Self-study Self-study Self-study Self-study (RČ) Self-study
09 - Relational Algebra Tuesday 14. 4. Tuesday 14. 4. Wednesday 15. 4. Wednesday 15. 4. Wednesday 15. 4. (RČ) Thursday 23. 4.
10 - JDBC, JPA Tuesday 21. 4. Tuesday 21. 4. Wednesday 22. 4. Wednesday 22. 4. Wednesday 22. 4. (RČ) Thursday 30. 4.
11 - Functional Dependencies Tuesday 28. 4. Tuesday 28. 4. Wednesday 29. 4. Wednesday 29. 4. Wednesday 29. 4. (GŠ) Thursday 7. 5.
12 - Functional Dependencies Tuesday 12. 5. Tuesday 12. 5. Wednesday 6. 5. Wednesday 6. 5. Wednesday 6. 5. (GŠ) Thursday 14. 5.
13 - Presentations Tuesday 19. 5. Tuesday 19. 5. Wednesday 20. 5. Wednesday 20. 5. Wednesday 20. 5. (RČ) Thursday 21. 5. / 28. 5.

Homework Deadlines

Zdeněk Kouba
101
Martin Svoboda
102+103
Bogdan Kostov
104
Jana Ahmad
111
R. Černoch, G. Šír
109+110
Martin Řimnáč
105+106+107+108
00 - Topic selectionTuesday 3. 3.Tuesday 3. 3.Wednesday 4. 3.Wednesday 4. 3.Wednesday 4. 3.Thursday 5. 3.
01 - Conceptual SchemaMonday 9. 3.Monday 9. 3.Tuesday 10. 3.Tuesday 10. 3.Tuesday 10. 3.Wednesday 11. 3.
02 - Relational SchemaMonday 30. 3.Monday 30. 3.Tuesday 31. 3.Tuesday 31. 3.Tuesday 31. 3.Wednesday 1. 4.
03 - SQL SchemaMonday 6. 4.Monday 6. 4.Tuesday 7. 4.Tuesday 7. 4.Tuesday 7. 4.Wednesday 8. 4.
04 - SQL QueriesMonday 13. 4.Monday 13. 4.Tuesday 14. 4.Tuesday 14. 4.Tuesday 14. 4.Wednesday 22. 4.
05 - Relational AlgebraMonday 20. 4.Monday 20. 4.Tuesday 21. 4.Tuesday 21. 4.Tuesday 21. 4.Wednesday 29. 4.
06 - Database ApplicationMonday 18. 5.Monday 18. 5.Tuesday 19. 5.Tuesday 19. 5.Tuesday 19. 5.Wednesday 20. 5. / 27. 5.

Class Recordings

Lectures

Formal Requirements

Homework Assignments

1: Conceptual Schema

2: Relational Schema

3: SQL Schema

4: SQL Queries

5: Relational Algebra

6: Database Application

Individual Topics

Recommended Literature