B_UDS Introduction to Database Systems

University of Finance and Administration
Winter 2017
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 15:45–16:29 E307, Tue 16:30–17:15 E307, V. Nulíček
B_UDS/pAPH: Mon 15:45–16:29 E307, Mon 16:30–17:15 E307, V. Nulíček
B_UDS/vAPH: Fri 13. 10. 19:15–20:45 E307, Sat 11. 11. 14:00–15:30 E307, 15:45–17:15 E307, Fri 1. 12. 17:30–19:00 E307, Sat 16. 12. 9:45–11:15 E307, 11:30–13:00 E307, V. Nulíček
Prerequisites
There are no prerequisites for this course.
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
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 and write SQL scripts for database creation and querying
Syllabus
  • The basic concepts of DBS
  • Life Cycle of DB model, data normalization
  • Modeling DBS, ERD
  • The logic level model, the relational model
  • The relational algebra and relational calculus
  • Functional dependencies, Armstrong rules, functional closure
  • Query language, SQL - basic definitions, transactions
  • SQL - examples, referential integrity
  • SQL - basic commands and structures
  • Aggregate functions, internal and external links
  • nested queries, triggers, views
  • The physical organization of data in DB
  • The transaction serialization, recoverability DB
  • Logs, locks, DB Recovery
Literature
    recommended literature
  • Sheldon: SQL, začínáme programovat
  • Otte: Databázové systémy. Skripta VŠ
  • Ricardi: Principles of Database Systems
  • Connoly: Database Solutions
  • Pokorný, Halaška: Databázové systémy. Skripta FEL ČVUT
  • 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
Teaching methods
Lectures with required attendance compulsory seminar participation is 75% in full-time study, compulsory tutorial participation is 50% in part-time study.
Assessment methods
Written test with limit 80% + 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: 12 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 2018, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.
  • Enrolment Statistics (Winter 2017, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/winter2017/B_UDS