【正文】 values(@Bno,@Bname,@Bwriter,@Bconcern,@Bprice,@Bpt,@Bsort,@Bkeyword,@Bamount,@Bstate,@Bpno,@Bpname)（3）NewbookInsert的定義：create procedure NewbookInsert@Nbname char(40),@Nbwriter char(30),@Nbpt char(10)as insert into Newbookvalues(@Nbname,@Nbwriter,@Nbpt)（4）OldbookInsert的定義：create procedure OldbookInsert@Obname char(40),@Obno char(20)asinsert into Oldbookvalues(@Obname,@Obno)（5）AdministratorInsert的定義：create procedure AdministratorInsert@Ano char(10),@Aname char(10),@Asex char(2)as insert into Administratorvalues(@Ano,@Aname,@Asex)（6）LendInsert的定義：create procedure LendInsert@Lsno char(10),@Lsname char(10),@Lbno char(20),@Lbname char(20),@Lbtime datetime,@Lrtime datetime,@Lbnumber smallintasinsert into Lendvalues(@Lsno,@Lsname,@Lbno,@Lbname,@Lbtime,@Lrtime,@Lbnumber)update Bookset Bamount=Bamount@Lbnumberwhere Bno=@Lbno（7）StudentDelete的定義：create procedure StudentDelete@Sno char(10)asdeletefrom Lendwhere Lsno=@Snodeletefrom Studentwhere Sno=@Sno（8）BookDelete的定義：create procedure BookDelete@Bno char(20)as deletefrom Lendwhere Lbno=@Bnodeletefrom Bookwhere Bno=@Bno（9）NewbookDelete的定義：create procedure NewbookDelete@Nbname char(40),@Nbwriter char(30)asdeletefrom Newbookwhere Nbname=@Nbname and Nbwriter=@Nbwriter（10）OldbookDelete的定義：create procedure OldbookDelete@Bno char(20)as deletefrom Lendwhere Lbno=@Bnodeletefrom Bookwhere Bno=@Bnodeletefrom Oldbookwhere Obno=@Bno（11）AdministratorDelete的定義：create procedure AdministratorDelete@Ano char(10)asdeletefrom Administratorwhere Ano=@Ano（12）LendDelete的定義：create procedure LendDelete@Sno char(10),@Bno char(20)asdeclare @Lbnumber smallintselect @Lbnumber=Lbnumberfrom Lendwhere Lsno=@Sno and Lbno=@Bnoupdate Bookset Bamount=Bamount+@Lbnumberwhere Bno=@Bnodeletefrom Lendwhere Lsno=@Sno and Lbno=@Bno（13）LendUpdate的定義：create procedure LendUpdate@Sno char(10),@Bno char(20),@Lbnumber smallintasupdate Lendset Lbnumber=Lbnumber@Lbnumberwhere Lsno=@Sno and Lbno=@Bnoupdate Bookset Bamount=Bamount+@Lbnumberwhere Bno=@Bno（14）Renewal的定義：create procedure Renewal@Sno char(10),@Bno char(20),@Lbtime datetime,@Lrtime datetimeasupdate Lendset Lbtime=@Lbtime where Lsno=@Sno and Lbno=@Bnoupdate Lendset Lrtime=@Lrtimewhere Lsno=@Sno and Lbno=@Bno（15）QueryStudent的定義：create procedure QueryStudent@Sno char(10)asselect *from StudentViewwhere 學(xué)號(hào)=@Sno（16）QueryBook的定義：create procedure QueryBook@Bname char(40)asselect *from BookViewwhere 圖書名=@Bname(17) QueryLend的定義：create procedure QueryLend@Sno char(10)asselect *from LendViewwhere 學(xué)號(hào)=@Sno（18）QueryAdministator的定義：create procedure QueryAdministrator@Ano char(10)asselect *from AdministratorViewwhere 管理員編號(hào)=@Ano附錄2數(shù)據(jù)查看和存儲(chǔ)過程功能驗(yàn)證附圖211查看Newbook表基本信息（1）查看基本表信息附圖212查看Oldbook基本信息表（2）查看視圖附圖221查看StudentView附圖222查看BookView附圖223查看LendView附圖224查看AdministratorView（3）存儲(chǔ)過程功能驗(yàn)證附圖232驗(yàn)證BookInsert附圖231驗(yàn)證StudentInsert 附圖233驗(yàn)證NewbookInsert附圖234驗(yàn)證OldbookInsert附圖235驗(yàn)證AdministratorInsert附圖236驗(yàn)證LendInsert附圖237驗(yàn)證StudentDelete附圖238驗(yàn)證BookDelete附圖239驗(yàn)證NewbookDelete附圖2310驗(yàn)證OldbookDelete附圖2311驗(yàn)證AdministratorDelete附圖2312驗(yàn)證LendDelete 附圖2313驗(yàn)證LendUpdate附圖2314驗(yàn)證Renewal附圖2315驗(yàn)證QueryStudent附圖2316驗(yàn)證QueryBook附圖2317驗(yàn)證QuerylLend附圖2318驗(yàn)證QueryAdministrator附錄3所有的SQL語句create database xiaoyacreate table Student(Sno char(10) primary key,Sname char(10) not null,Ssex char(2) check(Ssex=39。女39。 or Ssex=39。男39。) not null,Sdpt char(10) not null,Smajor char(20) not null,Sclass char(10) not null,So char(10) unique,St datetime not null,)create table Book(Bno char(20) primary key,Bname char(40) not null,Bwriter char(30),Bconcer char(20),Bprice float not null,Bpt char(10),Bsort char(10),Bkeyword char(20),Bamount smallint check(Bamount =0) not null,Bstate char(10) not null,Bpno char(10) not null,Bpname char(10),)create table Newbook(Nbname char(40),Nbwriter char(30),Nbpt char(10),primary key (Nbname,Nbwriter),)create table Oldbook(Obname char(40),Obno char(20) primary key,foreign key (Obno) references Book(Bno),)create table Administrator(Ano char(10) primary key,Aname char(10) not null,Asex char(2) check(Asex=39。男39。 or Asex=39。女39。),)create table Lend(Lsno char(10),Lsname char(10),Lbno char(20),Lbname char(40),Lbtime datetime not null,Lrtime datetime not null,Lbnumber smallint check(Lbnumber=4 and Lbnumber0),primary key (Lsno,Lbno),foreign key (Lsno) references Student(Sno),foreign key (Lbno) references Book(Bno),)create view StudentView(學(xué)號(hào),姓名,學(xué)院,專業(yè),圖書證號(hào),辦證日期)asselect Sno,Sname,Sdpt,Smajor,So,Stfrom Studentcreate view BookView(圖書編號(hào),圖書名,作者,分類,可