圖書館借閱系統(tǒng)數(shù)據(jù)庫設(shè)計(jì)

經(jīng)典word整理文檔，僅參考，雙擊此處可刪除頁眉頁腳。本資料屬于網(wǎng)絡(luò)整理，如有侵權(quán)，請聯(lián)系刪除，謝謝！二年3月日一、實(shí)驗(yàn)環(huán)境二、實(shí)驗(yàn)?zāi)康乃模拍罱Y(jié)構(gòu)設(shè)計(jì)(概念模型)的過圖書借閱系統(tǒng)的E-R圖nmm11m1nmnnnmR圖書：圖將圖書借閱E-R圖轉(zhuǎn)換為關(guān)系模型圖書列名數(shù)據(jù)類型Char可否為空notnullnotnullnotnullnotnullnotnullNotnull說明BookIDBookNo圖書編號Char圖書的索書號圖書的書名圖書BookNameBookWriterBookPulishBooknumBookDateBookClassBooknumsBookStateBookRNoCharCharChar圖書出版社圖書數(shù)量SmallintDate出版日期Char圖書的分類圖書可借數(shù)量圖書是否可借圖書所在館室號smallintCharNotnullnotnullnotnullChar讀者列名數(shù)據(jù)類型Char可否為空notnullnotnullnotnullnotnull說明讀者編號ReaIDReaNameReaSexReaNoChar讀者姓名Char讀者性別Char讀者學(xué)號ReaDepReaPrefChar讀者所在學(xué)院讀者所屬專業(yè)CharReaGradeReaDateReaBsCharDate讀者的年級辦證日期已借本數(shù)借書狀態(tài)借書上限notnullNotnullNotnnllNotnullSmallintCharReastateReasxSmallint管理員列名主鍵數(shù)據(jù)類型Char可否為空notnull說明管理員編號管理員姓名管理員性別CharnotnullChar館室列名數(shù)據(jù)類型Char可否為空notnullnotnullnotnull說明館室號Char館室管理員編號館室擁有圖書數(shù)目館室地址CharCharChar館室類型借閱信息列名ReaID數(shù)據(jù)類型CharCharCharCharDate可否為空notnullnotnullnotnull說明讀者編號圖書編號圖書名BookIDBookNameBookWriterOutdateIndatenotnull借閱時間歸還時間應(yīng)還時間罰款金額處理狀態(tài)管理員編號DateYHdateFineDatenotnullNotnullCharCharCharCLStateMIDnotnull創(chuàng)建數(shù)據(jù)庫及表格男'女),,)’,)’,,男'女),)建立視圖,,,,)))))建立索引建立觸發(fā)器))’)存儲過程1.Book_Insert的定義:CREATEPROCEDUREBook_Insert@BookIDchar(9),char(20),char(50),@BookNo@BookName@BookWriterchar(30),@BookPublishchar(20),@BookDate@BookClassdatetime,char(20),@Booknumssmallint,@Booknumsmallint,@BookStatechar(10),@BookRNoaschar(5)insertintoBookvalues(@BookID,@BookNo,@BookName,@BookWriter,@BookPublish,@BookDate,@BookClass,@BookState@Booknums,@Booknum);2.Reader_Insert的定義:CREATEPROCEDUREReader_Insert@ReaIDchar(9),char(10),char(2),char(9),char(20),char(5),char(20),Datetime@ReaName@ReaSex@ReaNo@ReaDep@ReaGrade@ReaPref@ReaDate@ReaBssmallint,@Reastatechar(5),@Reasxsmallint,asinsertintoReadervalues(@ReaID,@ReaName,@ReaSex,@ReaNo,@ReaDep,@ReaGrade,@ReaPref,@ReaDate,@ReaBs,@Reastate,@Reasx;3.Maneger_Insert的定義:CREATEPROCEDUREManeger_Insert@MIDchar(10),@MNamechar(10),@MSexchar(2),asinsertintoManegeralues(@MID,@MName,@MSex);4.Borrow_Insert的定義:CREATEPROCEDUREBorrow_Insert@BookIDchar(9),@ReaIDchar(9),@OutdateDatetime,@YHdateDatetime,@IndateDatetime,@Finechar(5),@CLStatechar(8),@MIDchar(10)asinsertintoBorrowvalues(@BookID,@ReaID,@Outdate,@YHdate,@Indate,@Fine,@CLState,@MID);5.Query_Reader_R的定義：createprocedureQuery_Reader_R@ReaIDchar(9)asselect*fromReaderviewwhere編號=ltrim(@ReaID);6.Query_Reader_M的定義：select*fromReaderview7.Query_Book_Writer的定義：@BookWriterchar(50)*wherelike'%'+ltrim(@BookWriter)+'%';8.Query_Book_Name_Publish的定義：createprocedureQuery_Book_Name_Publish@BookNamechar(50),@BookPublishchar(20)asselect*fromBookviewwhere書名=ltrim(@BookName)and=ltrim(@BookPublish);9.Delete_Reader的定義：createprocedureDelete_Reader@ReaNochar(9)asdel