VSFS:B_UDS Introduction to Database Sys. - Course Information
B_UDS Introduction to Database Systems
University of Finance and AdministrationWinter 2016
- 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: Ing. Barbora Ptáčková - Timetable of Seminar Groups
- B_UDS/cAPH: Mon 15:45–16:29 E303PC, Mon 16:30–17:15 E303PC, V. Nulíček
B_UDS/pAPH: Mon 14:00–14:44 E303PC, Mon 14:45–15:30 E303PC, 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
- 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
- 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.
- Enrolment Statistics (Winter 2016, recent)
- Permalink: https://is.vsfs.cz/course/vsfs/winter2016/B_UDS