Faculty of Technical Sciences

Subject: Database Management Systems (17.E2517)

Native organizations units: Sub-department for Applied Computer Science and Informatics
General information:
 
Category Scientific-professional
Scientific or art field Applied Computer Science and Informatics
ECTS 6

Advanced education of students in the field of Database Management Systems (DBMS) applications, and database (DB) administration, with the possibility of their easy involvement in industry projects in the field of database system development.

Acquiring of skills and knowledge necessary for the application of DBMSs in practice and database administration.

Features and tasks of DBMSs. Physical architecture of a DBMS. Memory management in a DBMS. File management in a DBMS. Physical database organization and performance management. Techniques for the usage of views, sequence generators and indexes at the DB server. Advanced SQL capabilities for database updates and queries. Query optimizers. Mechanisms for providing DB security and safety. DB backup, restore and recovery. Implementation of distributed databases. Software tools for database administration.

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.

Authors Title Year Publisher Language
Grupa autora Priručnici za obezbeđenje administriranja izabranim SUBP 2005 English
Peter A. Carter Pro SQL Server 2019 Administration: A Guide for the Modern DBA (2nd ed.) 2019 Apress English
Bryla Bob, Loney Kevin Oracle Database 11g DBA Handbook 2007 Oracle Press English
Date, C.J. An Introduction to Database Systems, (8th Edition) 2003 Pearson, Boston English
Ramakrishnan R., Gehrke J. Database Management Systems 2000 McGraw Hill, Inc. English
Course activity Pre-examination Obligations Number of points
Complex exercises Yes Yes 10.00
Oral part of the exam No Yes 30.00
Presentation Yes Yes 10.00
Term paper Yes Yes 20.00
Complex exercises Yes Yes 10.00
Complex exercises Yes Yes 10.00
Complex exercises Yes Yes 10.00

Assoc. Prof. Čeliković Milan

Assistant - Master

Lectures

Assistant - Master Matkovski Marijana

Assistant - Master

Computational classes

Faculty of Technical Sciences

© 2024. Faculty of Technical Sciences.

Contact:

Address: Trg Dositeja Obradovića 6, 21102 Novi Sad

Phone:  (+381) 21 450 810
(+381) 21 6350 413

Fax : (+381) 21 458 133
Emejl: ftndean@uns.ac.rs

© 2024. Faculty of Technical Sciences.