Datenbanksysteme DBS16

Objectives: The course provides an in-depth understanding of the fundamentals of database systems. It focuses on the relational data model and covers the following topics: relational algebra and calculus, SQL, relational database design, conceptual database design, physical database design, query processing and optimization, and transactions. The aims of this course are to learn the basic concepts underlying a database system; to understand how these concepts are implemented in concrete systems; and to get hands-on experience in using a database system.

Teaching Format and Exam: The course consists of lectures and exercises. The weekly exercises are an important part of the course. The assessment consists of the successful completion of 9 out of 12 exercises and the successful participation at the final exam. Both parts have to be passed independently. Exercises are only valid for the current year. The exams of the previous years can be found here: 2010, 2011, 2012, 2013, 2014, 2015. At the exam you are allowed to use one A4 sheet with your personal notes (both sides, hand written or printed) and a pocket calculator. The exam will take place on Tuesday, June 21, 10:15 - 12:00, in BIN-1-B.01 (students with surnames starting from A to S) and BIN-0-K.02 (students with surnames starting from T to Z). For official information, please check VVZ.

Textbook: The textbook of the course is Database Systems---Models, Languages, Design, and Application Programming, Sixth Edition, Ramez Elmasri and Shamkant B. Navathe, Pearson Education, 2010.

Exercises: The exercises will be taught by Oksana Dolmatova (English), Yvonne Mülle (German) and Kevin Wellenzohn (English). The solved exercises have to be returned, in printed version, at the latest at the beginning of the next exercise class to your TA .

Office hours: By prior arrangement with your exercise group assistant.

Exam inspection: The exam inspection will take place on Thursday, July 28, starting from 10:00. If you are going to participate in the inspection please contact Oksana Dolmatova before July 25.

The lectures take place TU 10:15-12:00 and WE 12:15-13:45 in room BIN 0.K.02. The lecture notes are available in 1up or 4up format. Syllabus:

• SL01, Database Systems
• SL02, The Relational Model
• SL03, SQL
• SL04, Constraints, Triggers, Views, DB programming
• SL05, Relational Database Design
• SL06, Conceptual Database Design
• SL07, Physical DB Design
• SL08, Query Processing and Optimization
• SL09, Transactions, Concurrency, and Recovery
• SL10, Summary

A PostgreSQL account will be created for every registered student. You can connect to PostgreSQL via pgAdmin3 (tutorial).
For the exercises we use the Mondial database (relational schema, create statements, insert statements).

The results of previous exercises can be found here: Group Dolmatova, Group Mülle, Group Wellenzohn.

Leftover exercises can be picked up from the office of the responsible assistant!

• Link