FI:PB168 Introduction to DB and IS - Course Information
PB168 Introduction to DB and IS
Faculty of InformaticsAutumn 2024
- Extent and Intensity
- 2/2/0. 3 credit(s) (plus extra credits for completion). Type of Completion: zk (examination).
In-person direct teaching - Teacher(s)
- doc. RNDr. Vlastislav Dohnal, Ph.D. (lecturer), prof. Ing. Pavel Zezula, CSc. (deputy)
RNDr. Jaroslav Ráček, Ph.D. (lecturer)
Mgr. David Procházka (assistant) - Guaranteed by
- doc. RNDr. Vlastislav Dohnal, Ph.D.
Department of Machine Learning and Data Processing – Faculty of Informatics
Supplier department: Department of Machine Learning and Data Processing – Faculty of Informatics - Timetable
- Tue 24. 9. 14:00–17:50 D2, Tue 1. 10. 14:00–17:50 D2, Tue 8. 10. 14:00–17:50 D2, Tue 5. 11. 14:00–17:50 D2, Tue 12. 11. 14:00–17:50 D2, Tue 19. 11. 14:00–17:50 D2, Tue 26. 11. 14:00–17:50 D2, Tue 3. 12. 14:00–17:50 D2, Tue 10. 12. 14:00–17:50 D2, Tue 17. 12. 14:00–15:50 D2
- Timetable of Seminar Groups:
PB168/02: Tue 22. 10. 14:00–17:50 D2, V. Dohnal
PB168/03: Tue 29. 10. 14:00–17:50 D2, V. Dohnal - Prerequisites
- ! PB154 Database Systems && !NOW( PB154 Database Systems )
The course assumes knowledge of basic technical English. PB154 is a similar course designed primarily for single-subject Informatics programs. Graduates of PB154 may have PB168 recognized if they have also graduated from PB007. - 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
- Image Processing and Analysis (programme FI, N-VIZ)
- Bioinformatics and systems biology (programme FI, N-UIZD)
- Computer Games Development (programme FI, N-VIZ_A)
- Computer Graphics and Visualisation (programme FI, N-VIZ_A)
- Computer Networks and Communications (programme FI, N-PSKB_A)
- Cybersecurity Management (programme FI, N-RSSS_A)
- Formal analysis of computer systems (programme FI, N-TEI)
- Graphic design (programme FI, N-VIZ)
- Graphic Design (programme FI, N-VIZ_A)
- Hardware Systems (programme FI, N-PSKB_A)
- Hardware systems (programme FI, N-PSKB)
- Image Processing and Analysis (programme FI, N-VIZ_A)
- Information security (programme FI, N-PSKB)
- Informatics (programme FI, B-INF) (3)
- Informatics in education (programme FI, B-IVV) (2)
- Information Security (programme FI, N-PSKB_A)
- Quantum and Other Nonclassical Computational Models (programme FI, N-TEI)
- Cybersecurity (programme FI, B-CS)
- Computer graphics and visualisation (programme FI, N-VIZ)
- Computer Networks and Communications (programme FI, N-PSKB)
- Business Informatics (programme ESF, B-POIN)
- Principles of programming languages (programme FI, N-TEI)
- Programming and development (programme FI, B-PVA)
- Cybersecurity management (programme FI, N-RSSS)
- Services development management (programme FI, N-RSSS)
- Software Systems Development Management (programme FI, N-RSSS)
- Services Development Management (programme FI, N-RSSS_A)
- Software Systems Development Management (programme FI, N-RSSS_A)
- Software systems (programme FI, N-PSKB)
- Machine learning and artificial intelligence (programme FI, N-UIZD)
- Teacher of Informatics and IT administrator (programme FI, N-UCI)
- Informatics for secondary school teachers (programme FI, N-UCI) (2)
- Computer Games Development (programme FI, N-VIZ)
- Processing and analysis of large-scale data (programme FI, N-UIZD)
- Natural language processing (programme FI, N-UIZD)
- 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.
- Learning outcomes
- Student will be able to:
- Explain basic principles and procedures in designing software;
- Apply these procedures to create a model of smaller information system;
- Explain the principles of relational database management systems;
- Design and implement relational model for data storage in the information system;
- Formulate basic SQL statements (data updates and querying in particular);
- Be familiar with the issues of analysis and design of data-oriented information systems. - 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.
- 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.
- Design and development of information systems. Life-cycle of information system. Analysis, design of systems. Structured analysis. Data Flow Diagram, mini-specification.
- Use case diagram. Sequence diagram. Class diagram.
- Principles of structured analysis based on YMSA and SSADM. Functional decomposition. Balancing functional and data models.
- Literature
- recommended literature
- SILBERSCHATZ, Abraham, Henry F. KORTH and S. SUDARSHAN. Database system concepts. 5th ed. Boston: McGraw-Hill, 2006, xxvi, 1142. ISBN 0072958863. info
- RÁČEK, Jaroslav. Strukturovaná analýza systémů (Structured system analysis). Brno: Masarykova univerzita, 2006, 104 pp. FI. ISBN 80-210-4190-0. 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, developing individual project (data and process models, SQL).
- Language of instruction
- Czech
- Follow-Up Courses
- Further Comments
- Study Materials
- Listed among pre-requisites of other courses
- Enrolment Statistics (recent)
- Permalink: https://is.muni.cz/course/fi/autumn2024/PB168