13S113SAB - Database Software Tools

Course specification
Course title		Database Software Tools
Acronym		13S113SAB
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 Janko Tufegdžić
Lecturer/Associate (for OTC)		MA Stefan Tubić, electrical and computer engineer asst. MA Tamara Šekularac Obradović, electrical and computer engineer Janko Tufegdžić
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		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		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
ERWin User Guide, Computer Associates SQL in a Nutshell, K.E.Kline, O'Reilly Database Programming with JDBC and Java, G.Reese, O'Reilly Database Systems, T.Connolly, C.Begg, Addison Wesley
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		0	Test paper	30
Practical lessons		30	Oral examination	0
Projects		20
Colloquia		20
Seminars		0