Homework #4 FAQ
For part (b), can I use MODIFY option provided by Oracle in the ALTER
command? Is MODIFY in SQL2?
MODIFY is not part of the SQL2 specifications.
There are at least two ways of answering this part while staying within
- 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
Which relations should I define my views on?
Use the relations defined at the beginning of the assignment.