| Course title | Database Systems |
|---|---|
| Course code | KI/DSY |
| Organizational form of instruction | Lecture + Lesson |
| Level of course | Bachelor |
| Year of study | not specified |
| Semester | Winter |
| Number of ECTS credits | 5 |
| Language of instruction | Czech |
| Status of course | Compulsory |
| Form of instruction | unspecified |
| Work placements | unspecified |
| 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. Design of models combines three ways of data processing: conceptual modelling (ER model), database modelling (relational model using normal forms) and object-relational modelling (object oriented concept).
|
| Prerequisites |
|
unspecified
KI/ADS ----- or ----- KI/DSA ----- or ----- KI/XADS |
| 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): Information Sciences (double subject) (A14) | Category: Informatics courses | 3 | Recommended year of study:3, Recommended semester: Winter |
| Faculty: Faculty of Science | Study plan (Version): Information Systems (A14) | Category: Informatics courses | 2 | Recommended year of study:2, Recommended semester: Winter |
| Faculty: Faculty of Science | Study plan (Version): Information Sciences (double subject) (A14) | Category: Informatics courses | 3 | Recommended year of study:3, Recommended semester: Winter |