createdb.sql

ssd7的本人的答案

CREATE TABLE BOOK
(

PAuthor varchar(20),
Title varchar(40),
ISBN varchar(20),
PublisherID varchar(20),
Edition varchar(20),
DateOfPub date,
Price decimal(4,2),
Description varchar(100),
PRIMARY KEY (ISBN),
UNIQUE (Description)

);


CREATE TABLE PUBLISHER
(
PublisherID varchar(20),
Name varchar(40),
Address varchar(20),
PRIMARY KEY (PublisherID)



);

INSERT INTO BOOK
VALUES ('Jack', 'Database System' ,'001', '01' ,'Second', '2006-03-01' ,'79.00' ,'About basic knowledge of DBS with 
ISBN: 001' );
INSERT INTO BOOK
VALUES ('Tom', 'The Soup Of Soul', '002', '02', 'Third', '2008-04-02' ,'65.00', 'Heart home with ISBN: 002');
INSERT INTO BOOK
VALUES ('Kate','Network Tips','003', '03','First','2003-12-01','45.00','Tips about networkwith ISBN: 003' );
INSERT INTO BOOK
VALUES ('John','CCNA','004','04','Second','2006-09-01','21.89','Description about cisco works with ISBN:004' );


INSERT INTO PUBLISHER
VALUES ('01','Tsinghua','Beijing' );
INSERT INTO PUBLISHER
VALUES ('02','Nwpu','Xi an'  );
INSERT INTO PUBLISHER
VALUES ('04','Electronic Industry','Beijing' );
INSERT INTO PUBLISHER
VALUES ('05','Mechanical Industry','Beiing'  );