Homework #4 FAQ

Question 1

Question: For part (b), can I use MODIFY option provided by Oracle in the ALTER command? Is MODIFY in SQL2?

Answer: MODIFY is not part of the SQL2 specifications.

There are at least two ways of answering this part while staying within SQL2 specs:

Define BookReference appropriately in Part (a), so you can solve this part using commands learnt in class.
Find out what the SQL2 specs. say about ALTER TABLE options, and use the SQL2 equivalent of Oracle's MODIFY.

Question 3

Question: Which relations should I define my views on?
Answer: Use the relations defined at the beginning of the assignment.