數(shù)據(jù)庫圖書管理系統(tǒng)(含代碼)-wenkub
2023-04-22 23:10:24 本頁面
【正文】 ex= rSex, rPhoneNumber = rPhoneNumber , institute= institute, effectDate =effectDate ,lostEffectDate= lostEffectDate, breakRules =breakRules, borrowAdd =borrowAdd）(4)查詢SELECT * FROM BookWHERE bookNo=bookNo OR bookName=bookName5. 管理員對借閱關(guān)系的操作(1) 插入讀者的信息INSERTreaderNo = readerNoReader SETAND③更新還書信息UPDATE Admin_Book SET(inLibrary=1) WHERE(bookNo =bookNo) UPDATE Admin_Reader SET(brCheck =’1’) WHERE(adminNo = adminNobookNo = bookNo)七．代碼實(shí)現(xiàn)1．輸入數(shù)據(jù)設(shè)計(jì)（1）插入圖書分類INSERT INTO BookClass (classNo,className)VALUES(39。)INSERT INTO BookClass (classNo,className)VALUES(39。)INSERT INTO BookClass (classNo,className)VALUES(39。)INSERT INTO BookClass (classNo,className)VALUES(39。)（2）插入管理員INSERT INTO Admin (adminNo, adminName, aSex, aPhoneNumber, address) VALUES(39。,39。,39。,39。,39。,39。,39。) （4）插入圖書INSERT INTO Book (bookNo, classNo,bookName, author, publishName, publishDate, introduction) VALUES(39。,39。,39。,39。,39。,39。,39。) INSERT INTO Book (bookNo, classNo,bookName, author, publishName, publishDate, introduction) VALUES(39。,39。,39。,39。,39。,39。,39。) INSERT INTO Book (bookNo, classNo,bookName, author, publishName, publishDate, introduction) VALUES(39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。,39。, 39。)= 39。,39。,39。,39。 WHERE bookNo=39。 INSERT INTO Admin_Reader (adminNo, readerNo, bookNo, brCheck) VALUES(39。,39。) print 39。 (2)續(xù)借操作如下：if((SELECT renewal FROM Borrow WHERE adminNo =39。 AND bookNo =39。) begin UPDATE BorrowSET renewal=39。 AND readerNo =39。print 39。 （3）歸還操作如下：If((SELECT brCheck FROM Admin_Reader WHERE adminNo =39。 AND bookNo =39。) BEGIN UPDATE Admin_Book SET inLibrary =39。print 39。 八．模式求精Admin_Book (adminNo, bookNo, shopTime, inLibrary) 依據(jù)BCNF, Admin_Book可以分解為以下兩個(gè)模式：Admin_ Book (bookNo, shopTime, inLibrary)Admin_s(adminNo,bookNo)可以驗(yàn)證，關(guān)系模式滿足BCNF要求，且分解是無損分解?？偟脕碚f，此次實(shí)訓(xùn)，我受益匪淺。在此次實(shí)訓(xùn)中，我遇到了很多問題，每個(gè)表格都經(jīng)過了一系列的修改。 end else print 39。 WHERE bookNo =39。)=39。 AND readerNo =39。 end else print 39。 AND bookNo =39。 WHERE adminNo =39。)=39。 AND readerNo =39。 end else print 39。,39。,39。UPDATE Reader SET borrowAdd=borrowAdd+1 WHERE readerNo =39。) UPDATE Admin_Book SET inLibrary =39。,39。,39。) begin INSERT INTO Borrow (adminNo, bookNo,readerNo, borrowDate,shouldDate ,renewal) VALUES(39。) 、續(xù)借、歸還的操作設(shè)計(jì)假設(shè)讀者想借書籍名為《JAVA》且不知道bookNo （1）借閱操作如下：if((select bookName from Book where bookNo=39。,39。) INSERT INTO Admin_Reader (a
公司管理相關(guān)推薦
鄂ICP備17016276號-1