createdb.sql

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

Part II:
1. CREATE TABLE BOOK
   (
     PriAut   char(10),
     Title    char(30),
     ISBN     char(30),
     PubID    char(10),
     Edition  integer(4),
     PubDate  char(20),
     Price    char(10),
     BookDes  char(30),
     PRIMARY KEY (PriAut),
     UNIQUE (Title),
     Foreign KEY(PubId) REFERENCES PUBLISHER(PubId)
   );

   

   CREATE TABLE PUBLISHER
   (
     PubId   char(10),
     Name    char(20),
     Address char(30),
     PRIMARY KEY (PubID),
     UNIQUE (Name),
    );
   


2. INSERT INTO BOOK
   VALUES('DannyShum','Thinking in Java','7-5600-5280-0','A001','3','1988.11.12','$118.0','For All Level');
   INSERT INTO BOOK
   VALUES('RollandQiu','Thinking in C','7-5600-5280-1','A002','2','1990.3.24','$49.9','For Freshman');
   INSERT INTO BOOK
   VALUES('LionLuo','Thinking in C++','7-5600-5280-2','A003','5','1989.2.16','$56.8','For Professor');
   INSERT INTO BOOK
   VALUES('JimmyLi','Thinking in Delphi','7-5600-5280-3','A004','2','1963.8.7','$32.8','For Freshman');   
   INSERT INTO BOOK
   VALUES('DannyShum','Thinking in Pascal','7-5600-5280-4','A003','3','1952.4.18','$48.6','For Professor');



   INSERT INTO PUBLISHER
   VALUES('A001','WAP','WHU.ISS.C4 317');
   INSERT INTO PUBLISHER
   VALUES('A002','KBSP','WHU.ISS.C4 316');
   INSERT INTO PUBLISHER
   VALUES('A003','KKCP','WHU.ISS.C5 317');
   INSERT INTO PUBLISHER
   VALUES('A004','UIOP','WHU.ISS.C3 317');

3.
   SELECT Title,Price
   FROM  BOOK,PUBLISHER
   WHERE (BOOK.PubID=PUBLISHER.PubID) AND(PUBLISHER.Name='DannyShum' or PUBLISHER.Name='LionLi'); 
4. 
   SELECT Name
   FROM BOOK,PUBLISHER
   WHERE PUBLISHER.PubID=BOOK.ID AND BOOK.Title='Thinking in Java';