SubjectsSubjects(version: 964)
Course, academic year 2024/2025
   Login via CAS
Database Systems - NDBI025
Title: Databázové systémy
Guaranteed by: Department of Software Engineering (32-KSI)
Faculty: Faculty of Mathematics and Physics
Actual: from 2022
Semester: winter
E-Credits: 5
Hours per week, examination: winter s.:2/2, C+Ex [HT]
Capacity: unlimited
Min. number of students: unlimited
4EU+: no
Virtual mobility / capacity: no
State of the course: taught
Language: Czech, English
Teaching methods: full-time
Guarantor: doc. RNDr. Jakub Lokoč, Ph.D.
Teacher(s): RNDr. Michal Kopecký, Ph.D.
doc. RNDr. Jakub Lokoč, Ph.D.
Mgr. Ladislav Peška, Ph.D.
Class: Informatika Bc.
Classification: Informatics > Database Systems
Incompatibility : NDBX025
Interchangeability : NDBX025
Is incompatible with: NDBI002, NDBX025
Is pre-requisite for: NDBI026, NDBI004, NDBI014, NDBI022, NSWI049, NDBI030, NDBI017, NDBI009, NDBI039, NSWI135
Is interchangeable with: NDBX025, NDBI002, NUIN010
Annotation -
An introductory course presenting a survey of the field. It covers database system architectures and the three levels of database schemata. Conceptual modelling is based on the ER and UML model. Basic theory of the relational data model is studied (relational algebra, normal forms). Transactions, parallel DB management. Basic methods for multimedia search. Summary of data file formats. Modern (non-relational) database systems.
Last update: Zavoral Filip, RNDr., Ph.D. (13.05.2022)
Course completion requirements -

The credit is conditioned by obtaining at least half of maximal number of points in the credit test.

The exam is accomplished by written test (after the obtaing the credit). The grade is derived from the sum of points from the exam test.

The credit test and the exam test can be - in case of impossibility of contact teaching - also given in the form of an online test,

which will take place on a specified date, similarly as if it had taken place during a normal class.

Last update: Kopecký Michal, RNDr., Ph.D. (30.04.2020)
Literature - Czech
  • Pokorný J., Halaška I.: Databázové systémy. FEL ČVUT Praha, 2003.
  • Pokorný, J., Valenta, M.: Databázové systémy. 2. přeprac. vydání, Česká technika - nakladatelství ČVUT, 2020.
  • Pokorný J, Žemlička M..: Základy implementace souborů a databází. UK Praha, Karolinum, 2004.
  • Ramakrishnan R., Gehrke J.: Database Management Systems, McGraw-Hill Science, 2003

Last update: Töpfer Pavel, doc. RNDr., CSc. (25.05.2022)
Syllabus -
  • 1) Introduction to data modeling
  • 2) Conceptual modeling of structured data
  • 3) Logical data models
  • 4) Relational model - data definition
  • 5) Relational model - SQL querying
  • 6) Relational model - selected formal methods
  • 7) Transactions
  • 8) Modern (non-relational) database systems
  • 9) Unstructured data - multimedia
  • 10) Data file formats
  • 11) Architectures of database systems

Last update: Töpfer Pavel, doc. RNDr., CSc. (25.05.2022)
 
Charles University | Information system of Charles University | http://www.cuni.cz/UKEN-329.html