Course: Database Systems I

« Back
Course title Database Systems I
Course code KIN/DBS1A
Organizational form of instruction Lecture + Lesson
Level of course Bachelor
Year of study 2
Semester Winter
Number of ECTS credits 6
Language of instruction Czech
Status of course Compulsory
Form of instruction unspecified
Work placements unspecified
Recommended optional programme components None
Lecturer(s)
  • Klofáč Patrik, Mgr.
  • Beránek Ladislav, doc. Ing. CSc.
  • 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 relational database, it's optimalization and normalization (creating DB on SQL school server). Creating documentation including ER and relational models.
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): Introductory teacher training course in information technology (3) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Introductory teacher training course in information technology (2) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Introductory teacher training course in information technology (4) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Introductory teacher training course in information technology (3) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Introductory teacher training course in information technology (4) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Introductory teacher training course in information technology (1) Category: Pedagogy, teacher training and social care 3 Recommended year of study:3, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): information technology and e-learning (3) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Winter
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: Winter
Faculty: Faculty of Education Study plan (Version): Introductory teacher training course in information technology (5) Category: Pedagogy, teacher training and social care 3 Recommended year of study:3, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Introductory teacher training course in information technology (2) Category: Pedagogy, teacher training and social care 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Education Study plan (Version): Introductory teacher training course in information technology (5) Category: Pedagogy, teacher training and social care 3 Recommended year of study:3, Recommended semester: Winter