數(shù)據(jù)庫圖書管理系統(tǒng)課程設(shè)計(編輯修改稿)
2025-05-04 23:10 本頁面
【文章內(nèi)容簡介】 varchar(30 , 出版社bookpubdate datetime, 出版時間bookindate datetime , 收錄時間isborrowed bit, 是否被借建立讀者信息表create table system_readers (readerid varchar(9primary key,借書證號為主鍵readername varchar(10 not null,讀者姓名readersex char(2not null,性別readertype varchar(20not null,讀者類型regdate datetime,登記時間booktotal int,可借書數(shù)borrowednum int,已借書數(shù)overduenoreturnnum int過期末還書數(shù)建立借書記錄表create table borrow_record( bookid varchar(20 primary key,書籍編號 readerid varchar(9,借書證號 borrowdate datetime,借書時間 foreign key (bookid references system_books(bookid,定義書籍編號為借書表地外鍵Zzz6ZB2Ltk foreign key (readerid references system_readers(readerid,定義借書證號為借書表地外鍵dvzfvkwMI1建立還書記錄表create table return_record( bookid varchar(20 primary key,書籍編號為主鍵 readerid varchar(9,借書證號 returndate datetime,歸還時間 foreign key (bookid references system_books(bookid,定義書籍編號外鍵rqyn14ZNXI foreign key (readerid references system_readers(readerid定義借書證號為外鍵EmxvxOtOco 建立罰款單表create table reader_fee( readerid varchar(9not null,借書證號 readername varchar(9not null ,讀者姓名 bookid varchar(20 primary key,借書證號 bookname varchar(30 Not null, 書籍名稱 bookfee smallmoney,罰款金額 borrowdate datetime,借閱時間 foreign key (bookid references system_books(bookid, 定義書籍編號外鍵SixE2yXPq5 foreign key (readerid references system_readers(readerid 定義借書證號為外鍵6ewMyirQFL索引地創(chuàng)建create index borrow_record_index_readerid on borrow_record(readerid—為借閱表在借書證號上建索引kavU42VRUscreate index reader_fee_index_readerid on reader_fee (readerid—為罰款表在借書證號上建索引y6v3ALoS89create index
公司管理相關(guān)推薦
鄂ICP備17016276號-1