Course details
Information Systems
IIS Acad. year 2020/2021 Winter semester 4 credits
An information system as a special case of a system. Kinds of information systems OLAP and OLTP. History of information systems. The technology of information system with a relational database system building. Internet type of information system. The technology of client and server programming (JavaScript and PHP). The technology of XML language.
Guarantor
Course coordinator
Language of instruction
Completion
Time span
- 26 hrs lectures
- 13 hrs projects
Assessment points
- 51 pts final exam (written part)
- 19 pts mid-term test (written part)
- 30 pts projects
Department
Lecturer
Instructor
Subject specific learning outcomes and competences
Ability to model especially economic reality in the information system. Ability and knowledge to implement information systems under database technologies in the internet environment.
Learning objectives
To obtain a common overview of information system branch. To get a basic knowledge of information systems based on the relational database technology. To get a basic knowledge of communication part of IS based on internet technology.
Why is the course taught
Efficient access to information is crucial not only in business management, but in virtually all areas of human activity. The course provides a comprehensive overview of methods of analysis and design of information systems, as well as current technologies used for their implementation.
Recommended prerequisites
Prerequisite knowledge and skills
relational database theory, computer networks and protocols
Study literature
- BRUCKNER, Tomáš et al. Tvorba informačních systémů: principy, metodiky, architektury. Praha: Grada, 2012. ISBN 978-80-247-4153-6.
- Tuček, J.: Geografické informační systémy. Principy a praxe., Computer Press Brno 1998, 424 str., ISBN 80-7226-091-X.
- McLeod, R.: Management Information Systems, Prentice Hall International London 1998, 655 str., ISBN 0-13-896101-8.
- BASL, Josef a Roman BLAŽÍČEK. Podnikové informační systémy: podnik v informační společnosti. 3., aktualiz. a dopl. vyd. Praha: Grada, 2012, 323 s. ISBN 978-80-247-4307-3. (in Czech).
Syllabus of lectures
- Information and information system, basic terms, model and its presentation, classification.
- Consistence, basic data structures, structure, collection, object.
- Serialization - basic formats.
- Serialization - markup languages SGML/XML (DTD)
- Serialization - XML, DOM
- Visualization - HTML, XPath, XSLT.
- Visualization - extended, DOM manipulation, JavaScript, client JavaScript.
- Server - PHP, information systems application on server, database connection.
- Information Systems Architecture - distributed information systems.
- OLTP - processes and their models, transactions.
- The methodology of OLTP information system design, three-tier architecture, example.
- OLAP information systems, data warehouses
- Other information systems..
Syllabus - others, projects and individual work of students
- Design of an information system according to the specification
- Implementation of the designed system on a specified platform
Progress assessment
- Midterm test - 19 points
- Project - 30 points
- Final written exam - 51 points, at least 20 points required
- At least 25 points must be obtained during the semester
Exam prerequisites:
At least 25 points obtainable during the semester.
Controlled instruction
Midterm exam, the realization of a project in due dates. In the case of a reported obstacles to submitting the project, the student will be allowed to submit the project in an alternative date.
Exam prerequisites
At least 25 points obtainable during the semester.
Course inclusion in study plans