Course: Database Systems I

« Back
Course title Database Systems I
Course code KIN/DBS1E
Organizational form of instruction Lecture + Seminary
Level of course Bachelor
Year of study 2
Semester Winter and summer
Number of ECTS credits 6
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)
  • Havelková Hana, RNDr.
Course content
1. Basic database terminology 2. E-R conceptual model 3. Relational database model 4. Relational algebra, relational calculus 5. Structured query language (SQL) 6. SQL - complex queries, data definition, updating data 7. Security. Queries optimalization 8. Database normalization 9. Transaction data processing 10. Deductive DS 11. Distributive DS 12. Post-relational DS

Learning activities and teaching methods
Monologic (reading, lecture, briefing), Dialogic (discussion, interview, brainstorming)
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.
Passing this course student will be able to design, develop and manage relational database applications for personal use even for school or small firm use. Student should orientate in problematics of database design, creating and optimalizating SQL queries.
Prerequisites
none

Assessment methods and criteria
Written examination

Creation of database, optimization and normalization of the database. Creation of GUI for database. Students have to send finished application as seminar work.
Recommended literature
  • CONOLLY T., BEGG C., HOLOWZAK R. Profesionální průvodce tvorbou databází. Praha, 2009. ISBN 978-80-251-2328-7.
  • Hernandez, M., J. Návrh databází.. Grada, 2006. ISBN 80-247-0900-7.
  • POKORNÝ, J., HALAŠKA, I. Databázové systémy, 2. vydání. Praha, 2003. ISBN 80-01-02789-9.
  • SILBERSCHATZ, A., KORTH H. F., SUDARSHAN, S. Database System Concepts, 5th edition. New York, 2006. ISBN 978-0-07-295886-7.
  • Šimůnek, M. SQL - kompletní kapesní průvodce.. Grada, 2001. ISBN 80-7169-692-7.


Study plans that include the course
Faculty Study plan (Version) Category of Branch/Specialization Recommended year of study Recommended semester
Faculty: Faculty of Education Study plan (Version): information technology and e-learning (2) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: -