Course: Database Systems 1

« Back
Course title Database Systems 1
Course code KMI/DBS1
Organizational form of instruction Lecture + Lesson
Level of course Bachelor
Year of study not specified
Semester Winter
Number of ECTS credits 5
Language of instruction Czech
Status of course Compulsory
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Lecturer(s)
  • Beránek Ladislav, doc. Ing. CSc.
Course content
1. - Basic terms 2. - Conceptual ER model 3. - Relative algebra, relational calculus 4. - Relational Model, Transformation of E-R Scheme into RMD 5. - SQL - creating queries 6. - SQL - more complex queries, definitions, and data updates 7. - Functional dependencies 8. - Normalization of databases 9. - Advanced features of SQL, procedures, trigger 10. - Transactions 11. - Principles of database administration - eg MS SQL, Posgre SQL 12. - Distributed DBS, Post-Relational DBS, NoSQl Database - Features

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Demonstration, E-learning
  • Preparation for exam - 20 hours per semester
  • Preparation for credit - 20 hours per semester
  • Semestral paper - 40 hours per semester
  • Preparation for classes - 18 hours per semester
  • Class attendance - 42 hours per semester
Learning outcomes
The course is aimed to introduce students basic theory of database technology. The course includes an overview of basic database models (E-R conceptual model, relational DB model, object DB model), rules of database normalization process, relational algebra, query language SQL, transaction and concurrent access to databases.
The students are able to design, develop and manage relational database applications for personal use even for school or small firm use. Student can orientate in problematics of database design, creating and optimalizating SQL queries.
Prerequisites
The course has no prerequisities.

Assessment methods and criteria
Combined exam

Credit Requirements: Programming partial short tasks, creating an database application. Global success rate minimally 65%. Examination Requirements: Students will demonstrate complex knowledge of creating and designing databases.
Recommended literature
  • CONOLLY, T., BEGG, C., HOLOWCZAK, R. Mistrovství - Databáze. Computer Press, 2009.
  • Hernandez, M., J. Návrh databází.. Grada, 2006. ISBN 80-247-0900-7.
  • HOLUBOVÁ, Irena, Jiří KOSEK, Karel MINAŘÍK a David NOVÁK. . Big Data a NoSQL databáze. Praha: Grada Publishing, 2015. ISBN 978-80-247-5466-6.
  • KROENKE, David a David J. AUER. Databáze. Brno: Computer Press, 2018. ISBN 978-80-251-4352-0.
  • LACKO, L. 1001 tipů a triků pro SQL. Brno: Computer Press, 2011, 416 s., 2011. ISBN 978-80-251-3010-0.
  • LAURENČÍK, Marek. SQL: podrobný průvodce uživatele. Praha: Grada Publishing, 2018. ISBN 978-80-271-0.
  • POKORNÝ, Jaroslav a Michal VALENTA. Databázové systémy. Praha: České vysoké učení technické v Praze, 2013. ISBN 978-80-0105-212-9.
  • ROCKOFF, Larry. The language of SQL. Boston, MA: Course Technology Cengage Learning, c2011, xiv, 239 p., 2011. ISBN 978-143-5457-515.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Economics Study plan (Version): Economic Informatics (4) Category: Economy 2 Recommended year of study:2, Recommended semester: Winter