| Course title | Database Systems |
|---|---|
| Course code | KI/KDSY |
| Organizational form of instruction | Lecture + Lesson |
| Level of course | Bachelor |
| Year of study | 2 |
| Semester | Winter |
| Number of ECTS credits | 5 |
| Language of instruction | Czech |
| Status of course | Compulsory |
| Form of instruction | Face-to-face |
| Work placements | This is not an internship |
| Recommended optional programme components | None |
| Lecturer(s) |
|---|
|
| Course content |
|
1. Basic principles and history of database systems progress. 2. Basic conceptions. 3. Database systems architecture. 4. Conceptual data modeling (ER model). 5. Relational data model. 6. Conceptual model to relational model transformation. 7. Database desing. 8. Normalization of relational model. 9. Database languages - SQL basics. 10. Principles of objective-relational desing. 11. Transactional database systems.
|
| Learning activities and teaching methods |
| unspecified |
| Learning outcomes |
|
Aim of this course is to gain basic theoretical knowledge of database systems design oriented to relational systems. During models design will be used three ways of data processing - conceptual modelling (ER model), database modelling (relational model with normal forms use) and object-relational modelling (object oriented concept).
|
| Prerequisites |
|
unspecified
KI/KDSA |
| Assessment methods and criteria |
|
unspecified
|
| Recommended literature |
|
| Study plans that include the course |
| Faculty | Study plan (Version) | Category of Branch/Specialization | Recommended semester | |
|---|---|---|---|---|
| Faculty: Faculty of Science | Study plan (Version): - (A14) | Category: Informatics courses | 2 | Recommended year of study:2, Recommended semester: Winter |