The course teaches the students the basics of

• the relational model
• the modeling of information using the relational model
• the use of relationales database management systems.

Students learn to abstract and model relevant facts from descriptions provided in natural language and to translate these models into relational schemas. They further learn to implement these schemas in relational database management systems, to manipulate data stored under such schemas, and to query the resulting databases. Students also learn to apply tools that allow them to measure the quality of relational schemas.

Students also learn to maintain data integrity in relational database management systems, and to understand the foundations of transactions, recovery, and the synchronisation of multiple users, and to apply these concepts in relational database management systems. In addition, students learn to understand, formalize, plan, and apply advanced features of database languages.

• Semantic Data Modelling; EER-diagrams
• The Relational Model (Basics, Translation using EER-diagrams)
• Relational Query Languages (Relational Algebra, Tuple/Domain Relational Calculus, SQL)
• Design Theory for Relational Databases (Functional Dependencies, Normalforms)
• Database programming (with pgSQL)
• SQL-extensions
• Transactions
• error handling / recovery
• multi-user synchronization

ECTS Breakdown:

 30h   lectures
 30h   preparation for and repetition of lectures
 52h   solving exercise sheets
  0,5h exercise interviews
 34h exam preparation
  3,5h   exam
------------------
150h (= 25h * 6ECTS)

exercises and written examination

There are no formal prerequisites for this course. However, it is strongly recommended to take the course "Formal Modelling" prior to this course.