Translation from SQL-R to SQL

My senior project deals with translation of an SQL dialect called "SQL-R" into standard SQL. SQL-R is SQL with the integrated concept of a reference in place of a more traditional Foreign Key concept. This allows a table's Foreign Key, which may span several columns, to be used as a reference (a pointer in C/C++ terminology) to refer to other tables in queries. This simplifies the WHERE clause of the queries as it makes many join conditions between tables virtually unnecessary.

The "System Documentation" document is a single version of all previous (and above) documents. It also contains some minor revisions made to previous documents.