Subject: Databases 2 (17 - RI43B)


Basic Information

CategoryScientific-professional
Scientific or art field:Applied Computer Science and Informatics
InterdisciplinaryNo
ECTS4
Course specification

Course is active from 01.10.2012..

Adopting the techniques and methods of database design and advanced techniques of implementation, use and maintenance of databases.
Students acquire advanced knowledge on database design, which is further used in the practice and specialized courses in Software Design, Information System Engineering, Business Informatics, and Database Systems.
Functional dependencies and algorithms for generating relation scheme keys. Multivalued and join dependencies. Normal forms and design criteria for structuring relational database schema. Decomposition method. Synthesis method. Transformations of ER database schemas into relational data model. Methodological approaches to database schema design process. CASE tools for database schema design.
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.
AuthorsNameYearPublisherLanguage
Mogin, P., Luković, I., Govedarica, M.Principi projektovanja baza podataka2004Fakultet tehničkih nauka, Novi SadSerbian language
Mogin, P., Luković, I.Principi baza podataka1996Fakultet tehničkih nauka, Novi SadSerbian language
Date, C.J.An Introduction to Database Systems, (8th Edition)2003Pearson, BostonEnglish
Ramez Elmasri, Shamkant B. NavatheFundamentals of Database Systems (7th edition)2016Pearson, London, UK, ISBN:978-1292097619English
Course activity Pre-examination ObligationsNumber of points
Complex exercisesYesYes10.00
Complex exercisesYesYes10.00
Complex exercisesYesYes15.00
Project taskYesYes15.00
ProjectYesYes20.00
Oral part of the examNoYes30.00
Name and surnameForm of classes
Missing picture!

Čeliković Milan
Assistant Professor

Lectures
Missing picture!

Ivančević Vladimir
Associate Professor

Lectures
Missing picture!

Vučinić Milica
Assistant - Master

Computational classes
Missing picture!

Jelić Milena
Teaching Associate

Computational classes
Missing picture!

Tomić Miroslav
Assistant - Master

Computational classes