SWEN 432 (2020): 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 Monday, 22 June at 23:59.
  • The file BookOrdersDatabaseDump_20.sql is here.
  • Question3.a) query is here.
  • Question3.b) query is here.
  • Question4.b) materialized view is here.
  • Question5 materialized views are here.

Assignment 4

Assignment 4 as a pdf file is here.
  • The file ass4_competitions.txt is here
  • The file ass4_pairs.txt is here
Assignment 4 due date and time is Monday, 08 June at 23.59 for the electronic submission.

Assignment 3

Assignment 3 as a pdf file is here.
  • The file competitions_20.txt is here,
  • The file pairs_20.txt is here.
Assignment 3 due date and time is Monday, 25 May at 23:59 for electronic submission.

Assignment 2

The Assignment 2 pdf file is here.
  • The file table_declarations.txt is here,
  • The file driver_data.txt is here,
  • The file time_table_data.txt is here,
  • The file data_point_data.txt is here,
  • The file large_user_1000.cql is here, and
  • The file names_1000.cvs is here.
  • The Question 8 Instruction is here.
Assignment 2 due date and time is Monday, 11 May at 23:59 for electronic submission.

Assignment 1

Assignment 1 as a pdf file is here. Assignment 1 due date and time is Friday, 27 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

  • 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.

  • An Analysis of Assignment 1 as a pdf file is here

  • About Cassandra Primary Key as a pptx file is here