JAN EVANGELISTA PURKYNĚ UNIVERSITY IN ÚSTÍ NAD LABEM
Study programmes & Course catalogue
for academic year 2024/2025
JAN EVANGELISTA PURKYNĚ UNIVERSITY IN ÚSTÍ NAD LABEM
Česky
Search

Course: Database Systems

« Back
Course title Database Systems
Course code KI/DSY
Organizational form of instruction Lecture + Lesson
Level of course Bachelor
Year of study 3
Semester Winter
Number of ECTS credits 5
Language of instruction Czech
Status of course Compulsory
Form of instruction unspecified
Work placements unspecified
Recommended optional programme components None
Lecturer(s)
  • Sýkorová Květuše, Mgr.
  • Maškov Viktor, doc. RNDr. Mgr. DrSc.
  • Fišer Jiří, Mgr. Ph.D.
Course content
1. Basic principles and history of database systems progress. 2. Basic conceptions. 3. Database systems architecture. 4. Conceptual data modeling (ER model). 5. Relational data model. 6. Conceptual model to relational model transformation. 7. Database desing. 8. Normalization of relational model. 9. Database languages - SQL basics. 10. Principles of objective-relational desing. 11. Transactional database systems.

Learning activities and teaching methods
unspecified
Learning outcomes
Aim of this course is to gain basic theoretical knowledge of database systems design oriented to relational systems. Design of models combines three ways of data processing: conceptual modelling (ER model), database modelling (relational model using normal forms) and object-relational modelling (object oriented concept).

Prerequisites
unspecified
KI/ADS
----- or -----
KI/DSA
----- or -----
KI/XADS

Assessment methods and criteria
unspecified
Recommended literature
  • Hernandez M.J. Návrh databází. Grada, Praha, 2006.
  • Hernandez M.J., Viescas J.L. Myslíme v jazyku SQL - tvorba dotazů. GRADA Publishing, Praha, 2005.
  • Lacko L. SQL: hotová řešení. Computer Press, Brno, 2003. ISBN 80-7226-975-5.
  • Pokorný J., Halaška I. Databázové systémy. ČVUT Fakulta elektrotechnická, Praha, 2003.
  • Pokorný J., Valenta M. Databázové systémy. ČVUT, Praha, 2013. ISBN 978-80-01-05212-9.
  • Sheldon R. SQL - začínáme programovat. GRADA Publishing, Praha, 2005.
  • Steven R. MS Access Návrh a programování databází. Computer Press, Brno, 1999.
  • Šimonová S., Panuš J. Databázové systémy I. Univerzita Pardubice, 2007.
  • Šimůnek M. SQL: kompletní kapesní průvodce. Grada Publishing, Praha, 1999. 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 Science Study plan (Version): Information Sciences (double subject) (A14) Category: Informatics courses 3 Recommended year of study:3, Recommended semester: Winter
Faculty: Faculty of Science Study plan (Version): Information Systems (A14) Category: Informatics courses 2 Recommended year of study:2, Recommended semester: Winter
Faculty: Faculty of Science Study plan (Version): Information Sciences (double subject) (A14) Category: Informatics courses 3 Recommended year of study:3, Recommended semester: Winter
JAN EVANGELISTA PURKYNĚ UNIVERSITY IN ÚSTÍ NAD LABEM, date of update: 01.11.2024 23:51. Data created for academic year 2024/2025