【正文】 (12) not null, publishName varchar(50), publishDate datetime, introduction varchar(200), CONSTRAINT BookPK PRIMARY KEY(bookNo), CONSTRAINT BookPK1 FOREIGN KEY(classNo) REFERENCES BookClass (classNo)) （3）創(chuàng)建管理員表Admin CREATE TABLE Admin( adminNo varchar(12) not null, adminName varchar(12) not null, aSex varchar(2) not null, aPhoneNumber varchar(12) null, address varchar(40) null, CONSTRAINT AdminPK PRIMARY KEY(adminNo)) （4）創(chuàng)建讀者表ReaderCREATE TABLE Reader( readerNo varchar(12) not null , readerName varchar(10) not null, rSex varchar(2) not null, rPhoneNumber varchar(12) null, institute varchar(20) not null, effectDate datetime, lostEffectDate datetime, breakRules char(2), borrowAdd int, CONSTRAINT ReaderPK PRIMARY KEY(readerNo)) （5）創(chuàng)建借閱表BorrowCREATE TABLE Borrow( adminNo varchar(12) not null, bookNo varchar(20) not null, readerNo varchar(12) not null, borrowDate datetime not null, shouldDate datetime not null, renewal char(4) not null, CONSTRAINT BorrowPK PRIMARY KEY(adminNo,readerNo,bookNo), CONSTRAINT BorrowPK1 FOREIGN KEY(adminNo) REFERENCES Admin(adminNo), CONSTRAINT BorrowPK2 FOREIGN KEY(readerNo)REFERENCES Reader(readerNo), CONSTRAINT BorrowPK3 FOREIGN KEY(bookNo) REFERENCES Book(bookNo), ) （6）創(chuàng)建管理員_圖書(shū)表Admin_BookCREATE TABLE Admin_Book( adminNo varchar(12) not null, bookNo varchar(20) not null, shopTime datetime, inLibrary char(4) CONSTRAINT Admin_BookPK PRIMARY KEY(adminNo,bookNo), CONSTRAINT Admin_BookPK1 FOREIGN KEY(adminNo) REFERENCES Admin(adminNo),) （7）創(chuàng)建管理員_讀者 Admin_Reader CREATE TABLE Admin_Reader( adminNo varchar(12) not null, readerNo varchar(12) not null, bookNo varchar(20) not null, brCheck char(4) not null, CONSTRAINT Admin_readerPK PRIMARY KEY(adminNo,readerNo,bookNo), CONSTRAINT Admin_readerPK1 FOREIGN KEY(adminNo) REFERENCES Admin(adminNo), CONSTRAINT Admin_readerPK2 FOREIGN KEY(readerNo) REFERENCES Reader(readerNo), CONSTRAINT Admin_readerPK3 FOREIGN KEY(bookNo) REFERENCES Book(bookNo)) Create Trigger RENEW On Borrowfor Update As If Update(renewal) begin Update Borrow Set shouldDate=shouldDate+30 Where adminNo=1001 end （1）注冊(cè)INSERT