From the textbook- ( Connolly and Begg) do the folowing problems:

Page 436 #'s  13.7- 13.30
Page 503 #'s  14.7- 14.12 and optional  14.14 and 14.17, if you do 14.14 and 14.17 they will be worth 10 bonus points(%) each on this assignment.

You must use postgress on sandbox to build and populate your database tables. You may use Java, C++, PHP, Perl, Visual Basic etc. to do 14.14 and 14.17.
Insert enough tuples to test your required querries. Don't create too much work by making high volume tables.