13M114SAB - Database Programming Tools

Course specification
Course title		Database Programming Tools
Acronym		13M114SAB
Study programme		Electrical Engineering and Computing
Module		Applied Mathematics, Audio and Video Technologies, Biomedical and Environmental Engineering, Biomedical and Nuclear Engineering, Computer Engineering and Informatics, Electronics and Digital Systems, Energy Efficiency, Information and Communication Technologies, Microwave Engineering, Nanoelectronics and Photonics, Power Systems - Networks and Systems, Power Systems - Renewable Energy Sources, Power Systems - Substations and Power Equipment, Signals and Systems, Software Engineering
Type of study		master academic studies
Lecturer (for classes)		professor PhD Miloš Cvetanović
Lecturer/Associate (for practice)		asst. MA Tamara Šekularac Obradović, electrical and computer engineer
Lecturer/Associate (for OTC)		asst. professor PhD Stefan Tubić asst. MA Tamara Šekularac Obradović, electrical and computer engineer
ESPB		6.0	Status	elective
Condition
The goal		An introduction to software tools for database development. An introduction to software tools for database maintenance and usage. An introduction to the programming environment for databases.
The outcome		Knowledge on using software tools for database development. Knowledge on using software tools for database maintenance and usage. Knowledge on the programming environment for databases.
Contents
Contents of lectures		SOFTWARE TOOLS FOR DATABASE DEVELOPMENT: Development by using the IE notation. Development by using the modified ERM notation. Tool implementation details. SOFTWARE TOOLS FOR DATABASE MAINTENANCE AND USAGE: Administration. Physical data modeling. Indexes. Execution plan. Report generation. PROGRAMMING ENVIRONMENT FOR DATABASES: Database level programming. Application level programming.
Contents of exercises		Creating data models using the IE notation. Creating stored SQL procedures, functions, triggers. Creating Java programs that use JDBC for database acess.
Literature
Data Modeling Made Simple with erwin DM, J. Harris, S. Hoberman, Technics Publications, 2020 (Original title) Java Database Best Practices: Persistence Models and Techniques for Java Database Programming, George Reese, O'Reilly Media, 2003 (Original title) Mastering Java Persistence API (JPA): Realize Java's Capabilities Spanning RDBMS, ORM, JDBC, Caching, Locking, Transaction Management, and JPQL (English Edition), Nisha Parameswaran Kurur, BPB 2022. (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		15	Oral examination
Projects
Colloquia		35
Seminars		20