13M114SAB - Database Programming Tools

Course specification
Course title		Database Programming Tools
Acronym		13M114SAB
Study programme		Electrical Engineering and Computing
Module
Type of study		master academic studies
Lecturer (for classes)		professor PhD Miloš Cvetanović
Lecturer/Associate (for practice)		asst. MA Tamara Šekularac, electrical and computer engineer
Lecturer/Associate (for OTC)		MA Stefan Tubić, electrical and computer engineer asst. MA Tamara Šekularac, electrical and computer engineer
ESPB		6.0	Status	elective
Condition
The goal		Advanced techniques for database modeling. Database programming framewroks. Database reporting.
The outcome		Knowlede of advanced techiques for database modeling. Knowledge on using database programming frameworks. Knowledge on using reporting tools for database development.
Contents
URL to the subject page		http://si4sab.etf.rs/
URL to lectures		https://teams.microsoft.com/l/team/19%3aG6TcnLOIwFGwSFlBgkROF_jd2SkRGccxX_cDmek0oyo1%40thread.tacv2/conversations?groupId=7cbb3155-6d2b-4f56-8915-6df03670de27&tenantId=1774ef2e-9c62-478a-8d3a-fd2a495547ba
Contents of lectures		Notations for database modeling. Implementation of database constraints. Techniques for compromise restructuring. Database triggers and store procedures development. Using databases from programming languages. Object relational mapping. Database reporting.
Contents of exercises		Creating data models using the IE notation. Creating stored SQL procedures. Creating Java programs that use JDBC for database acess.
Literature
ERWin User Guide, Computer Associates (Original title) SQL in a Nutshell, K.E.Kline, O'Reilly (Original title) Database Programming with JDBC and Java, G.Reese, O'Reilly (Original title) Database Systems, T.Connolly, C.Begg, Addison Wesley (Original title)
Number of hours per week during the semester/trimester/year
Lectures	Exercises	OTC	Study and Research	Other classes
2	2	1
Methods of teaching		Lectures. Exercises. Laboratory exercises. Homework.
Knowledge score (maximum points 100)
Pre obligations		Points	Final exam	Points
Activites during lectures			Test paper	30
Practical lessons		30	Oral examination
Projects		20
Colloquia		20
Seminars