Big Assignment (50% of course grade)

Do not share your code or answer to others! You would fail the course by sharing your answer to others! 

Please make sure that you re-import the data to your database before working on the big assignment! You might accidently change the data when doing the hands-on assignment, and this will lead to different answers to the questions.

The deadline for the assignment is March 2, 2018 at 23:55.

More explanation is added to Question 6 on February 13, 2018, because the question receives complaints saying it was unclear.