1 a) STORES[StoreName] - SALES[StoreName]
  b) ((PUBLISHERS WHERE City=Chicago)
        JOIN (PUBLISHERS.PubName=TITLES.PubName)
      (TITLES WHERE Price<10.00))[PubName]
  c) (STORES 
        LEFT OUTER JOIN (STORES.StoreName=SALES.StoreName) 
      SALES) [StoreName, Address, TitleID]

2 a) INSERT INTO NEWRELEASE
       VALUES (SELECT TitleID, Title, Type, Price
                 FROM TITLES
                 WHERE PubDate > '12/31/2000')
  b) UPDATE TITLES
       SET Type='Biology'
       WHERE PubName='Addison-Wesley' AND
             Type='Biochemistry'
  c) SELECT PUBLISHERS.PubName, Address
       FROM PUBLISHERS 
       WHERE PUBISHERS.PubName IN (SELECT TITLES.PubName
                                     FROM TITLES 
                                     WHERE Price < 10.00)
  d) SELECT S.StoreName, Address, TitleID, Qty
       FROM STORES AS S LEFT OUTER JOIN SALES AS SA 
               ON (S.StoreName=SA.StoreName)
       ORDER BY S.StoreName

3 a) Name is a composite attribute. It may be decomposed to atomic
     components FirstName, MidInitial, LastName
  b) SalesCertification is a multi-valued attribute.
  c) Relationship between PUBLISHER and SALESEMPLOYEE is 1:N and
     SalesCertification becomes a weak entity hence:
         SALESEMPLOYEE(SSN, FirstName, LastName, Commission, PubName)
         SALESCERTIFICATION(Certfication, SSN)
     where PubName is a foreign key from the parent table PUBLISHERS,
     SSN is the primary key of SALESEMPLOYEE and Certification, SSN
     is a composite primary key for SALESCERTIFICATION. 
     Note: See transformation rule notes.