This assessed coursework should be submitted online as Canvas E-submission. The due date of this coursework is 4pm on Monday, 4th of January 2021.
This coursework has two parts, and your submission should consist of two
separate files, one for your answers to the questions in Part 1 and one for
your answers to the questions in Part 2
1. Your solutions to the questions in Part 1 should be inserted into the
file a2.sql which you can download from the submission point in
Canvas. You should insert your code for each question after the corresponding question comment.
2. Your solutions to the questions in Part 2 should be submitted as the
pdf file a2.pdf. You must submit a pdf file
All questions in both Parts 1 and 2 should be answered.