MDA104 Introduction to Databases

Přírodovědecká fakulta
podzim 2024
Rozsah
0/0/0. 6 kr. Ukončení: zk.
Vyučující
doc. RNDr. Vlastislav Dohnal, Ph.D. (přednášející)
Garance
doc. RNDr. Vlastislav Dohnal, Ph.D.
Ústav matematiky a statistiky – Ústavy – Přírodovědecká fakulta
Dodavatelské pracoviště: Katedra strojového učení a zpracování dat – Fakulta informatiky
Předpoklady
no prerequisites
Omezení zápisu do předmětu
Předmět je otevřen studentům libovolného oboru.
Cíle předmětu
The aim of the course is to introduce principles of database systems and data modelling. In detail, issues of data modelling, database design, querying and other functionality including analytical tools will be tackled from the relational database systems point of view.
Výstupy z učení
- Explain the principles of relational database management systems; - Design and implement relational model for data storage; - Formulate SQL statements (data updates and querying); - Be familiar with analytical extensions and programming in databases.
Osnova
  • Introduction to database systems. Purpose and use, examples. Data abstraction, models, examples.
  • Architecture of database systems. Architecture of database. Users of database. Design of database. Query languages.
  • Entity-relationship model. Attributes, entity sets. Relationships, cardinality. Definition of key, key hierarchy, primary key.
  • Relational model. Relation, attributes, relationships. Transition to/from entity-relationship model. Referential integrity.
  • Database design. Functional dependencies. Normal forms. Decomposition.
  • SQL query language. Introduction, basic statements. Functions and expressions, joins, aggregation functions. Database updates and deletions. Data definition, views.
  • Query processing. Basic principles, examples. Indexing. Introduction to query optimization. Transactions. Properties of transaction processing.
  • Analytical extensions. Online Analytical Processing. Data mining. Geographical information systems. Multidimensional databases. Temporal databases.
Literatura
    doporučená literatura
  • SILBERSCHATZ, Abraham, Henry F. KORTH a S. SUDARSHAN. Database system concepts. 6th ed. Boston: McGraw-Hill, 2011, xxvi, 1139. ISBN 9780073523323. info
    neurčeno
  • DOUGLAS, Korry a Susan DOUGLAS. PostgreSQL : the comprehensive guide to building, programming and administering PostgreSQL databases. 2nd ed. Indianapolis: Sams Publishing, 2006, xxi, 1006. ISBN 0672327562. info
Výukové metody
Essentially asynchronous approach, based on introductory short presentations plus homework assignments, complete pdf materials. Complemented with synchronous communication by the tutor upon agreement.
Metody hodnocení
Homework assignments during the semester, including peer to peer reviews. Active presentation of some homeworks to the lecturer/tutor. Final synchronously written assignment, followed by colloquial discussions/exams in small groups.
Vyučovací jazyk
Angličtina
  • Statistika zápisu (nejnovější)
  • Permalink: https://is.muni.cz/predmet/sci/podzim2024/MDA104