Courses – Fakultet tehničkih nauka u Novom Sadu

Subject: Introduction to databases (17.ESI128)

Native organizations units: No data

Type of studies	Title
Undergraduate Academic Studies	Power Software Engineering (Godina: 3, Winter)

General information:

Category	Professional-applicative
Scientific or art field	Primenjeno softversko inženjerstvo
Interdisciplinary	No
ECTS	8

Educational goal:

Basic students' education in databases. Students gain fundamental knowledge in databases and learn basic techniques of implementation, use and maintenance of databases.

Educational outcome:

Students will gain basic knowledge in data mdeling (entity-relationship model and relational data model), relational database language (SQL) i physical data organization on the disk. The listed knowledge is further used in subjects: Database Design, and Business Intelligence and Data Warehouse Systems in Infrastructural Systems.

Course content:

Basic notions and definition of database. The role of database in software systems. Database management systems (DBMS). Data models - entity-relationship and relational data model. Mathematical formalisms for database usage. Database integrity component. Basics of database design. Physical data structures on the hard disc and file organization methods. Serial, sequential, hash, index-sequential, and file organization with index trees. Database indices. Database transactions. Advanced DBMS data processing.

Teaching methods:

Teaching is performed through lessons, oral and computer exercises, 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.	Strukture podataka i organizacija datoteka	1994	Student, Novi Sad	Serbian language
Mogin, P., Luković, I.	Principi baza podataka	1996	Fakultet tehničkih nauka, Novi Sad	Serbian language
Date, C.J.	An Introduction to Database Systems, (8th Edition)	2003	Pearson, Boston	Serbian language

Knowledge evaluation:

Course activity	Pre-examination	Obligations	Number of points
Complex exercises	Yes	Yes	10.00
Oral part of the exam	No	Yes	30.00
Project task	Yes	Yes	15.00
Complex exercises	Yes	No	10.00
Complex exercises	Yes	Yes	10.00
Complex exercises	Yes	Yes	10.00
Project task	Yes	Yes	15.00
Complex exercises	Yes	Yes	10.00