Course details
Information Systems
IIS Acad. year 2017/2018 Winter semester 4 credits
Information system as a special case of a system. Kinds of information systems OLAP and OLTP. History of information systems. Technology of information system with relational database system building. Internet type of information system. Technology of client and server programming (JavaScript and PHP). Technology of XML language.
Guarantor
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
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 common overview of information system branch. To get basic knowledge of information systems based on the relational database technology. To get basic knowledge of communication part of IS based on internet technology.
Recommended prerequisites
Prerequisite knowledge and skills
relational database theory, computer networks and protocols
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.
- Methodology of OLTP information system design, three-teer architecture, example.
- OLAP information systems, data warehouses
- Other information systems..
Progress assessment
At least 25 points obtainable during the semester (checking of the continuous and project).
Controlled instruction
The minimal number of points which can be obtained from the final exam is 20. Otherwise, no points will be assign to the student.
Course inclusion in study plans