SWEN 432 (2019): Advanced Database Design and Implementation

This page will be updated with assignments and their model solutions when they are available or are handed out in lectures. If you find errors or want to make comments on the content, email me, pmogin@ecs.vuw.ac.nz

Assignments


Assignment 5

Assignment 5 as a pdf file is here. Assignment 5 due date and time is Sunday, 9 June at 23:59.
  • The file BookOrdersDatabaseDump_19.sql is here.

Assignment 4

Assignment 4 as a pdf file is here. It will be handed out in lecture on Monday, 6 May.
  • The file ass4_competitions.txt is here
  • The file ass4_pairs.txt is here
Assignment 4 due date and time is Friday, 24 May at 23.59 for both hard copy and electronic submission.

Assignment 3

Assignment 3 as a pdf file is here.
  • The file competitions_19.txt is here,
  • The file pairs_19.txt is here.
Assignment 3 due date and time is Friday, 03 May at 23:59 for electronic submission. Hand also a hard copy into the hand-in box at the second floor of the Cotton Building.

Assignment 2

The Assignment 2 pdf file is here.
  • The file table_declarations_19.txt is here,
  • The file driver_data.txt is here,
  • The file drivers_day_count_data.txt is here, and
  • The file time_table_data.txt is here.
    Assignment 2 due date and time is Friday, 12 April at 23:59 for electronic submission. Hand also a hard copy into the hand-in box at the second floor of the Cotton Building.

Assignment 1

Assignment 1 as a pdf file is here. Assignment 1 due date and time is Friday, 29 March, at 23:59 via the school electronic submission. Hand also a hard copy into the hand-in box at the second floor of the Cotton Building.

Assignment Model Solutions

  • In Term Marks here.

  • Assignment 5 Model Solution as a pdf file is here.

  • Assignment 4 Model Solution as a pdf file is here.

  • Assignment 3 Model Solution as a pdf file is here.

  • Assignment 2 Model Solution as a pdf file is here.

  • Assignment 1 Model Solution as a pdf file is here.