圖書(shū)管理系統(tǒng)--數(shù)據(jù)庫(kù)系統(tǒng)概論課程設(shè)計(jì)(編輯修改稿)
2025-02-14 14:44 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 書(shū)籍作者出版時(shí)間收錄時(shí)間是否被借出版社圖23信息實(shí)體ER圖：讀者借書(shū)證編號(hào)書(shū)籍類別編號(hào)借閱時(shí)間隔借閱記錄信息實(shí)體實(shí)體圖24 記錄信息實(shí)體ER圖5．記錄信息實(shí)體ER圖：歸還記錄信息實(shí)體實(shí)體讀者借書(shū)證編號(hào)書(shū)籍類別編號(hào)歸還時(shí)間隔圖25記錄信息實(shí)體ER圖6．罰款信息實(shí)體ER圖：罰款信息實(shí)體實(shí)體書(shū)籍類別編號(hào)罰款金額讀者姓名讀者借書(shū)證編號(hào)書(shū)籍名稱借閱時(shí)間隔圖26罰款信息實(shí)體ER圖7．總的信息實(shí)體ER圖：信息登記讀者實(shí)體書(shū)籍實(shí)體書(shū)類別實(shí)體歸還借閱罰款罰款信息實(shí)體還書(shū)信息實(shí)體借閱信息實(shí)體實(shí)體圖27總的信息實(shí)體ER圖部分表格截圖：表：表21：讀者信息表22：書(shū)籍信息表23：借書(shū)信息部分代碼實(shí)現(xiàn)代碼：1．創(chuàng)建數(shù)據(jù)庫(kù)USE masterGOCREATE DATABASE librarysystemON ( NAME = librarysystem, FILENAME = 39。d:\39。, SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 )LOG ON( NAME = 39。library39。, FILENAME = 39。d:\39。, SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB )GO2．書(shū)本類別表建立create table book_style( bookstyleno varchar(30) primary key, bookstyle varchar(30))3．創(chuàng)建書(shū)庫(kù)表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),)4．借書(shū)證表建立create table system_readers ( readerid varchar(9)primary key, readername varchar(9)not null , readersex varchar(2) not null, readertype varchar(10), regdate datetime)5．借書(shū)記錄表建立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),)6．還書(shū)記錄表建立
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1