|Teaching assistant:||Oksana Dolmatova, Yvonne Mülle , Kevin Wellenzohn|
|Teaching language:||German (English lecture notes, exercises, exam, and text book)|
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: 2014, 2015, 2016. 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 20, at 10:15 in room BIN-1-B.01 (students with family name starting from A to Saj), in room BIN-0-K.02 (students with family name starting from Sak to Z), and in room BIN-1.D.29 (students with student numbers 08715500 and 14703516). 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 take place on Tuesday 12.15-13.45 and will be taught by Oksana Dolmatova (AND-3-02, English), Yvonne Mülle (BIN-2.A.01, German) and Kevin Wellenzohn (AND-3-06, German). 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, August 17, starting from 10:00. If you are going to participate in the inspection please contact Oksana Dolmatova before August 14.
- 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).
02/06/2017 15:00: The solution 11 has been updated.
Leftover exercises can be picked up from the office of the responsible assistant!
|28.2||07.3||[YM] Relational algebra||ex sol|
|07.3||14.3||[OD] Domain relational calculus||ex sol|
|14.3||21.3||[KW] SQL (metadata, simple DDL, DML), PostgreSQL||ex sol|
|21.3||28.3||[YM] Transformations: RA - DRC - SQL||ex sol|
|28.3||04.4||[OD] Advanced SQL||ex sol|
|04.4||11.4||[KW] Functions and triggers||ex sol|
|11.4||25.4||[YM] Relational database design||ex sol|
|25.4||02.5||[OD] Functional dependencies, multivalued dependencies||ex sol|
|02.5||09.5||[KW] Entity relationship model; From ER to relational model||ex sol|
|09.5||16.5||[YM] Physical design and indexing||ex sol|
|16.5||23.5||[OD] Query trees and plans, cost computation||ex sol|
|23.5||30.5||[KW] Empirical performance tests, transaction processing||ex sol|
|30.5||/||Correction of last exercises and exam preparation|