Database Systems

Short Name
Datenbanksysteme
Module Code
CS1020
Module Coordinator
  • Burkhardt Renz
Teacher
  • Peter Hohmann
  • Dr. habil. Frank Kammer
  • Achim Kaufmann
  • Burkhardt Renz
  • Harald Ritz
Short Description
Students are acquainted with concepts of database management systems, they are capable to develop data models and they are proficient in the standard query language SQL.
Learning Objectives

Students are acquainted with concepts of database management systems, they are capable to develop data models and they are proficient in the standard query language SQL.

Contents
Part 1: Fundamentals
  • Overview of Database Management
  • Database System Architecture and Data Independence
  • Data Models
Part 2: The Relational Model
  • SQL
  • Relations and Relational Algebra
  • Database Integrity
Part 3: Database Design
  • Semantic Modeling - Entity/Relationship Model
  • Functional Dependencies
  • Normalforms: 1NF, 2NF, 3NF und BCNF
  • Schema Design
Part 4: Transaction Management
  • Recovery
  • Transactions and Isolation Level
Part 5: Application of Databases
  • Programming Database Access (JDBC)
  • Tasks of Administration
Duration in Semester
1
Instruction Language
German
Total Effort
6.0 CrP; an estimated 180 hours, of which approximately 90 are spent in class.
Weekly School Hours
6
Method of Instruction

Lecture 4 SWS, exercises 2 SWS

Requirements for the awarding of Credit Points

Examination prerequisite: 2 certified written exercises, Examination: Written exam

Evaluation Standard
according to examination regulations (§ 9)
Availability
Semesterly
References
  • M. Schubert: Datenbanken: Theorie, Entwurf und Programmierung relationaler Datenbanken Teubner
  • R. Elmasri, S.B. Navathe: Grundlagen von Datenbanksystemen Pearson
  • G. Saake, K.-U. Sattler, A. Heuer: Datenbanken: Konzepte und Sprachen mitp
  • C. J. Date: Introduction to Database Systems Addison-Wesley
  • M.A. Kifer, A. Bernstein, P.M. Lewis: Database Systems: An Application-Oriented Approach Pearson/Addison-Wesley
  • H. Garcia-Molina, J.D. Ullman, J. Widom: Database Systems: The Complete Book Pearson Prentice-Hall