Grundlagen von Datenbanksystemen

The book, now in its third and heavily revised edition, is one of the most internationally renowned and proven textbooks on the subject of databases. The material covered in the original book goes far beyond the scope of an introductory lecture and also addresses advanced topics and questions. This bachelor edition, which has been shortened compared to the original and adapted to local teaching, presents various data models and database languages and covers the essential fundamentals of database design that are important for every student. Additionally, the authors discuss various practical aspects of multi-user operations. All topic areas are thoroughly explored and presented in such a comprehensive manner that the book is suitable both as a basis for lectures and for later reference and self-study. Review questions and exercises at the end of each chapter facilitate the assessment of learning success. Solutions to the exercises and additional chapters from the original translation on advanced topics are available on the book's companion website.

Contents:
Basic Concepts:
Data modeling with the ER model
EER model and object modeling
Data Models and Database Languages:
The relational model
SQL
Design Issues:
Functional dependencies and normalization
Database design and tuning
Aspects of Multi-User Operations:
Transaction processing
Concurrency control
Data security and authorization

For Instructors Using the Book:
Lecture slides
All figures from the book

For Students:
Solutions to the exercises
All unprinted chapters from the original translation.