Courses – Fakultet tehničkih nauka u Novom Sadu

Subject: Databases 2 (17.ESI065)

Type of studies	Title
Undergraduate Academic Studies	Power Software Engineering (Year: 4, Semester: Winter)

General information:

Category	Scientific-professional
Scientific or art field	Primenjeno softversko inženjerstvo
ECTS	6

Course goal is adopting the basic and advanced techniques and methods of database design. Additionally, the students will gain knowledge about advanced techniques of implementation, use and maintenance of databases.

The acquired knowledge is used in future engineering courses, as well as in industry practice, in all application domains and projects where design, implementation and exploitation of database systems is included.

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. Techniques of database schema implementation at the level of database management systems. CASE tools for database schema design and implementation.

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.

Authors	Title	Year	Publisher	Language
Date, C.J.	An Introduction to Database Systems, (8th Edition)	2003	Pearson, Boston	English

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