Information Systems and Databases | Faculty of Technical Sciences

Subject: Information Systems and Databases (17.GI205)

Native organizations units: Sub-department for Applied Computer Science and Informatics

Type of studies	Title
Undergraduate Academic Studies	Geodesy and Geoinformatics (Year: 2, Semester: Winter)

General information:

Category	Professional-applicative
Scientific or art field	Geoinformatika Applied Computer Science and Informatics
ECTS	4

Basic education in the field of information systems and databases. Enabling students in following projects in the filed of information system and database development.

Introduction to the notion and role of information systems in an organization system. Introduction to current data models, especially relation model. Mastering basic techniques in the application of structured query language (SQL) on database servers.

Types of information systems. Procedures for developing information systems. Notion of a database (DB). Database management system. Basic concepts and properties of data models. ER data model. Relational data model. Classification and types of limitations in relational data model. Usage of the query language SQL in describing database schemes and in data manipulation in DB. Basic transaction processing. Transformations of ER database schema into relational data model.

Teaching is held in the form of lectures, auditory and computer practice (in computer laboratory) and consultations. During the entire teaching process, students are encouraged to participate in an active communication, critical thinking, individual work, as well as in active relationship toward the teaching process. A precondition for obtaining the signature of attendance and for taking the final examination is to complete all the pre-exam assignments by earning at least 30 points.