數(shù)據(jù)庫原理與應(yīng)用課程設(shè)計-展示頁
2025-07-06 10:15本頁面
【正文】 kname 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借書證表建立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借書記錄表建立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還書記錄表建立create table return_record( bookid varchar(20) primary key, readerid varchar(9), returndate datetime, foreign key (bookid) references system_books(bookid), foreign key (readerid) references system_readers(readerid))7罰款單表建立*/create table reader_fee( readerid varchar(9)not null, readername varchar(9)not null , bookid varchar(20) primary key, bookname varchar(30) Not null, bookfee varchar(30) , borrowdate datetime, foreign key (bookid) references system_books(bookid), foreign key (readerid) references system_readers(readerid))2數(shù)據(jù)初始化1將書籍類別加入表book_style中insert into book_style(bookstyleno,bookstyle)values(39。, FILENAME = 39。, SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 )LOG ON( NAME = 39。類別實體ER圖：書籍類別實體讀者姓名類別名稱圖 類別實體ER圖讀者信息實體ER圖：讀者信息實體讀者借書證編號讀者姓名讀者性別讀者種類e登記時間圖 讀者信息實體ER圖信息實體ER圖：書籍信息實體書籍編號書籍名稱書籍類別編號書籍作者出版時間收錄時間是否被借出版社圖 信息實體ER圖記錄信息實體ER圖：讀者借書證編號書籍類別編號借閱時間隔借閱記錄信息實體實體圖 記錄信息實體ER圖記錄信息實體ER圖：歸還記錄信息實體實體讀者借書證編號書籍類別編號歸還時間隔圖 記錄信息實體ER圖罰款信息實體ER圖：罰款信息實體實體書籍類別編號罰款金額讀者姓名讀者借書證編號書籍名稱借閱時間隔圖 罰款信息實體ER圖總的信息實體ER圖：信息登記讀者實體書籍實體書類別實體歸還借閱罰款罰款信息實體還書信息實體借閱信息實體實體圖 總的信息實體ER圖數(shù)據(jù)流程圖圖 系統(tǒng)的數(shù)據(jù)流程圖數(shù)據(jù)字典book_sytle 書籍類別信息表表中列名數(shù)據(jù)類型可否為空說明bookstylenovarcharnot null(主鍵)種類編號bookstyleVarcharnot null種類名稱system_readers讀者信息表格表中列名數(shù)據(jù)類型可否為空說明readeridvarcharnot null(主鍵)讀者借書證號readernamevarcharnot null讀者姓名readersexvarcharnot null讀者性別readertypevarcharnull讀者種類regdatedatetimenull登記日期system_book書籍信息表表中列名數(shù)據(jù)類型可否為空說明bookidVarcharNot null(主鍵)書籍編號booknameVarcharNot null書籍名稱bookstyleVarcharNot null書籍類別bookauthorVarcharNot null書籍作者bookpubVarcharNull出版社名稱bookpubdateDatetimeNull出版日期bookindateDatetimeNull登記日期isborrowedVarcharNot Null是否被借出borrow_record 借閱記錄信息表表中列名數(shù)據(jù)類型可否為空說明readeridVarcharNot null(外主鍵)讀者借閱證編號bookidVarcharNot null(外主鍵)書籍編號borrowdateVarcharNot null讀者借書時間return_record 借閱記錄信息表表中列名數(shù)據(jù)類型可否為空說明readernameVar
醫(yī)療健康相關(guān)推薦
鄂ICP備17016276號-1