数据库原理与应用—图书管理系统课程设计

数据库原理与应用—图书管理系统课程设计内容摘要：

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’，‘人文艺术类’ ) insert into book_style(bookstyleno,bookstyle)values(‘ 2’，‘自然科学类’ ) insert into book_style(bookstyleno,bookstyle)values(‘ 3’，‘社会科学类’ ) insert into book_style(bookstyleno,bookstyle)values(‘ 4’，‘图片艺术类’ ) insert into book_style(bookstyleno,bookstyle)values(‘ 5’，‘政治经济类’ ) insert into book_style(bookstyleno,bookstyle)values(‘ 6’，‘工程技术类’ ) insert into book_style(bookstyleno,bookstyle)values(‘ 7’，‘语言技能类’ ) 将已有的图书加入 system_books表中 insert into system_books(bookid ,bookname, bookstyleno,bookauthor, bookpub,bookpubdate, bookindate, isborrowed ) values(‘ 00125415152’ ,‘计算机组成原理’ ,‘ 6’ ,‘王爱英’ ,‘清华大学出版社’ ,‘ 20200103’ ,‘ 20201115’ ,‘ 1’ )。 insert into system_books(bookid,bookname, bookstyleno,bookauthor, bookpub,bookpubdate,bookindate, isborrowed ) values(‘ 00125415153’ ,‘计算机组成原理’ ,‘ 6’ ,‘王爱英’ ,‘清华大学出版社’ ,‘ 20200103’ ,‘ 20201115’ ,‘ 1’ )； insert into system_books(bookid,bookname,bookstyleno,bookauthor, 11 bookpub, bookpubdate,bookindate, isborrowed ) values(‘ 00456456’ ,‘数据库原理’ ,‘ 6’ ,‘萨师煊’ ,‘高等教育出版社’ ,‘ 20200702’ ,‘ 20200915’ ,‘ 1’ )； insert into system_books(bookid,bookname, bookstyleno,bookauthor, bookpub,bookpubdate,bookindate,isborrowed ) values(‘ 12215121’ ,‘ C程序设计’ ,‘ 6’ ,‘谭浩强’ ,‘清华大学出版社’ ,‘ 20200402’ ,‘ 20200314’ ,‘ 1’ )； insert into system_books(bookid ,bookname, bookstyleno,bookauthor, bookpub, bookpubdate,bookindate, isborrowed ) values(‘ 9787308020558’ ,‘计算机体系结构’ ,‘ 6’ ,‘石教英’ ,‘浙江大学出版社’ ,‘ 20201003’ ,‘ 20201115’ ,‘ 1’ )； insert into tem_books(bookid,bookname,bookstyleno,bookauthor,bookpub, bookpubdate,bookindate, isborrowed ) values(‘ 45456141414’ ,‘数据结构（ C 语言版）’ ,‘ 6’ ,‘吴伟民，严蔚敏’ ,‘清华大学出版社’ ,‘ 20200628’ ,‘ 20200121’ ,‘ 1’ )； insert into system_books(bookid ,bookname, bookstyleno,bookauthor, bookpub, bookpubdate,bookindate, isborrowed ) values(‘ 5455515’ ,‘中华历史 5000 年’ ,‘ 1’ ,‘吴强’ ,‘北京大学出版社’ ,‘ 20200403’ ,‘ 20200515’ ,‘ 1’ )。 insert into system_books(。