數(shù)據(jù)庫(kù)圖書管理系統(tǒng)(含代碼)-文庫(kù)吧
2025-03-23 23:10 本頁(yè)面
【正文】 char(2)讀者性別rPhoneNumbervarchar(12)聯(lián)系電話institutevarchar(20)學(xué)院effectDatedatetime生效日期lostEffectDatedatetime失效日期breakRuleschar(2)違規(guī)情況borrowAddint累計(jì)借書表34 Admin屬性名稱數(shù)據(jù)類型屬性描述adminNovarchar(12)管理員編號(hào)adminNamevarchar(12)管理員姓名aSexvarchar(2)管理員性別aPhoneNumbervarchar(12)聯(lián)系電話addressvarchar(40)家庭住址表35 Borrow屬性名稱數(shù)據(jù)類型屬性描述adminNovarchar(12)管理員編號(hào)bookNovarchar(20)圖書編號(hào)readerNovarchar(12)讀者編號(hào)borrowDatedatetime結(jié)束日期shouldDatedatetime應(yīng)該歸還日期renewalchar(4)是否續(xù)借表36 Admin_Book屬性名稱數(shù)據(jù)類型屬性描述adminNovarchar(12)管理員編號(hào)bookNovarchar(20)圖書編號(hào)shopTomedatetime入庫(kù)時(shí)間inLibrarychar(4)是否在館表37 Admin_Reader屬性名稱數(shù)據(jù)類型屬性描述adminNovarchar(12)管理員編號(hào)readerNovarchar(12)讀者編號(hào)bookNovarchar(20)圖書編號(hào)brCheckchar(4)歸還確認(rèn)六．?dāng)?shù)據(jù)庫(kù)編程（1）創(chuàng)建圖書分類表BookClassCREATE TABLE BookClass( classNo varchar(3) not null,className varchar(20) null,CONSTRAINT BookClassPK PRIMARY KEY(classNo))（2）創(chuàng)建圖書表BookCREATE TABLE Book(bookNo varchar(20) not null , classNo varchar(3) not null, bookName varchar(50) not null, author varchar(12) not null, publishName varchar(50), publishDate datetime, introduction varchar(200), CONSTRAINT BookPK PRIMARY KEY(bookNo), CONSTRAINT BookPK1 FOREIGN KEY(classNo) REFERENCES BookClass (classNo)) （3）創(chuàng)建管理員表Admin CREATE TABLE Admin( adminNo varchar(12) not null, adminName varchar(12) not null, aSex varchar(2) not null, aPhoneNumber varchar(12) null, address varchar(40) null, CONSTRAINT AdminPK PRIMARY KEY(adminNo)) （4）創(chuàng)建讀者表ReaderCREATE TABLE Reader( readerNo varchar(12) not null , readerName varchar(10) not null, rSex varchar(2) not null, rPhoneNumber varchar(12) null, institute varchar(20) not null, effectDate datetime, lostEffectDate datetime, breakRules char(2), borrowAdd int, CONSTRAINT ReaderPK PRIMARY KEY(readerNo)) （5）創(chuàng)建借閱表BorrowCREATE TABLE Borrow( adminNo varchar(12) not null, bookNo varchar(20) not null, readerNo varchar(12) not null, borrowDate datetime not null, shouldDate datetime not null, renewal char(4) not null, CONSTRAINT BorrowPK PRIMARY KEY(adminNo,readerNo,bookNo), CONSTRAI
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1