Courses – Fakultet tehničkih nauka u Novom Sadu

Subject: Database Systems (17.E2I40)

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

Type of studies	Title
Undergraduate Academic Studies	Software Engineering and Information Technologies (Godina: 4, Summer)

General information:

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

Educational goal:

Advanced education of students in the field of databases (DB), with a possibility of their easy involvement in industry projects in the field of DB and information system development.

Educational outcome:

Acquiring knowledge and skills necessary for the application of special techniques of DB design. Acquiring knowledge about new data models and special applications of database systems. Learning DB server programming techniques.

Course content:

Common concepts and desirable characteristics of data models. Classification and types of data model constraints. Formal specification of DB constraints. Advanced capabilities of SQL in specifying database schemas and data manipulation. Server programming techniques (programming at the level of a DBMS). Techniques of automated design and integration of DB schema. Object-oriented and Object-Relational databases. XML databases. Temporal databases. Distributed databases.

Teaching methods:

Teaching is performed through lessons, oral and computer exercises (in the computer classroom), as well as consultations. Through the teaching process, students are constantly motivated to an intensive discussion, problem oriented reasoning, independent study work and active participation in the whole lecturing process. The prerequisite to enter final exam is to complete all the pre-exam assignments by earning at least 30 points.

Literature:

Authors	Title	Year	Publisher	Language
Mogin, P., Luković, I., Govedarica, M.	Principi projektovanja baza podataka	2004	Fakultet tehničkih nauka, Novi Sad	Serbian language
Ramakrishnan R., Gehrke J.	Database Management Systems	2000	Mc Graw Hill	English
Groff, James R., Weinberg, Paul N., Oppel, Andrew J.	SQL: The Complete Reference, 3rd Edition	2009	McGraw-Hill, Inc.	English
Date, C.J.	An Introduction to Database Systems, (8th Edition)	2003	Pearson, Boston	English
Feuerstein Steven, Pribyl Bill	Oracle PL/SQL Programming: Covers Versions Through Oracle Database 11g Release 2 (Animal Guide)	2009	OReilly Media, Inc.	English
Kordić, S. i dr.	Baze podataka : zbirka zadataka	2018	Fakultet tehničkih nauka, Novi Sad	Serbian language