| Course title | Database Systems |
|---|---|
| Course code | KI/EDSY |
| Organizational form of instruction | Lecture + Lesson |
| Level of course | unspecified |
| Year of study | not specified |
| Semester | Winter |
| Number of ECTS credits | 7 |
| Language of instruction | English |
| Status of course | unspecified |
| Form of instruction | Face-to-face |
| Work placements | This is not an internship |
| Recommended optional programme components | None |
| Course availability | The course is available to visiting students |
| Lecturer(s) |
|---|
|
| Course content |
|
1. Basic principles and history of database systems. 2. Basic conceptions and principles (object, entity, attribute, relation, query, view). 3. Database systems architecture. 4. Conceptual data model (ER model). 5. Relational data model (entity, relation, integrity, domains). 6. Transformation of conceptual model into relational model. 7. Database design. 8. Normalization and denormalization of relational data model. 9. Database languages - SQL basics. 10. Database languages - DDL SQL, DML SQL. 11. Database languages - DQL SQL, DCL SQL. 12. Transactions and triggers, failure recovery. 13. Introduction to object-relational database design.
|
| Learning activities and teaching methods |
| unspecified |
| Learning outcomes |
| Prerequisites |
|
unspecified
|
| Assessment methods and criteria |
|
unspecified
Basics of procedural programming (loops, procedures), elementary data types (numbers, string, booleans), principles of efficient data representation (hashes, binary trees) |
| Recommended literature |
|
|
| Study plans that include the course |
| Faculty | Study plan (Version) | Category of Branch/Specialization | Recommended semester |
|---|