Database System Concepts for Non-Computer Scientist

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 20
  • 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, e3 s1, s2, s3
3 UML - -
4 Relational Model e4, e5 s4, s5
5 SQL DDL e6 s6
6 Relational Algebra - -
7 SQL DRL (1) e7 s7
7 SQL DRL (2) e8 s8
8 SQL DML e9, e10 s9, s10