Courses – Fakultet tehničkih nauka u Novom Sadu

Subject: Databases (17.EE417A)

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

Type of studies	Title

General information:

Category	Theoretical-methodological
Scientific or art field	Applied Computer Science and Informatics
Interdisciplinary	No
ECTS	3

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:

The acquired knowledge is used in practice, in projects of database and information system development, as well as in advanced courses requiring a use of basic knowledge in databases.

Course content:

The evolution of data management process and the notion of a database. Basic concepts and characteristics of data models. ER data model. Relational data model. A classification and types of database constraints in the relational data model. Functional dependency and the relation scheme key. Basic design techniques of relational database schemas. Basic characteristics of database management systems. The use of SQL in creating database schemas and data manipulation. Transformations of ER database schema into relational data model.

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
Mogin, P., Luković, I.	Principi baza podataka	1996	Fakultet tehničkih nauka, Novi Sad	Serbian language
Mihajlović, D.	Informacioni sistemi i projektovanje baza podataka	1998	Fakultet tehničkih nauka, Novi Sad	Serbian language
Date, C.J.	An Introduction to Database Systems, (8th Edition)	2003	Pearson, Boston	English
Mogin, P., Luković, I., Govedarica, M.	Principi projektovanja baza podataka	2004	Fakultet tehničkih nauka, Novi Sad	Serbian language
Groff, James R., Weinberg, Paul N., Oppel, Andrew J.	SQL: The Complete Reference, 3rd Edition	2009	McGraw-Hill, Inc.	Serbian language
Kordić, S. i dr.	Baze podataka : zbirka zadataka	2018	Fakultet tehničkih nauka, Novi Sad	Serbian language

Knowledge evaluation:

Course activity	Pre-examination	Obligations	Number of points
Complex exercises	Yes	Yes	10.00
Project task	Yes	Yes	15.00
Oral part of the exam	No	Yes	30.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