Introduction to Database Management
Spring 2015
Obligatory Exercises and Related Material
Obligatory Exercise 1 (submission due on February 03, 2015 at 08:00):
PDF
Obligatory Exercise 2 (Update, February 05, 2015; submission due on February 09, 2015 at 08:00):
PDF
Code to generate the tables of the Airline schema:
SQL
Code to generate the tuples for the Airline schema (iso8859-1, use with cs.umu.se systems):
SQL
Code to generate the tuples for the Airline schema (utf8, may be useful with other systems):
SQL
Obligatory Exercise 3 (Updated February 10, 2015; Submission due on February 16, 2015 at 08:00):
PDF
Obligatory Exercise 4 (Submission due on February 23, 2015 at 08:00):
PDF
Obligatory Exercise 5 (Updated February 24, 2015; Submission due on March 02, 2015 at 08:00):
PDF
Obligatory Software Exercise (Updated March 02, 2015; Submission due on March 09, 2015 at 08:00):
PDF
Script of test queries and updates:
Bash