CREATE TABLE LibrarySelect (LibRankn CHAR(30)PRIMARY KEY, LibRankname CHAR(30) ); CREATE TABLE BookList (BLisbn CHAR(20)PRIMARY KEY, BLName CHAR(40), BLAuthor CHAR(30), BLPublishunit CHAR(40), BLPrice CHAR (30), BLRankNumber CHAR(40) FOREIGN KEY(BLRankNumber)REFERENCES LibrarySelect(LibRankn) ); CREATE TABLE Book (BNumber CHAR (40)PRIMARY KEY, BIsbn CHAR (40), BBorrowif CHAR (40), BRemark CHAR (40) ); CREATE TABLE Reader (RMumber CHAR (30) PRIMARY KEY, RName CHAR (30), RUnits CHAR (30), RSage CHAR (30), RAdd CHAR (30), RTeNum CHAR (30), RIdNo CHAR (40) ); CREATE TABLE Borrow (BLendNum CHAR(40)PRIMARY KEY, BLIBnum CHAR(40), BBNum CHAR(30), BLendDate CHAR(40), BReturnDate CHAR (30), BFineCNum CHAR(40), BRemark CHAR(40) FOREIGN KEY( BLIBnum)REFERENCES Reader(RMumber)将第一个与第二个表连接起来 ); CREATE TABLE FineClasNum (FineNum CHAR(40)PRIMARY KEY, FName CHAR(40), FMoney CHAR(30) ); CREATE TABLE ORDER1 (OBSNum CHAR(40)PRIMARY KEY, OLendNum CHAR(40), OBookNum CHAR(30), ODate CHAR(40) ); INSERT INTO LibrarySelect VALUES ('100','文学'); INSERT INTO LibrarySelect VALUES ('200','科技'); INSERT INTO LibrarySelect VALUES ('400','哲学'); INSERT INTO BookList （BLisbn ,BLName ,BLAuthor ,BLPublishunit ,BLPrice ,BLRankNumber） VALUES ('7040195836','数据库系统概论','王珊','高等教育出版社',39.00,200); INSERT INTO BookList （BLisbn ,BLName ,BLAuthor ,BLPublishunit ,BLPrice ,BLRankNumber） VALUES ('9787508040110', '红楼梦', '曹雪芹', '人民出版社', 20.00, 100); INSERT INTO BookList （BLisbn ,BLName ,BLAuthor ,BLPublishunit ,BLPrice ,BLRankNumber） VALUES ('9787506336239', '红楼梦', '曹雪芹', '作家出版社', 34.30 ,100); INSERT INTO BookList （BLisbn, BLName ,BLAuthor, BLPublishunit ,BLPrice ,BLRankNumber） VALUES ('9787010073750', '心学之路', '张立文 ','人民出版社', 33.80 ,300); INSERT INTO Book( BNumber ,BIsbn ,BBorrowif ) VALUES ('2001231', '7040195836 ','否 '); INSERT INTO Book( BNumber ,BIsbn ,BBorrowif ) VALUES ('2001232', '7040195836 ','是'); INSERT INTO Book( BNumber ,BIsbn ,BBorrowif ) VALUES ('1005050', '9787506336239', '否'); INSERT INTO Book( BNumber ,B
