For this assignment you will solve several exercises from the end of Chapter 5 from our textbook. This assignment is due Thursday, October 9.

Problem 0.) Do Exercise 5.10, parts (a) - (d), page 188-189. (This is in case you did not get these problems done for homework assignment 2. If you completed these for assignment 2, you don't need to do them again; if you did not complete these for assignment 2, you can turn them in as part of this assignmnet.)

Problem 1.) Do Exercise 5.12,

Problem 2.) Do Exercise 5.17, parts (a) - (e).

Turn in a zip file containing the following files. For Problem 0, an sql script file that contains both the relational algebra expression and the SQL code for each part of the problem. Write the relational algebra expression in a comment (above the SQL code) and use operator names (like join, union, etc) instead of the special symbols used in the textbook. For Problem 1, write your asnswers in a short text file. For Problem 2, turn in a modified StudentRegistrationSystem.sql script that defines and builds the slightly modified version of the Student Registration System database, and then another script file containing your solutions to Exercise 5.17. This assignment is due Thursday, October 9.