Courses – Fakultet tehničkih nauka u Novom Sadu

Subject: Databases 2 (17.RI43B)

Native organizations units: Sub-department for Applied Computer Science and Informatics

Type of studies	Title
Undergraduate Academic Studies	Software Engineering and Information Technologies (Godina: 4, Winter)

General information:

Category	Scientific-professional
Scientific or art field	Applied Computer Science and Informatics
Interdisciplinary	No
ECTS	4

Educational goal:

Adopting the techniques and methods of database design and advanced techniques of implementation, use and maintenance of databases.

Educational outcome:

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.

Course content:

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 methods:

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.

Literature:

Authors	Title	Year	Publisher	Language
Ramez Elmasri, Shamkant B. Navathe	Fundamentals of Database Systems (7th edition)	2016	Pearson, London, UK, ISBN:978-1292097619	English
Date, C.J.	An Introduction to Database Systems, (8th Edition)	2003	Pearson, Boston	English
Mogin, P., Luković, I.	Principi baza podataka	1996	Fakultet tehničkih nauka, Novi Sad	Serbian language
Mogin, P., Luković, I., Govedarica, M.	Principi projektovanja baza podataka	2004	Fakultet tehničkih nauka, Novi Sad	Serbian language

Knowledge evaluation:

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