數(shù)據(jù)庫課設(shè)(打印)-資料下載頁
2025-06-23 23:58本頁面
【正文】 很多寶貴的修改意見，在這里，我向這些無私幫助我的人表示衷心的感謝。六、附錄create database Book。create table ReaderType(LBID char(5) primary key,LBName char(20) not null,LBnum char(5) not null,LBbqx char(4) not null,LBqx char(3) not null,)create table Maneger(MID char(10) primary key,MName char(10) not null,MSex char(2),Mpwd char(8) not null,MAuth char(40) not null,MTeleph char(15),MAddre char(30),check(MSex =39。男39。 or MSex =39。女39。))create table Room(RoomNo char(5) primary key,RoomMID char(10) not null,Roomnum char(5),RoomAddre char(20),foreign key(RoomMID) references Maneger(MID),)create table Book( BookID char(9) primary key, BookNo char(20) not null, BookName char(50)not null, BookWriter char(30)not null, BookPublish char(20)not null, BookPrice char(7), BookDate datetime, BookClass char(20), BookMain char(200), BookPrim char(30), BookCopy char(5), BookState char(10)not null, BookRNo char(5)not null,foreign key(BookRNo) references Room(RoomNo),)create table Reader(ReaID char(9) primary key,ReaName char(10) not null,ReaSex char(2) not null,ReaNo char(9) not null,ReaLBID char(5) not null,ReaType char(20),ReaDep char(20),ReaGrade char(5),ReaPref char(20),ReaDate Datetime,foreign key(ReaLBID) references ReaderType(LBID),check(ReaSex =39。男39。 or ReaSex =39。女39。))create table Borrow(BookID char(9),ReaID char(9),Outdate Datetime not null,YHdate Datetime not null,Indate Datetime,Fine char(5),CLState char(8),MID char(10) not null,primary key(BookID,ReaID),foreign key(MID) references Maneger(MID))create clustered index BookPublish on Book(BookPublish)。create clustered index ReaDep on Reader(ReaDep)。create view Bookview (索書號, 書名, 作者, 出版社, 圖書狀態(tài))asselect BookNo,BookName,BookWriter,BookPublish,BookStatefrom Bookcreate view Readerview (編號,讀者姓名,類型,學(xué)院,專業(yè),辦證日期)asselect ReaID,ReaName,ReaType,ReaDep,ReaPref,ReaDatefrom Readercreate view Borrowview (讀者編號,書名,作者,借閱日期,到期日期)asselect ReaID,BookName,BookWriter,Outdate,YHdatefrom Borrow,Bookwhere = and is nullcreate view Historyview (讀者編號,書名,借閱日期,歸還日期)asselect ReaID,BookName,Outdate,Indatefrom Borrow,Bookwhere = and is not nullcreate view Fineview (讀者編號,書名,借閱日期,歸還日期,罰款,處理狀態(tài))asselect ReaID,BookName,Outdate,Indate,Fine,CLStatefrom Borrow,Bookwhere = and Fine is not nullcreate trigger Reader_deleteon Readerfor deleteas delete Borrowfrom deletedwhere =create trigger Borrow_insert1on Borrowfor insertas declare @BookID char(9)select @BookID=BookIDfrom insertedupdate Bookset BookState=39。不可借39。where BookID=@BookID計算機(jī)與通信學(xué)院課程設(shè)計評分表課題名稱： 項(xiàng) 目評 價設(shè)計方案的合理性與創(chuàng)造性設(shè)計與調(diào)試結(jié)果設(shè)計說明書的質(zhì)量答辯陳述與回答問題情況課程設(shè)計周表現(xiàn)情況綜合成績 教師簽名： 日 期： 19
醫(yī)療健康相關(guān)推薦
鄂ICP備17016276號-1