B_UDS Introduction to Database Systems

University of Finance and Administration
Summer 2025
Extent and Intensity
2/2/0. 6 credit(s). Type of Completion: zk (examination).
Guaranteed by
Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková
Prerequisites
There are no prerequisites for this course.
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives
The goal of the course is to teach students the basics of relational database creation from the design phase through the creation of ERDs and relational models to the actual implementation of database creation in the SQL environment. The student will also learn about the theoretical basics of relational database creation, database normalization, relational algebra and relational calculus. Students will also learn to use SQL query language, create SQL queries and other scripts in this language.
Learning outcomes
At the end of this course, the student will be able to:
- create an ER-model in compliance with the normalization rules
- convert the ERD into a relational model with integrity constraints set
- create SQL scripts to create a database
- define basic and more advanced SQL queries over one or more tables
Syllabus
  • 1. Basic concepts from DBS theory
  • 2. DBS modeling, ER diagram
  • 3. Normalization of the database
  • 4. Armstrong's rules, determining keys
  • 5. Logical model level, relational model
  • 6. Relational algebra and relational calculus
  • 7. Query languages, SQL - basic definition of
  • 8. SQL – creation and modification of tables, referential integrity
  • 9. SQL – SELECT command, board connection
  • 10.SQL - aggregation function
  • 11.SQL - nested queries
  • 12.SQL - internal functions,
  • data types
Literature
    required literature
  • POKORNÝ, Jaroslav a Michal VALENTA. Databázové systémy. Praha: České vysoké učení technické v Praze, 2013. ISBN 978-80-01-05212-9.
  • LAURENČÍK, Marek. SQL: podrobný průvodce uživatele. Praha: Grada Publishing, 2018. Průvodce (Grada). ISBN 978-80-271-0774-2¨.
    recommended literature
  • OPPEL, Andrew J. Databáze bez předchozích znalostí: [průvodce pro samouky]. Brno: Computer Press, 2006. ISBN 80-251-1199-7
  • Date, C. J. An Introduction to Database Systems. Addison-Wesley, 1995. ISBN 0-201-82458-2.
  • STEPHENS, Ryan K., Ronald R. PLEW a Arie JONES. Naučte se SQL za 28 dní: [stačí hodina denně]. Brno: Computer Press, 2010. ISBN 978-80-251-2700-1.
  • OPPEL, Andrew J. SQL bez předchozích znalostí: [průvodce pro samouky]. Brno: Computer Press, 2008. ISBN 978-80-251-1707-1.
Teaching methods
Lectures and seminars in the full-time study, seminars in the combined study
Assessment methods
Several seminar examples given in the exercises need to be written on the credit. The exam consists a written test and an oral exam verifying student knowledge that affects the final score.
Language of instruction
Czech
Follow-Up Courses
Further comments (probably available only in Czech)
The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 14 hodin KS/semestr.
The course is also listed under the following terms Winter 2007, Winter 2008, Summer 2009, Winter 2009, Winter 2010, Summer 2011, Winter 2011, summer 2012, Winter 2012, Winter 2013, Summer 2015, Winter 2015, Winter 2016, Winter 2017, Winter 2018, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024.
  • Enrolment Statistics (recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/summer2025/B_UDS