Information Systems for Engineers - Spring 2020

Overview | Lecture and Exercise Times | Course Material | People

 

Course Material

 Lecture

Date Topic Material Reading Assignment Recording
20.02.2020 Introduction

[slides]

 Chapter 1 [link]
27.02.2020 Relational Model [slides] Chapters 2.1 and 2.2 [link]
05.03.2020 Data Definition with SQL [slides] Chapters 2.3 and 6.5.1 [link]
12.03.2020 Relational Algebra [slides] Chapters 2.4, 6.5.* and 7 [link]
19.03.2020 Queries with SQL [slides] Chapters 6.1, 6.2, 6.3, and 6.4 [link]
26.03.2020 Queries with SQL (continued)    

[link]

[link]
02.04.2020 Database Design Theory

[slides]

Fix (Aug. 25): on slide 98, theorem 4 was incorrect and was fixed.

 Chapters 3.1, 3.2, 3.3, and 3.4 [link]
09.04.2020 Database Design Theory (continued) [transcript]   [link]
23.04.2020 The ecosystem around SQL

[slides]

Update: slides 139-144 and 153-155 added to show what was on the blackboard.

 Chapters 9.1, 9.2, 9.6 [link]
30.04.2020 Views and Indices

[slides]

[transcript]

 Chapters 8.1, 8.2, 8.3, 8.4, 8.7 [link]
08.05.2020

Views and Indices (continued)

     [link]
14.05.2020 OLAP

[slides]

 

 Chapters 10.6 and 10.7 [link]
28.05.2020 Database architecture and wrap-up

[slides]

[slides] 

 Chapters 13.1, 13.2 and 13.5 [link] [link]

Note: All reading assignments are from "Garcia-Molina, Hector and Ullman, Jeffrey D. and Widom, Jennifer, Database Systems: The Complete Book, Second Edition"

 

Exercises

Marie-Louise website : https://n.ethz.ch/~machart/ISE.html "> https://n.ethz.ch/~machart/ISE.html

Date Topic Material Solution
20.02.2020 Python + PostgreSQL installation

 [instructions]

[notebook]

  
27.02.2020 Introduction

Moodle quiz[link]

[exercise]

 [solutions]
05.03.2020 Relational Model [exercise] [solutions]
12.03.2020 Data Definition with SQL I [notebook] [solutions]
19.03.2020 Data Definition with SQL II

[notebook]

[exercise]

[notebook_solution]

[solution]
26.03.2020 Relational Algebra

Moodle link [graded]

[helpful_examples]

[ungraded]

[solution_graded]

[solution_ungraded]
02.04.2020 Queries with SQL I [notebook]  [notebook_solution]
09.04.2020 Queries with SQL II

Moodle link [graded]

[solution_1]

[solution_2]
23.04.2020 Database Design Theory I [exercise]  [solution]
30.04.2020 Database Design Theory II

Moodle link

[graded]

[BCNF]

[see Moodle answers]

[BCNF_solutions] (the solution of part 1 was updated to remove confusion and exactly select the decomposition based on the violating FD)
07.05.2020 The ecosystem around SQL [exercise]  [solution]
14.05.2020 Views and Indicies [exercise]  [solution]
21.05.2020 OLAP

[notebook]

[data]

  [solution]