Database Reference
In-Depth Information
Based on the Date notation, the alternate syntax of the
PROJECT
statement that is
much closer to the SQL implementation is as follows:
Example 2b:
With this syntax, the above two projections would be written as follows:
7.3.3 Natural Join Statement
The Ullman notation and Date notation essentially agree on the format of the natural
join. The natural
join
statement is of the form
Example 3:
To join
Student
with
Hall
on the foreign key
Hall#
: