Course detail

Information Systems

FSI-VISAcad. year: 2013/2014

Course is focused on gaining basic knowledge and skill necessary for effective design of information systems. From practical point of view there is focus on standards, used technologies and work with databases. From theoretical point of view will the student be shown enough theoretical information for understanding the essence of application areas (database normalization, regular expressions, etc.).

Language of instruction

Czech

Number of ECTS credits

5

Mode of study

Not applicable.

Guarantor

prof. Ing. Pavel Ošmera, CSc.

Department

Institute of Automation and Computer Science (ÚAI)

Learning outcomes of the course unit

The acquired knowledge will be sufficient for the basic orientation in the Theory of Information.

Prerequisites

Basic mathematical knowledge is required.

Co-requisites

Not applicable.

Planned learning activities and teaching methods

The course is taught through lectures explaining the basic principles and theory of the discipline. Exercises are focused on practical topics presented in lectures.

Assesment methods and criteria linked to learning outcomes

The active participation and mastering the assigned task.

Course curriculum

Not applicable.

Work placements

Not applicable.

Aims

The course objective is to make students familiar with the basics of the Theory of information.

Specification of controlled education, way of implementation and compensation for absences

Solving an extra assignment can compensate absence.

Recommended optional programme components

Not applicable.

Prerequisites and corequisites

Not applicable.

Basic literature

Connolly, T. and Begg, C.: Database Systems: A Practical Approach to Design, Implementation, and Management. Addison Wesley, New York, 2009.
Elmasri, R. and Navathe, S.B.: Fundamentals of Database Systems. Addison Wesley, New York, 2010.
Garcia-Molina, H., Ullman, J.D. and Widom, J.D.: Database Systems: The Complete Book. Prentice Hall, New Jersey, 2008.
Rob, P. and Coronel, C.M.: Database Systems: Design, Implementation and Management. Course Technology, 2007.

Recommended reading

Date, C.J.: An Introduction to Database Systems. Addison Wesley, New York, 2003.
Lacko, L.: Web a databáze. COMputer Press, 2001
Welling, L. and Thomson, L.: PHP and MySQL Web Development. Addison-Wesley, New York, 2008.

Classification of course in study plans

  • Programme N2301-2 Master's

    branch M-AIŘ , 1 year of study, summer semester, compulsory

Type of course unit

 

Lecture

26 hod., optionally

Teacher / Lecturer

prof. Ing. Pavel Ošmera, CSc.

Syllabus

1. Term information and information system, model and its realization, OLAP and OLTP.
2. Information system as exchange of documents, HTML as type of document, DOM, XML technology.
3. Server side of information system (introduction to PHP/Java).
4. Client side of information system (introduction to JavaScript/Java).
5. Conceptual modeling. Relation model of data. Transformation of model.
6. SQL (definition of data, SELECT statement).
7. SQL (more statements, views, cursors, etc.).
8. Introduction to practical database design. Essence and usage of indexing and hashes. Query execution optimization.
9. Introduction to database normalization and usage of normalization in database design.
10. Client/server architecture. Database triggers and stored procedures. Ensuring data integrity. Ensuring data security.
11. POSIX, PCRE, introduction to regular expressions.
12. Current trends in development of DB technology. Access to databases from WWW.
13. Grids, virtualization, cloud solution (e.g. Amazon Web Services, IBM Global Technology Services)

Computer-assisted exercise

26 hod., compulsory

Teacher / Lecturer

prof. Ing. Pavel Ošmera, CSc.

Syllabus

The practical exercises will be follow the context of lectures. The practical examples will be supported the theoretical knowledge of the students.