rel-ops.txt

这是卡耐基-梅泷的ssd7的第一个答案

In order to perform the this query, I have used Project, Select
and Join operations.

Project: Select the attributes specified on an attribute_list from
         the table BOOK, that is "Title" and "Price".
Select: Selects some rows in the table BOOK that satisfy a selection 
        condition (alias predicate). That is "WHERE (BOOK.PubID=PUBLISHER.PubID) AND(PUBLISHER.Name='DannyShum' or PUBLISHER.Name='LionLi')".
Join:  The Join operation combines two tables, thereby allowing us to obtain more information.
       To be combined, the rows from each table must satisfy a joining condition. 
       That is "WHERE (BOOK.PubID=PUBLISHER.PubID) AND(PUBLISHER.Name='DannyShum' or PUBLISHER.Name='LionLi')".