VSFS:B_UDS Introduction to Database Sys. - Course Information
B_UDS Introduction to Database Systems
University of Finance and AdministrationWinter 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
- Applied Informatics (programme VSFS, B-INF) (2)
- 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.
- Enrolment Statistics (Winter 2015, recent)
- Permalink: https://is.vsfs.cz/course/vsfs/winter2015/B_UDS