FI:PB168 Introduction to DB and IS - Course Information
PB168 Introduction to DB and IS
Faculty of InformaticsAutumn 2016
- 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), prof. Ing. Pavel Zezula, CSc. (deputy)
RNDr. Jaroslav Ráček, Ph.D. (lecturer) - Guaranteed by
- doc. RNDr. Eva Hladká, Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Supplier department: Department of Computer Systems and Communications – Faculty of Informatics - Timetable
- Thu 8:00–11:50 A218
- Prerequisites
- ! PB154 Database Systems && !NOW( PB154 Database Systems )
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
- there are 13 fields of study the course is directly associated with, display
- Course objectives
- The aim of the course is to introduce principles of information and database systems to the students. In detail, issues of creating information systems that use database systems will be tackled. Especially, we focus on the topics of software engineering, database design and data modeling, querying and other functionality including analytical tools. The aim of one-hour seminars is to exercise selected phenomena in practice. 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 points of view. The students will be able to use a relational database system, store 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 of systems. Structured analysis. Data Flow Diagram, minispecification.
- Yourdon structured analysis. System interface model. Function model. Functional decomposition.
- UML. Use case diagram. Sequence diagram. Class diagram.
- 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. Attributes, entity sets. Relationships, cardinality. Definition of key, 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. Select, 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 tools. OLAP – Online Analytical Processing. Data mining. Applications of databases.
- Specifics of database systems. Technology of accessing databases. Geographical information systems. Multidimensional databases. Temporal databases.
- Literature
- 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
- Enrolment Statistics (Autumn 2016, recent)
- Permalink: https://is.muni.cz/course/fi/autumn2016/PB168