数据库期末复习题带答案VIP免费

三个表：图书信息表、读者信息表、借阅表图书信息（书号、书名、作者、出版日期、出版社、图书存放位置、总数量）读者信息表（图书证号、姓名、所在系、借书上限数）借阅表（图书证号、书号、借出日期、应还日期）数据库表结构如下：BOOK(BNO, BN, BAU, BDA, BPU, BPL, BNU)READER(RNO, RN, RDE, RUP)BORROW(RNO, BNO, BDA, RDA)1、查询 “ S0701026 ”读者借了相同图书的读者的图书证号和姓名select rno,rn from reader where rno in(select a.rno from borrow as a,borrow as b where a.bno=b.bno and b.rno='S0701026') 2、查询每个读者的姓名和所借图书名select rn,bn from reader,borrow,book where reader.rno=borrow.rno and borrow.bno=book.bno 3、查没有借书的读者的图书证号和姓名select rno,rn from reader where rno not in(select rno from borrow) 4、查询借阅了 “数据结构 ”的读者数量select count(*) from borrow where bno=(select bno from book where bn='数据结构 ') group by bno 5、查“李丽 ”和“张朝阳 ”都借阅了的图书的书号select a.bno from borrow as a,borrow as b where a.rno=(select rno from reader where rn='李丽 ') and b.rno=(select rno from reader where rn=' 张朝阳 ') and a.bno=b.bno 6、查询借书上限最大的读者信息select * from reader where rup=(select max(rup) from reader) order by rup desc 7、查询借阅图书数量达到2本的读者信息select * from reader where rno in(select rno from borrow group by rno having count(*)>1) 8、查询每个读者姓名，所借图书的图书号，没有借书的读者也列出来select reader.rn,bno from reader left join borrow on reader.rno=borrow.rno 9、检索所有姓李的读者所借图书的书号select bno from borrow where rno in(select rno from reader where rn like '李 %') 10、查询借阅了 “数据库原理及其应用教程”的读者的图书证号和姓名select reader.rno,rn from reader,borrow,book where reader.rno=borrow.rno and borrow.bno=book.bno and bn=' 数据库原理及其应用教程' 11、统计各个系读者的数量，显示系名和数量select rde as系名 ,count(*) as 数量 from reader group...