Database System Concepts for Non-Computer Scientists

Information

This course will be held in English!

Description:

  • IN4714: Part of the modules BV470015 Geodatabases as well as BV300022 Spatial Databases and Visualization
  • Extent: The lecture has 2 weekly hours per semester and gives 2 credits (ECTS).
  • Content:
    • Database Design
    • Relational Data Model
    • Relational Query Language SQL
    • Data Integrity
    • Physisical Organization of the Data
    • Query Execution
    • Transaction Management
    • (Main Memory Databases, NoSQL Data Bases, Data Warehouses, etc.)

Dates

  • Always check TUM online
  • Lecture: 16:45-18:15 starting Oct 18
  • Exam:
    There are three modules for which the database exam is used:
    • Stand alone (IN4714) for 2 ECTS (40 minutes)
    • In combination with Geodatabases (BV470015) for 3 ECTS (+20 minutes)
    • In combination with Spatial Databases and Visualization (BV300022) for 6 ECTS (+80 minutes)

Tools

Material

Lecture Slides Exercise Sheet Solution
0 Lecture Notes
1 Introduction
2 ER Diagrams e1, e2 s1, s2
3 UML
4 Relational Model e3 s3
5 SQL DDL
6 Relational Algebra
7 SQL DRL (1)
7 SQL DRL (2)
8 SQL DML

 

Navigation