Navigation

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