1、15图书馆管理系统结构图15#15#VVVV1管修离库关退图图图理改开存于出书书书人密挂盘本系借归续员码起占八、系统阅还借系统系统系统系统统系统系统系统主界面r1TVVV1TVV1T图图统新图统读读读书书计书书计者者者统查超登修遗信登删计询期记改失息记除系系图系系图系系系统统书统统书统统统15#15#15归还图书图书统计系统总借现再超丢藏阅存借期失书图图图图图数书书书书书量次数数数数数量量量量15第四小组15数据库说明：数据库名（DateBook）；主要有五张表：TOCo1-5hzHYPERLINKlbookmark10图书表Book()book_id,isbn,
2、title,author,publisher,price,amount,total_amount,add_date借书表Borrowbook(reader_id,book_id,borrpw_date,revertible_date)丢失图书表Lossbook(book_id,reader_id,loss_date),HYPERLINKlbookmark12读者表reader()reader_id,student_id,reader_name,age,academy,department,register,summaryHYPERLINKlbookmark14管理人员表admin(
6、in_namevarchar(30)CONSTRAINTPK_adminInfoPRIMARYKEYCLUSTERED,create_datedatetimeNOTNULL,phonevarchar(15)NOTNULL,emailvarchar(80)NOTNULL,passwordvarchar(30)NOTNULL)创建Book表CREATETABLEBook(book_idintIDENTITY(1,1)CONSTRAINTPK_BookPRIMARYKEYCLUSTERED,isbnvarchar(15)NOTNULL,titlevarchar(100)NOTNULL,authorv
7、archar(100)NOTNULL,publishervarchar(80)NOTNULL,pricefloatNOTNULL,amountintNOTNULL,total_amountintNOTNULL,add_datedatetimeNOTNULL)创建borrowbook表CREATETABLEborrowbook(reader_idintCONSTRAINTFK_borrowbook_readerFOREIGNKEYREFERENCESreader(reader_id),book_idintCONSTRAINTFK_borrowbook_BookFOREIGNKEYREFERENC
8、ESBook(book_id),borrpw_datedatetimeNOTNULL,revertible_datedatetimeNOTNULL,CONSTRAINTPK_sno_CNOPRIMARYKEY(book_id,reader_id)创建reader表CREATETABLEreader(reader_idintIDENTITY(1,1)CONSTRAINTPK_readerPRIMARYKEYCLUSTERED,student_idvarchar(50)NOTNULL,reader_namevarchar(50)NOTNULL,ageintNOTNULL,academyvarchar(30)NOTNULL,departmentvarchar(50)NOTNULL,registerdatetimeNOTNULL,summaryvarchar(300)NULL)仓建Lossbook表CREATETABLELossbook(book_idintCONSTRAINTFK_Lossbook_BookFOREIGNK