24S114SAB - Database Software Tools

Course specification
Course title		Database Software Tools
Acronym		24S114SAB
Study programme		Software Engineering
Module
Type of study		bachelor 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
URL to the subject page		https://sab.etf.bg.ac.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		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) Data Modeling Made Simple: A Practical Guide for Business and IT Professionals, 2nd edition, S. Hoberman, Technics Publications, 2015 (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