Courses – Fakultet tehničkih nauka u Novom Sadu

Subject: Databases (17.SE0016)

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

Type of studies	Title
Undergraduate Academic Studies	Software Engineering and Information Technologies (Year: 2, Semester: Summer)

General information:

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

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

The acquired knowledge is used in practice and in future engineering courses: Databases 2, Software Specification and Modeling, Information System Engineering, Business Informatics, Database Systems.

Databases and their role in the development and exploitation of information systems. Basic notions and concepts in databases. ER data model; Relational data model. Relational algebra. Types of database constraints in relational data model. Fundamentals of database design. The database management system language SQL. Transaction data processing. Database management system. Server programming techniques.

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
Groff, James R., Weinberg, Paul N., Oppel, Andrew J.	SQL: The Complete Reference, 3rd Edition	2009	McGraw-Hill, Inc.	English
Ramakrishnan R., Gehrke J.	Database Management Systems	2000	Mc Graw Hill	English
Date, C.J.	An Introduction to Database Systems, (8th Edition)	2003	Pearson, Boston	English