B_UDS Introduction to Database Systems

University of Finance and Administration
Winter 2015
Extent and Intensity
2/1/0. 5 credit(s). Type of Completion: zk (examination).
Teacher(s)
RNDr. Jakub Lokoč, Ph.D. (seminar tutor)
Ing. Vladimír Nulíček, CSc. (assistant)
Guaranteed by
RNDr. Jakub Lokoč, Ph.D.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ing. Barbora Ptáčková
Timetable of Seminar Groups
B_UDS/cAPH: each even Thursday 10:30–11:14 E303PC, each even Thursday 11:15–12:00 E303PC, except Thu 15. 10. ; and Thu 29. 10. 8:00–8:44 E303PC, Thu 5. 11. 8:00–8:44 E303PC, J. Lokoč
B_UDS/pAPH: Thu 8:45–9:29 E303PC, Thu 9:30–10:15 E303PC, except Thu 8. 10., except Thu 15. 10. ; and Thu 8. 10. 8:00–10:15 DELL ROOM E302PC, Thu 22. 10. 8:00–8:44 E303PC, J. Lokoč
B_UDS/vAPH: Fri 2. 10. 13:45–15:15 DELL ROOM E302PC, 15:30–17:00 DELL ROOM E302PC, Fri 16. 10. 13:45–15:15 DELL ROOM E302PC, 15:30–17:00 DELL ROOM E302PC, J. Lokoč
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
  • 1) Modeling of IS data layer, levels of modeling, ER-modeling.
  • 2) Relational model, integrity constraints, ER-model to relational model conversion.
  • 3) Universal relations, functional dependencies, Armstrong's rules, attribute and functional closure.
  • 4) Normalization of DB, normal forms, detection of schema keys, decomposition.
  • 5) Basic and derived operations of relational algebra, relational completeness, relational calculus.
  • 6) Basic SQL operations, attribute types, SELECT and JOINS.
  • 7) Advanced SQL operations - group by, all, any, exists, in, nested SQL queries.
  • 8) Definition and modification of data schema using SQL, INSERT, DELETE and UPDATE operations, views.
  • 9) Transactions, ACID properties, transaction schedule, properties of schedules, conflict pairs.
  • 10) Locking and alternative protocols, deadlock, phantom, DB recovery.
  • 11) Physical implementation of DB, organisation of data into pages, memory frames, data files, indexes.
  • 12) Other database models - nested set, hierarchical, object, object-relational.
Literature
    recommended literature
  • Databázové systémy, skripta FEL ČVUT 2003, POKORNÝ, J., HALAŠKA, J.
  • Database Systems Management, Ramakrishnan, Gehrke
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: 8 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 2016, Winter 2017, Winter 2018, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.
  • Enrolment Statistics (Winter 2015, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/winter2015/B_UDS