Subject: Databases 1 (17 - IFE214)


Basic Information

CategoryProfessional-applicative
Scientific or art field:Applied Computer Science and Informatics
InterdisciplinaryNo
ECTS8
Native organizations units

Course native organizational units not found!
Course specification

Course is active from 30.09.2005..


Precondition courses

Course idMandatoryMandatory
Theory of AlgorithmsYesYes
Mathematical LogicYesYes
Basic education of students from the Information Engineeering in databases. Students gain fundamental knowledge in databases and learn basic techniques of implementation, use and maintenance of databases, with an accent to the applications in the area of data science and big data processing.
Students acquire basic knowledge on ER and relational data models, the SQL language and file organization, which is further used in the practice and specialized courses in: Databases 2, Software Specification and Modeling, Information System Engineering, Business Informatics, and Database Systems.
Databases and their role in the development and exploitation of information systems. Basic notions and concepts in databases, Database management system. Data models. ER data model; Relational data model. Relational algebra. Types of database constraints in relational data model. Functional dependency and the relation scheme key. Fundamentals of database design. The database management system language SQL. Physical data structures and file systems. Methods and process of file organization. Pile, Sequential, Hash, Index-Sequential and Index B-tree file organization. Transaction data processing.
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
Mihajlović, D.Informacioni sistemi i projektovanje baza podataka1998Fakultet tehničkih nauka, Novi SadSerbian language
Mogin, P.Strukture podataka i organizacija datoteka1994Student, Novi SadSerbian language
Mogin, P., Luković, I.Principi baza podataka1996Fakultet tehničkih nauka, Novi SadSerbian language
Groff, James R., Weinberg, Paul N., Oppel, Andrew J.SQL: The Complete Reference, 3rd Edition2009McGraw Hill, Inc.English
Date, C.J.An Introduction to Database Systems, (8th Edition)2003Pearson, BostonEnglish
Kordić, S. i dr.Baze podataka : zbirka zadataka2018Fakultet tehničkih nauka, Novi SadSerbian language
Course activity Pre-examination ObligationsNumber of points
Complex exercisesYesYes10.00
Complex exercisesYesYes10.00
Complex exercisesYesYes10.00
Complex exercisesYesYes10.00
Complex exercisesYesNo10.00
Project taskYesYes15.00
Project taskYesYes15.00
Oral part of the examNoYes30.00
Name and surnameForm of classes
Missing picture!

Kordić Slavica
Associate Professor

Lectures
Missing picture!

Čeliković Milan
Assistant Professor

Lectures
Missing picture!

Dimitrieski Vladimir
Assistant Professor

Practical classes
Missing picture!

Todorović Nikola
Assistant - Master

Practical classes
Missing picture!

Vještica Marko
Assistant - Master

Practical classes
Missing picture!

Ignjatijević Aleksandar
Teaching Associate

Practical classes
Missing picture!

Vještica Marko
Assistant - Master

Computational classes
Missing picture!

Tomić Miroslav
Assistant - Master

Computational classes
Missing picture!

Kiš Gergelj
Teaching Associate

Computational classes
Missing picture!

Todorović Nikola
Assistant - Master

Computational classes