The exam this year will take place in-person rather than online. As a result, the format and style of questions will be similar to the exams in 2019 and beforehand. The exams of 2020 and 2021 were online. As you will see, the total number of marks in each case was reduced to 60 rather than 100, and the questions were mostly similar to the problem-solving questions asked on previous papers, rather than straightforward bookwork-type questions.
The exam this year will therefore comprise five 25-mark questions of which you have to answer four. Each question will consist of sub-parts, usually covering different topics taught on the module.
The syllabus this year was exactly the same as last year and very similar to that used for the three years before that. One change I made last year was to drop most of the material on embedded SQL from the SQL programming topic. The syllabus in 2018 was slightly different from that of the previous two years. I reduced the amount of material on normalisation, and left out the notion of a minimal cover, which is needed for the third normal form algorithm, completely. In its place, I added the material on query processing.
I include links to exam papers for the past 6 years below (earlier ones are on the library's web pages). Also included are links to the sample solutions. I encourage you to work out your own solutions before looking at the sample ones.
Papers:
Sample solutions: