PB168 Introduction to DB and IS

Faculty of Informatics
Autumn 2011
Extent and Intensity
2/2. 4 credit(s) (plus extra credits for completion). Type of Completion: zk (examination).
Teacher(s)
doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer)
RNDr. Jaroslav Ráček, Ph.D. (lecturer)
Guaranteed by
prof. RNDr. Luděk Matyska, CSc.
Department of Computer Systems and Communications – Faculty of Informatics
Timetable
Wed 8:00–9:50 B411, Wed 10:00–11:50 B411
Prerequisites
! PB154 Database Systems && ! PB155 Database Systems Applications
Basic knowledge of technical English
Course Enrolment Limitations
The course is only offered to the students of the study fields the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
The aim of the course is to introduce principles of information and database systems to the students. In detail, the issues of database systems will be tackled, especially, the topics about designing, functionality, data modelling, querying and using analytical tools. The aim of one-hour seminars is to excercise selected fenomena in practise. The students will get an idea about the overall problem of design and development of information systems and its individual stages. The students will learn principles of database systems from the theoretical and practical point of view. The students will be able to use a relational database system and query its data.
Syllabus
  • Introduction to information systems. What is an information system, what is its purpose, what is its task and how it is useful. The common structure and components of an information systems, examples. Modern information systems.
  • Design and development of information systems. Life-cycle of information system. Analysis, design, implementation. Deployment, operation and innovation.
  • Introduction to database systems. What is a database management system, what is its task and use, examples. Data abstraction, models, examples.
  • Architecture of database systems. Design of database, querying. Query languages. Architecture of database. Users of database.
  • Entity-relationship model. Atributes, entity sets. Relationships, cardinality. Definition of key, primary key.
  • Relational model. Relation, atributes, relationships. Transition to/from entity-relationship model. Referential integrity.
  • Database design. Functional dependencies. Normal forms. Decomposition.
  • SQL qyery language. Introdution, basic statements. Select, joins.
  • SQL qyery language. Select and aggregation functions. Database updates and deletions. Data definition, views.
  • Query processing. Basic principles, examples. Indexing. Introduction to query optimization.
  • Transactions. Properties of transaction processing. Concurrent transaction processing and planning.
  • Analytical tools. OLAP – Online Analytical Processing. Data mining. Applications of databases.
  • Specifics of database systems. Technology of accessing databases. Geografical information systems. Multidimensional databases. Temporal databases. Data warehouses.
Literature
  • SILBERSCHATZ, Abraham, Henry F. KORTH and S. SUDARSHAN. Database system concepts. 5th ed. Boston: McGraw-Hill, 2006, xxvi, 1142. ISBN 0072958863. info
  • KRÁL, Jaroslav. Informační systémy :specifikace, realizace, provoz. 1. vyd. Veletiny: Science, 1998, 358 s. ISBN 80-86083-00-4. info
Teaching methods
Two-hour lectures and two-hour seminars.
Assessment methods
Written exam.
Language of instruction
Czech
Follow-Up Courses
Further Comments
Study Materials
Listed among pre-requisites of other courses
The course is also listed under the following terms Autumn 2010, Autumn 2012, Autumn 2013, Autumn 2014, Autumn 2015, Autumn 2016, Autumn 2017, Autumn 2018, Autumn 2019, Autumn 2020, Autumn 2021, Autumn 2022, Autumn 2023, Autumn 2024.
  • Enrolment Statistics (Autumn 2011, recent)
  • Permalink: https://is.muni.cz/course/fi/autumn2011/PB168