CREATE TABLE BOOK (
BOOK_ID NUMBER(10) PRIMARY KEY,
SORT VARCHAR2(10),
BOOK_NAME VARCHAR2(50),
WRITER VARCHAR2(10),
OUTPUT VARCHAR2(50),
PRICE NUMBER(3)
);
CREATE TABLE READER (
READER_ID NUMBER(3) PRIMARY KEY,
COMPANY VARCHAR2(12),
NAME VARCHAR2(10),
SEX VARCHAR2(3),
GRADE VARCHAR2(10),
ADDR VARCHAR2(50));
CREATE TABLE BORROW (
READER_ID NUMBER(3),
BOOK_ID NUMBER(10),
BORROW_DATE DATE);
insert into book values(445501,'TP3/12','数据库导论','王强','科学出版社',17.90);
insert into book values(445502,'TP3/12','数据库导论','王强','科学出版社',17.90);
insert into book values(445503,'TP3/12','数据库导论','王强','科学出版社',17.90);
insert into book values(332211,'TP5/10','计算机基础','李伟','高等教育出版社',18.00);
insert into book values(112266,'TP3/12','FoxBASE','张三','电子工业出版社',23.60);
insert into book values(665544,'TS7/21','高等数学','刘明','高等教育出版社',20.00);
insert into book values(114455,'TR9/12','线性代数','孙业','北京大学出版社',20.80);
insert into book values(113388,'TR7/90','大学英语','胡玲','清华大学出版社',12.50);
insert into book values(446601,'TP4/13','数据库基础','马凌云','人民邮电出版社',22.50);
insert into book values(446602,'TP4/13','数据库基础','马凌云','人民邮电出版社',22.50);
insert into book values(446603,'TP4/13','数据库基础','马凌云','人民邮电出版社',22.50);
insert into book values(449901,'TP4/14','FoxPro大全','周虹','科学出版社',32.70);
insert into book values(449902,'TP4/14','FoxPro大全','周虹','科学出版社',32.70);
insert into book values(118801,'TP4/15','计算机网络','黄力钧','高等教育出版社',21.80);
insert into book values(118802,'TP4/15','计算机网络','黄力钧','高等教育出版社',21.80);
insert into reader values(111,'信息系','王维利','女','教授','1号楼424');
insert into reader values(112,'财会系','李 立','男','副教授','2号楼316');
insert into reader values(113,'经济系','张 三','男','讲师','3号楼105');
insert into reader values(114,'信息系','周华发','男','讲师','1号楼316');
insert into reader values(115,'信息系','赵正义','男','工程师','1号楼224');
insert into reader values(116,'信息系','李 明','男','副教授','1号楼318');
insert into reader values(117,'计算机系','李小峰','男','助教','1号楼214');
insert into reader values(118,'计算机系','许鹏飞','男','助工','1号楼216');
insert into reader values(119,'计算机系','刘大龙','男','教授','1号楼318');
insert into reader values(120,'国际贸易','李 雪','男','副教授','4号楼506');
insert into reader values(121,'国际贸易','李 爽','女','讲师','4号楼510');
insert into reader values(122,'国际贸易','王 纯','女','讲师','4号楼512');
insert into reader values(123,'财会系','沈小霞','女','助教','2号楼202');
insert into reader values(124,'财会系','朱 海','男','讲师','2号楼210');
insert into reader values(125,'财会系','马英明','男','副教授','2号楼212');
insert into borrow values(112,445501,to_date('19-03-2006', 'dd-mm-yyyy'));
insert into borrow values(125,332211,to_date('12-2-2006', 'dd-mm-yyyy'));
insert into borrow values(111,445503,to_date('21-8-2006', 'dd-mm-yyyy'));
insert into borrow values(112,112266,to_date('14-3-2006', 'dd-mm-yyyy'));
insert into borrow values(114,665544,to_date('21-10-2006', 'dd-mm-yyyy'));
insert into borrow values(120,114455,to_date('02-11-2006', 'dd-mm-yyyy'));
insert into borrow values(120,118801,to_date('18-10-2006', 'dd-mm-yyyy'));
insert into borrow values(119,446603,to_date('12-11-2006', 'dd-mm-yyyy'));
insert into borrow values(112,449901,to_date('23-10-2006', 'dd-mm-yyyy'));
insert into borrow values(115,449902,to_date('21-8-2006', 'dd-mm-yyyy'));
insert into borrow values(118,118801,to_date('10-9-2006', 'dd-mm-yyyy'));
