數(shù)據(jù)庫原理與應用課程設計-全文預覽
【正文】 ow_record(bookid,readerid,borrowdate)values(39。)update system_booksset isborrowed=0where bookid=39。,39。 and isborrowed=39。,39。insert into borrow_record(bookid,readerid,borrowdate)values(39。,39。)4添加已借書讀者的記錄，同時將在已借出的借閱標記置0*/insert into borrow_record(bookid,readerid,borrowdate)values(39。,39。,39。,39。,39。)insert into system_readers(readerid,readername,readersex,readertype,regdate)values(39。,39。,39。,39。,39。)insert into system_readers(readerid,readername,readersex,readertype,regdate)values(39。,39。,39。,39。,39。3將已有圖書證的讀者加入system_readers表中*/insert into system_readers(readerid,readername,readersex,readertype,regdate)values(39。2000012139。北京大學出版社39。239。56580002039。,39。,39。,39。,39。139。2000100339。李小剛39。微觀經濟學39。)。,39。,39。,39。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed )values(39。2002091539。北京大學出版社39。339。01511539。,39。,39。,39。,39。139。2002062839。吳偉民，嚴蔚敏39。數(shù)據(jù)結構（C語言版）39。)。,39。,39。,39。insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed )values(39。2004031439。清華大學出版社39。639。1221512139。,39。,39。,39。,39。139。2001010339。王愛英39。計算機組成原理39。)。,39。,39。,39。)2將已有的圖書加入system_books表中(定義相同的作者出版社的書本編號不一樣)insert into system_books(bookid ,bookname, bookstyleno,bookauthor,bookpub,bookpubdate, bookindate, isborrowed )values(39。)insert into book_style(bookstyleno,bookstyle)values(39。)insert into book_style(bookstyleno,bookstyle)values(39。)insert into book_style(bookstyleno,bookstyle)values(39。)insert into book_style(bookstyleno,bookstyle)values(39。)insert into book_style(bookstyleno,bookstyle)values(39。) insert into book_style(bookstyleno,bookstyle)values(39。, SIZE = 5MB, MAXSIZE = 25MB, FILEGROWTH = 5MB )GO2書本類別表建立create table book_style( bookstyleno varchar(30) primary key, bookstyle varchar(30))3創(chuàng)建書庫表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借書證表建立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罰款單表建立*
醫(yī)療健康相關推薦
鄂ICP備17016276號-1