數(shù)據(jù)庫課程設(shè)計報告--圖書館管理系統(tǒng)-文庫吧在線文庫
【正文】 ，圖書借閱管理，信息查詢。8．借書信息的查詢、修改，包括借書證編號、讀者編號、讀者姓名、書籍編號、書籍名稱、借書日期等。create table book_style( bookstyleno varchar(30) primary key, bookstyle varchar(30))create table system_books( bookid varchar(20) primary key, bookname varchar(30) Not null, bookstyleno varchar(30) Not null, bookauthor varchar(30), bookpub varchar(30) , bookpubdate datetime, bookindate datetime , isborrowed varchar (2) ,foreign key (bookstyleno) references book_style (bookstyleno),)create table system_readers ( readerid varchar(9)primary key, readername varchar(9)not null , readersex varchar(2) not null, readertype varchar(10), regdate datetime)create table borrow_record( bookid varchar(20) primary key, readerid varchar(9), borrowdate datetime, foreign key (bookid) references system_books(bookid), foreign key (readerid) references system_readers(readerid),)
范文總結(jié)相關(guān)推薦
鄂ICP備17016276號-1