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

1、15 圖書館管理系統(tǒng)結(jié)構(gòu)圖15 #15 #VVVV1管修離庫關(guān)退圖圖圖理改開存于出書書書人密掛盤本系借歸續(xù)員碼起占八、系統(tǒng)閱還借系統(tǒng)系統(tǒng)系統(tǒng)系統(tǒng)統(tǒng)系統(tǒng)系統(tǒng)系統(tǒng)主界面r1TVVV1TVV1T圖圖統(tǒng)新圖統(tǒng)讀讀讀書書計書書計者者者統(tǒng)查超登修遺信登刪計詢期記改失息記除系系圖系系圖系系系統(tǒng)統(tǒng)書統(tǒng)統(tǒng)書統(tǒng)統(tǒng)統(tǒng)15 #15 #15 歸還圖書圖書統(tǒng)計系統(tǒng)總借現(xiàn)再超丟藏閱存借期失書圖圖圖圖圖數(shù)書書書書書量次數(shù)數(shù)數(shù)數(shù)數(shù)量量量量15 第四小組15 數(shù)據(jù)庫說明：數(shù)據(jù)庫名（DateBook）；主要有五張表：TOC o 1-5 h z HYPERLINK l bookmark10圖書表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), HYPERLINK l bookmark12讀者表reader()reader_id,student_id,reader_name,age,academy,department,register,summary HYPERLINK l bookmark14管理人員表admin(

3、).admin_id,admin_name,create_date,phone,email,password具體ER圖如下：15 15 借書表讀者編號圖書編號歸還時間借出時間15 #15 管理人員表(admin):列名備注數(shù)據(jù)類型一長度允許為空adminjd管理員編號int4不允許admin_name管理員姓名varchar30不允許password密碼varchar30不允許createdate出生日期datetime8不允許phone電話varchar15不允許email吐子郵箱varchar80不允許讀者表(reader):列名備注數(shù)據(jù)類型長度允許為空readerid讀者編號int4不允

4、許studentjd學號varchar50不允許reader_name讀者姓名varchar50不允許age年齡int4不允許sex性別char2不允許academy學校varchar3不允許department院系varchar50register注冊時間datetime8圖書表(book):丟失圖書表（Lossbook）:列名備注tJt數(shù)據(jù)類型長度允許為空bookid（主葡圖書編號int4不允許reader_id（主鍵）讀者編號varchar4不允許loss_date丟失時間varchar8不允許借書表（borrowbook）:列名備注數(shù)據(jù)類型長度允許為空readerid（主鍵）一讀者編號

5、int4不允許bookid（主鍵）一圖書編號int4不允許borrpw_date借出時間datetime8不允許revertible_date歸還時間datetime8不允許表間關(guān)系:可以通過Book表查詢borrowbook表中的信息?？梢酝ㄟ^Book表查詢borrowbook表中的信息。Lossbook表是主鍵,reader是可以通過Book表查詢lossbook表中的信息。Sql代碼如下:創(chuàng)建數(shù)據(jù)庫CREATEDATABASEDateBookuseDateBookGo倉U建admin表CREATETABLEadmin(admin_idintIDENTITY(1,1)NOTNULL,adm

6、in_namevarchar(30)CONSTRAINTPK_adminInfoPRIMARYKEYCLUSTERED,create_datedatetimeNOTNULL,phonevarchar(15)NOTNULL,emailvarchar(80)NOTNULL,passwordvarchar(30)NOTNULL)創(chuàng)建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)創(chuàng)建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)創(chuàng)建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