數(shù)據(jù)庫原理與應(yīng)用課程設(shè)計(編輯修改稿)
2024-07-24 10:15 本頁面
【文章內(nèi)容簡介】 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。139。,39。人文藝術(shù)類39。) insert into book_style(bookstyleno,bookstyle)values(39。239。,39。自然科學(xué)類39。)insert into book_style(bookstyleno,bookstyle)values(39。339。,39。社會科學(xué)類39。)insert into book_style(bookstyleno,bookstyle)values(39。439。,39。圖片藝術(shù)類39。)insert into book_style(bookstyleno,bookstyle)values(39。539。,39。政治經(jīng)濟類39。)insert into book_style(bookstyleno,bookstyle)values(39。639。,39。工程技術(shù)類39。)insert into book_style(bookstyleno,bookstyle)values(39。739。,39。語言技能類39。)2將已有的圖書加入system_books表中(定義相同的作者出版社的書本編號不一樣)insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub,bookpubdate, bookindate, isborrowed )values(39。0012541515239。,39。計算機組成原理39。,39。639。,39。王愛英39。,39。清華大學(xué)出版社39。,39。2001010339。,39。2003111539。,39。139。)。insertinto system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub,bookpubdate, bookindate, isborrowed )values(39。0012541515339。,39。計算機組成原理39。,39。639。,39。王愛英39。,39。清華大學(xué)出版社39。,39。2001010339。,39。2003111539。,39。139。)。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed )values(39。0045645639。,39。數(shù)據(jù)庫原理39。,39。639。,39。薩師煊39。,39。高等教育出版社39。,39。2007070239。,39。2007091539。,39。139。)。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub,bookpubdate, bookindate, isborrowed )values(39。1221512139。,39。C程序設(shè)計39。,39。639。,39。譚浩強39。,39。清華大學(xué)出版社39。,39。2002040239。,39。2004031439。,39。139。)。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed )values(39。978730802055839。,39。計算機體系結(jié)構(gòu)39。,39。639。,39。石教英39。,39。浙江大學(xué)出版社39。,39。2004100339。,39。2006111539。,39。139。)。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed )values(39。4545614141439。,39。數(shù)據(jù)結(jié)構(gòu)（C語言版）39。,39。639。,39。吳偉民，嚴(yán)蔚敏39。,39。清華大學(xué)出版社39。,39。2002062839。,39。2004012139。,39。139。)。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed )values(39。545551539。,39。中華歷史5000年39。,39。139。,39。吳強39。,39。北京大學(xué)出版社39。,39。2005040339。,39。2006051539。,39。139。)。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed )values(39。01511539。,39。古代埃及39。,39。339。,39。趙文華39。,39。北京大學(xué)出版社39。,39。2001020239。,39。2002091539。,39。139。)。insert into syste
醫(yī)療健康相關(guān)推薦
鄂ICP備17016276號-1