B_UDS Introduction to Database Systems

University of Finance and Administration
Summer 2020
Extent and Intensity
2/2/0. 5 credit(s). Type of Completion: zk (examination).
Teacher(s)
Ing. Vladimír Nulíček, CSc. (seminar tutor)
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á
Timetable of Seminar Groups
B_UDS/cAPH: Tue 12:15–12:59 E303PC, Tue 13:00–13:45 E303PC, V. Nulíček
B_UDS/pAPH: Tue 10:30–11:14 E303PC, Tue 11:15–12:00 E303PC, V. Nulíček
B_UDS/vAPH: Sat 29. 2. 9:45–11:15 E303PC, 11:30–13:00 E303PC, Sat 28. 3. 9:45–11:15 E303PC, 11:30–13:00 E303PC, 14:00–15:30 E303PC, Sat 25. 4. 9:45–11:15 S16PC, 11:30–13:00 S16PC, V. Nulíček
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 the student 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 the course students should be able to: create ER-Model from a text analysis transform the model to the relational model write SQL scripts for database creation and querying
Syllabus
  • Basic concepts of DBS theory
  • DB life cycle, data standardization
  • Modeling of DBS, ER diagram
  • Logical model level, relational model
  • Principles of transition from logical to relational model
  • Relative algebra and relational calculus
  • Functional dependence, Armstrong's rules
  • Query Languages, SQL - Basic Definitions
  • SQL - creation and modification of reference integrity tables
  • SQL - Basic commands and structures, SELECT statement
  • SQL - Use Functions, Nested Queries
  • SQL - aggregation functions
Literature
    required literature
  • Pokorný, Halaška: Databázové systémy. Skripta FEL ČVUT
  • OPPEL, Andrew J. SQL bez předchozích znalostí: [průvodce pro samouky]. Brno: Computer Press, 2008. ISBN 978-80-251-1707-1.
    recommended literature
  • Halaška, Pokorný, Valenta: Databázové systémy, cvičení. Skripta FEL ČVUT
  • Palovská: Databáze jako informační zdroj pro uživatele. Skripta VŠE
  • Ramakrishnan, Gehrke: Database Systems Management, McGraw-Hill, 2003
  • 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.
Teaching methods
Lectures and seminars
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 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.
  • Enrolment Statistics (Summer 2020, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/summer2020/B_UDS