Nearly every week you will have a set of exercises to complete. There are 10 sets of required exercises, starting in week 2.
Although the homework exercises themselves are worth very few marks, you will find it extremely worthwhile to complete them. This will help you with your larger assignments and exams which are worth a lot of marks and may appear hard - particuarly if you didn't aquire the skills by doing the exercises.
Homework 4. If you want to type your answers, here is the word file.
Homework 5. Here is the data file: moviesdata.sql.
This homework is on PCRS.
Updated movies database: movies_pg.zip.
Postgre trigger examples (same as in the lecture)
.Homework 9. Here is the word file if you want to type your answers: doc.
Homework 10. Here is the input data file celeb_triples.csv.