createdb.sql

ssd7的练习一

CREATE TABLE PUBLISHER(
  PublisherID      INTEGER,
  Name             VARCHAR(30),
  Address          VARCHAR(40),
  CONSTRAINT 
      PK_PUBLISHER PRIMARY KEY(PublisherID),
      UNIQUE(name)
);
CREATE TABLE BOOK( 
  "Primary Author"       VARCHAR(20),
  Title                  VARCHAR(60),
  ISBN                   VARCHAR(60),
  PublisherID            INTEGER,
  Edition                INTEGER,
  "Date of Publication"  DATE,
  Price                  NUMERIC(5,2),
  "Book Description"     VARCHAR(1000),
   CONSTRAINT PK_BOOK PRIMARY KEY(ISBN),
   UNIQUE(Title),
   CONSTRAINT FK_BOOK_PUBLISHER 
      FOREIGN KEY(PublisherID) 
      REFERENCES PUBLISHER(PublisherID)  
);
INSERT INTO PUBLISHER
VALUES(2458,'China Machine Press','Beijing');
INSERT INTO PUBLISHER
VALUES(2785,'Wenhui Publishing House','Shanghai');
INSERT INTO PUBLISHER
VALUES(3478,'Tsinghua University Press','Beijing' );

INSERT INTO BOOK
VALUES('Kennethe C.Louden','Complier Construction Principles and Practice','978-7-111-077703-9',2458,1,TO_DATE('2007/9','YYYY/MM/DD'),39,'Major about complier Construction Principles and Practice.');
INSERT INTO BOOK
VALUES('Bruce Eckel','Thingking in C++','7-111-10807-8',2458,2,TO_DATE('2005/11','YYYY/MM/DD'),59,'Description about C++, which is a kind of programme language.');
INSERT INTO BOOK
VALUES('Richard A. Knaak','Day of The Dragon','978-7-80741-137-6',2785,1,TO_DATE('2007/5','YYYY/MM/DD'),20,'A book about a interesting story.');
INSERT INTO BOOK
VALUES('William Stallings','Computer Organization and Architecture','978-7-302-12444-3',3478,7,TO_DATE('2007/8','YYYY/MM/DD'),66,'Major about Computer Organization and Architecture.');