Course: Databases

» List of faculties » FBI » UAI
Course title Databases
Course code UAI/697
Organizational form of instruction Lecture + Lesson
Level of course Bachelor
Year of study not specified
Frequency of the course In each academic year, in the summer semester.
Semester Summer
Number of ECTS credits 6
Language of instruction Czech
Status of course Compulsory
Form of instruction unspecified
Work placements unspecified
Recommended optional programme components None
Lecturer(s)
  • Prokýšek Miloš, PhDr. Ph.D.
  • Geyer Jakub, Mgr.
Course content
1. Basic database concepts 2. E-R conceptual model 3. Relational database model 4. Object and relational model 5. SQL 6. SELECT statement of the SQL language. 7. Relational algebra 8. Functional relation and Armstrong rules 9. Database normalization 10. Transaction data processing 11. Binary and multilevel locks 12. Time stamps and Multiversions

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Projection, Practical training
  • Class attendance - 56 hours per semester
  • Semestral paper - 20 hours per semester
  • Preparation for classes - 56 hours per semester
  • Preparation for exam - 20 hours per semester
Learning outcomes
The course is aimed to basic theory of database technology. The course includes introduction to basic database models (E-R conceptual model, relational DB model, object DB model), rules of database normalization process, relational algebra, query language SQL, transaction and concurrent access to databases.
Student is able to create independently projects and implementations of relational databases, including their administration.
Prerequisites
Introducing course. Basic knowledge of ICT.

Assessment methods and criteria
Analysis of student's work activities (technical works), Combined exam

Creation of database, its optimization and normalization and subsequent defense. Combined exam in relational database theory and SQL knowledge.
Recommended literature
  • Carlos Coronel, Steven Morris. Database Systems: Design, Implementation, & Management. Cengage Learning, 2018. ISBN 9781305627482.
  • HERNANDEZ, M., J. Návrh databází. Grada, 2006. ISBN 80-247-0900-7..
  • Pokorný, J., Valenta, M. Databázové systémy. Česká technika - nakladatelství ČVUT, 2013. ISBN 978-80-01-05212-9.
  • Ryan K. Stephens, Ronald R. Plew. Naučte se SQL za 28 dní. Computer Press, 2012. ISBN 9788025127001.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Science Study plan (Version): Applied Informatics (1) Category: Informatics courses - Recommended year of study:-, Recommended semester: Summer
Faculty: Faculty of Science Study plan (Version): Secondary Schools Teacher Training in Informatics (1) Category: Pedagogy, teacher training and social care - Recommended year of study:-, Recommended semester: Summer
Faculty: Faculty of Science Study plan (Version): Applied Informatics (1) Category: Informatics courses - Recommended year of study:-, Recommended semester: Summer
Faculty: Faculty of Science Study plan (Version): Applied Informatics (1) Category: Informatics courses - Recommended year of study:-, Recommended semester: Summer
Faculty: Faculty of Science Study plan (Version): Applied Informatics (1) Category: Informatics courses - Recommended year of study:-, Recommended semester: Summer