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

  • Lecture: Wednesday 16:45-18:15 in 0790 (first lecture on 17th of October 2018)
  • Exam: Please check TUMOnline for the exam date. As of Nov. 20 it is "14.03.2019 10:30-11:15".
    The exam will be a closed book 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
Introduction - -
ER Models Sheet 2 Solution 2
UML Sheet 3 Solution 3
Relational Model Sheet 4 Solution 4
SQL DDL Sheet 5 Solution 5
SQL DRL 1 Sheet 6 Solution 6
- Sheet 7 Solution 7
SQL DRL 2 Sheet 8 Solution 8
- Sheet 9 Solution 9
- Sheet 10 Solution 10
Index Structures Sheet 11 Solution 11
- Sheet 12 Solution 12
Transactions

 

Navigation