IS202 Database Systems (Spring 2011)

Lab. #5

Do the following execises from your textbook. Enter proper SQL instructions in your mysql environment for the Ships database schema that you have created in the lab4.

1. Exercise 7.1.4

2. Exercise 7.1.5. (In each case demonstrate that any any conflicting modification request is rejected properly. For example, for part a, insert a tuple to Ships table that has a class value not existing in Classes table.)

3. Exercise 7.3.2

4. Exercise 7.5.3 a (The code in the class does not work for mysql triggers. Please refer to the manual to develop a running code.)