Navigation

MS1SAB - Database Software Tools

Course specification
Course title Database Software Tools
Acronym MS1SAB
Study programme Electrical Engineering and Computing
Module Computer Engineering and Informatics
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 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: Creation and administration. Report generation. Event handling. PROGRAMMING ENVIRONMENT FOR DATABASES: Database level programming. Application level programming. Object-relational mapping.
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 0 Test paper 70
Practical lessons 10 Oral examination 0
Projects 0
Colloquia 20
Seminars 0