Software Design

Relational Databases

Integrated course, 3.00 ECTS

 

Course content

This course focuses on relational theory as well as relational operations and
their applications in the form of SQL-queries. Based on the data and data structures worked on during the previous semesters, students learn and practise queries in all forms and complexity. Further topics are multi-user synchronization, procedural extension of SQL as well as object-relational concepts.

Learning outcomes

On completion of the course, students have fundamental knowledge about configuration management, about practical work with classic RDBMS and about object oriented programming.

Recommended or required reading and other learning resources / tools

Books: Stephen P. Berczuk, Software Configuration Management Patterns, 2008;
Vossen, G., Datenmodelle, Datenbanksprachen und Datenbankmanagementsysteme; Beaulieu A., Einführung in SQL
Bloch, J. (2008). Effective Java (2nd ed.). Addison-Wesley
Professional Journals: ACM, IEEE

Mode of delivery

1 ECTS lecture; 2 ECTS tutorial

Prerequisites and co-requisites

Software Engineering 1

Assessment methods and criteria

Lecture: Final Exam; Tutorial: Continuous Assessment