part3.txt

ssd7 ex1 Design the following two tables and turn in your submissions in an HTML file named BookPub

1.In 1.2.2 Relational Operations, there is an example of the set's different operation: the result of r - s is provided for you. Provide result of the set's different operation s - r. 

       Table s-r
-------------------------
-     D     E     F     -
-     b     g     a     -
-------------------------

2.In the class notes, the following UNION example was discussed. Give a prosaic description of the results that will be retrieved by replacing UNION with EXCEPT in  following query: 

               ( SELECT   MemNo

                  FROM     MEMBER, BOOK

                  WHERE    MemNo = BorrowerMemNo AND

                  CallNumber = 'QA76.9.D26C66'

                )

                EXCEPT

                ( SELECT   MemNo

                  FROM     MEMBER, BOOK

                  WHERE    MemNo = BorrowerMemNo AND

                  CallNumber = 'QA76.9.D7E53'

                );

Description:Return a list of member numbers of all members currently borrowing the book which has call number QA76.9.D26C66 not QA76.9.D7E53.