CS240a W98: Assign 3

CS240A: Winter 98. Third Project

Project 3: From GEM to SQL
Read the GEM paper ad write SQL3 DDL and DML statements for the example database and queries in the paper. In particular:

Declare the schema of Figure 1 in SQL3.

Then write SQL3 DML statements for Examples 8-40 in the paper.
While the syntax will be different, you must try to preserve the semantics and also the query structure of those examples. When that is not possible, explain the problem.