數(shù)據(jù)庫(kù)原理與應(yīng)用—圖書管理系統(tǒng)課程設(shè)計(jì)(編輯修改稿)
2024-10-14 13:56 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 ime , 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), ) 還書記錄表建立 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) ) 10 罰款單表建立 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) ) 將書籍類別加入 book_style 表中 insert into book_style(bookstyleno,bookstyle)values(‘ 1’，‘人文藝術(shù)類’ ) insert into book_style(bookstyleno,bookstyle)values(‘ 2’，‘自然科學(xué)類’ ) insert into book_style(bookstyleno,bookstyle)values(‘ 3’，‘社會(huì)科學(xué)類’ ) insert into book_style(bookstyleno,bookstyle)values(‘ 4’，‘圖片藝術(shù)類’ ) insert into book_style(bookstyleno,bookstyle)values(‘ 5’，‘政治經(jīng)濟(jì)類’ ) insert into book_style(bookstyleno,bookstyle)values(‘ 6’，‘工程技術(shù)類’ ) insert into book_style(bookstyleno,bookstyle)values(‘ 7’，‘語(yǔ)言技能類’ ) 將已有的圖書加入 system_books表中 insert into system_books(bookid ,bookname, bookstyleno,bookauthor, bookpub,bookpubdate, bookindate, isborrowed ) values(‘ 00125415152’ ,‘計(jì)算機(jī)組成原理’ ,‘ 6’ ,‘王愛(ài)英’ ,‘清華大學(xué)出版社’ ,‘ 20200103’ ,‘ 20201115’ ,‘ 1’ )。 insert into system_books(bookid,bookname, bookstyleno,bookauthor, bookpub,bookpubdate,bookindate, isborrowed ) values(‘ 00125415153’ ,‘計(jì)算機(jī)組成原理’ ,‘ 6’ ,‘王愛(ài)英’ ,‘清華大學(xué)出版社’ ,‘ 20200103’ ,‘ 20201115’ ,‘ 1’ )； insert into system_books(bookid,bookname,bookstyleno,bookauthor, 11 bookpub, bookpubdate,bookindate, isborrowed ) values(‘ 00456456’ ,‘?dāng)?shù)據(jù)庫(kù)原理’ ,‘ 6’ ,‘薩師煊’ ,‘高等教育出版社’ ,‘ 20200702’ ,‘ 20200915’ ,‘ 1’ )； insert into system_books(bookid,bookname, bookstyleno,bookauthor, bookpub,bookpubdate,bookindate,isborrowed ) values(‘ 12215121’ ,‘ C程序設(shè)計(jì)’ ,‘ 6’ ,‘譚浩強(qiáng)’ ,‘清華大學(xué)出版社’ ,‘ 20200402’ ,‘ 20200314’ ,‘ 1’ )； insert into system_books(bookid ,bookname, bookstyleno,bookauthor, bookpub, bookpubdate,bookindate, isborrowed ) values(‘ 9787308020558’ ,‘計(jì)算機(jī)體系結(jié)構(gòu)’ ,‘ 6’ ,‘石教英’ ,‘浙江大學(xué)出版社’ ,‘ 20201003’ ,‘ 20201115’ ,‘ 1’ )； insert into tem_books(bookid,bookname,bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed ) values(‘ 45456141414’ ,‘?dāng)?shù)據(jù)結(jié)構(gòu)（ C 語(yǔ)言版）’ ,‘ 6’ ,‘吳偉民，嚴(yán)蔚敏’ ,‘清華大學(xué)出版社’ ,‘ 20200628’ ,‘ 20200121’ ,‘ 1’ )； insert into system_books(bookid ,bookname, bookstyleno,bookauthor, bookpub, bookpubdate,bookindate, isborrowed ) values(‘ 5455515’ ,‘中華歷史 5000 年’ ,‘ 1’ ,‘吳強(qiáng)’ ,‘北京大學(xué)出版社’ ,‘ 20200403’ ,‘ 20200515’ ,‘ 1’ )。 insert into system_books(
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1