Courses – Fakultet tehničkih nauka u Novom Sadu

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 (Godina: 2, Winter)

General information:

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

Educational goal:

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

Educational outcome:

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.

Course content:

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 methods:

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.

Literature:

Authors	Title	Year	Publisher	Language
Mihajlović, D.	Informacioni sistemi i projektovanje baza podataka	1998	Fakultet tehničkih nauka, Novi Sad	Serbian language
Date, C.J.	An Introduction to Database Systems, (8th Edition)	2003	Pearson, Boston	English
Mogin, P., Luković, I.	Principi baza podataka	1996	Fakultet tehničkih nauka, Novi Sad	Serbian language
Kordić, S. i dr.	Baze podataka : zbirka zadataka	2018	Fakultet tehničkih nauka, Novi Sad	Serbian language