圖書館管理系統(tǒng)結(jié)構(gòu)圖

1、圖書館管理系統(tǒng)結(jié)構(gòu)圖庫存盤點系統(tǒng)通過驗證退出系統(tǒng)清除歷史信息選擇續(xù)借書籍圖書續(xù)借系統(tǒng)圖書續(xù)借成功22圖書統(tǒng)計系統(tǒng)借閱圖書次現(xiàn)存圖書數(shù)量再借圖書數(shù)量丟圖書數(shù)量超期圖書數(shù)量第四小組數(shù)據(jù)庫說明：數(shù)據(jù)庫名（DateBook）;主要有五張表：Book(book_id,isbn,title借,author,publisher,price,amount,total_amount,add_date)Borrowbook),reader(reader_id,book_id,borrpw_date,revertible_date丟失圖書表Lossbook(book_id,reader_id,loss_date千里

2、 貝admin ( admin_id , admin_namecreate_date , phone, email , password). 具體ER圖如下：(reader_id,student_id,reader_nameacademy,department,register.summary),管理人員表(admin):讀者表(reader):圖書表(book):丟失圖書表(Lossbook)Book表查詢lossbook 表中的信息。f可以通過Book表查詢 borrowbook/ ' 可以通過Book表查詢 borrowbook 表中的信Lossbook 表是主 鍵 ，reade

3、r 是借書表(borrowbook):表間關(guān)系：創(chuàng)建數(shù)據(jù)庫CREATEDATABASDateBookuseDateBookGo創(chuàng)建admin表CREATETABLEadmin(admin_idintIDENTITY。，1)NOTNuLl,admin_namevarchar(30)CONSTRAINPK_adminInfoPRIMARYKEYCLUSTEREDcreate_datedatetimeNOTNULL,phonevarchar(15)NOTNULL,emailvarchar(80)NOTNULL,passwordvarchar(30)NOTNULL)創(chuàng)建Book表CREATETABLE

4、Book(book_idintIDENTITY(1,1)CONSTRAINTK_BookPRIMARYKEYCLUSTEREDisbnvarchar(15)NOTNULL,titlevarchar(100)NOTNULL,authorvarchar(100)NOTNULL,publishervarchar(80)NOTNULL,pricefloatNOTNULL,amountintNOTNULL,total_amountintNOTNULL,adddatedatetimeNOTNULL)創(chuàng)建borrowbook表CREATETABLEborrowbook(reader_idintCONSTRA

5、INFTK_borrowbook_readerFOREIGNKEYREFERENCErSeader(reader_id),book_idintCONSTRAINFTK_borrowbook_BookFOREIGNKEYREFERENCEBSook(book_id),borrpw_datedatetimeNOTNULL,revertible_datedatetimeNOTNULL,CONSTRAINTPK_sno_CNOPRIMARYKEY(book_id,reader_id)創(chuàng)建reader表CREATETABLEreader(reader_idintIDENTITY(1,1)CONSTRAI

6、NTPK_readerPRIMARYKEYCLUSTERED,student_idvarchar(50)NOTNULL,reader_namevarchar(50)NOTNULL,ageintNOTNULL,academyvarchar(30)NOTNULL,departmentvarchar(50)NOTNULL,registerdatetimeNOTNULL,summaryvarchar(300)NULL)創(chuàng)建Lossbook表CREATETABLELossbook(book_idintCONSTRAINFTK_Lossbook_BookFOREIGNKEYREFERENCEBSook(book_id),reader_idintC