Information Systems for Engineers - Fall 2018

Overview | Lecture and Exercise Times | Course Material | People

 

Course Material

 Lecture

Date Topic Material Reading Assignment
20.09.2018 Introduction [slides] Chapter 1
27.09.2018 Relational Model [slides] Chapters 2.1 and 2.2
04.10.2018 Data Definition with SQL [slides] Chapters 2.3 and 6.5.1
11.10.2018 Relational Algebra [slides] Chapters 2.4, 6.5.* and 7

18.10.2018
25.10.2018

Queries with SQL [slides] Chapters 6.1, 6.2, 6.3, and 6.4

01.11.2018
08.11.2018

Database Design Theory [sildes] Chapters 3.1, 3.2, 3.3, and 3.4
15.11.2018 The ecosystem around SQL [slides] Chapters 9.1, 9.2 and 9.6 
22.11.2018 Views and Indices [slides] Chapters 8.1, 8.2, 8.3 and 8.4 
06.12.2018 Cubes and OLAP [slides] Chapters 10.6 and 10.7 
13.12.2018 Database Architcture [slides]  Chapters 13.1, 13.2 and 13.5
20.12.2018 Outlook [slides]  

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

 

Exercises

Date Topic Material Solution
27-28.09.2018 Introduction [instructions][exercise] [solution]
04-05.10.2018 Relational Model [exercise] [solution
11-12.10.2018 Data Definition with SQL (Part I) [exercise] [solution]
18-19.10.2018 Data Definition with SQL (Part II)

[notebook][exercise]

[solution_notebook]
[solution_pdf]

25-26.10.2018 Relation Algebra

[ungraded]
[graded]

[solution]
[solution (graded)]

1-2.11.2018 Queries with SQL (Part I) [notebook] [solution]
8-9.11.2018 Queries with SQL (Part II) [ungraded][graded]

[solution]
[solution (graded)]

15-16.11.2018 Database Design Theory (Part I) [exercise] [solution]
22-23.11.2018 Database Design Theory (Part II)

[exercise]
[Graded exercise on Moodle]
 

[solution]
29-30.11.2018 Transactions

[exercise]
[optional: SQL Alchemy

[solution
06-07.12.2018 Views and Indices

[exercise]

[solution]
13-14.12.2018 Cubes and OLAP

[notebook]

[sales file]

[solution]
20-21.12.2018 Past Exams

[Feb 2018]

[Aug 2018]