Navigation

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)
Lecturer/Associate (for practice)
Lecturer/Associate (for OTC)
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
  1. ERWin User Guide, Computer Associates
  2. SQL in a Nutshell, K.E.Kline, O'Reilly
  3. Database Programming with JDBC and Java, G.Reese, O'Reilly
  4. 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