MDA104 Introduction to Databases

Faculty of Science
Autumn 2024
Extent and Intensity
0/0/0. 6 credit(s). Type of Completion: zk (examination).
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
Guaranteed by
doc. RNDr. Vlastislav Dohnal, Ph.D.
Department of Mathematics and Statistics – Departments – Faculty of Science
Supplier department: Department of Machine Learning and Data Processing – Faculty of Informatics
Prerequisites
no prerequisites
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives
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.
Learning outcomes
- 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.
Syllabus
  • 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.
Literature
    recommended literature
  • SILBERSCHATZ, Abraham, Henry F. KORTH and S. SUDARSHAN. Database system concepts. 6th ed. Boston: McGraw-Hill, 2011, xxvi, 1139. ISBN 9780073523323. info
    not specified
  • DOUGLAS, Korry and Susan DOUGLAS. PostgreSQL : the comprehensive guide to building, programming and administering PostgreSQL databases. 2nd ed. Indianapolis: Sams Publishing, 2006, xxi, 1006. ISBN 0672327562. info
Teaching methods
Essentially asynchronous approach, based on introductory short presentations plus homework assignments, complete pdf materials. Complemented with synchronous communication by the tutor upon agreement.
Assessment methods
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.
Language of instruction
English
  • Enrolment Statistics (recent)
  • Permalink: https://is.muni.cz/course/sci/autumn2024/MDA104