Faculty of Technical Sciences

Subject: Database Systems (17.IZOO57)

General information:
 
Category Professional-applicative
Scientific or art field
  • Inženjerstvo informacionih sistema
  • Information-Communication Systems
ECTS 5

Advanced education in database systems, with developing of students ability to involve in real-world projects of database design and implementation. Given the extremely dynamic development of commercial tools in this area, an important goal is to enable students to a systematic approach to the study of new tools that will enable them to quickly and easily master their use.

Students will get hands-on experience with: designing stored functions, procedures and triggers in a relational database system; explaining the basic principles and common trade-offs in relational database query optimization and transaction management; explaining the basic principles of database concurrency control, database distribution, safety, security and recovery.

Characteristics and capabilities of database systems (DBS) / database management systems (DBMS). Transactional data processing. Transaction management system and data sharing and multiuser environment. Database security, safety and recovery. Data dictionary. Realization of database schema on a database server. Server programming techniques. Distributed databases. Database file organization. Query processing and query optimization. Database design methods.

Lectures; laboratory exercises; individual consultations; team and individual work (assignments, complex exercises and project). Students are encouraged to communicate, to reason critically, to work independently and in the team, and to contribute actively to teaching process.

Authors Title Year Publisher Language
Date C. J. SQL and Relational Theory: How to Write Accurate SQL Code 3/E 2015 OReilly Media English
Date, C.J. An Introduction to Database Systems, (8th Edition) 2003 Pearson, Boston English
Coronel C., Morris S. Database Systems: Design, Implementation, & Management, 11/E 2014 Course Technology English
Shekhar, S., Chawla, S. Spatial Databases: A Tour 2003 Prentice-Hall, New Jersey English
Elmasri R, Navathe S. Fundamentals of Database Systems, 7/E 2015 Pearson Education Ltd. English
Course activity Pre-examination Obligations Number of points
Complex exercises Yes Yes 25.00
Test Yes Yes 10.00
Test Yes Yes 10.00
Complex exercises Yes Yes 10.00
Oral part of the exam No Yes 30.00
Project task Yes Yes 15.00
API Image

Prof. Ristić Sonja

Full Professor

Lectures
API Image

Assistant - Master Antanasijević Dajana

Assistant - Master

Computational classes
API Image

Assistant - Master Gladić Dejana

Assistant - Master

Computational classes
API Image

Assistant - Master Petrovački Jelena

Assistant - Master

Computational classes
API Image

Assistant - Master Krstić Dušan

Assistant - Master

Computational classes
API Image

Assistant - Master Koprivica Sara

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.