Database Systems

Module Code
CS1020
Module Coordinators
Burkhardt Renz
Teachers
  • Achim Kaufmann
  • Burkhardt Renz
  • 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 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
    Prerequisite Modules