CONNECT TO O3ZHUXS;
INSERT INTO BOOK
VALUES
('B0000001','今天' ,'黎明' ,'小说','大连出版社','20070712',3,'实在太好了'),
('B0000002','明天' ,'张学友','小说','大连出版社','20070212',5,'实在太好了'),
('B0000003','后天' ,'张满于','小说','大连出版社','20010112',6,'实在太好了'),
('B0000004','昨天' ,'李小民','小说','大连出版社','20070312',3,'实在太好了'),
('B0000005','前天' ,'马海' ,'小说','大连出版社','20070412',3,'实在太好了'),
('B0000006','大前天','王琴' ,'小说','大连出版社','20070512',7,'实在太好了'),
('B0000007','大后天','赵曼' ,'小说','大连出版社','20020712',3,'实在太好了'),
('B0000008','白天' ,'苏西' ,'小说','大连出版社','20070212',3,'实在太好了'),
('B0000009','黑天' ,'高倩' ,'小说','大连出版社','20070712',8,'实在太好了'),
('B0000010','阴天' ,'济济' ,'小说','大连出版社','20070412',3,'实在太好了');
INSERT INTO READER
VALUES
('R0000001','153245267865789034','黎明' ,'大连交大','学生','19670412','20070712'),
('R0000002','112345231245789844','张学友','大连交大','教师','19540302','20070212'),
('R0000003','153235234432439034','张满于','大连交大','学生','19441221','20010112'),
('R0000004','412345267865789677','李小民','大连理工','教师','19770412','20070312'),
('R0000005','123563367865789034','马海' ,'大连理工','教师','19850422','20070412'),
('R0000006','644353634765789076','王琴' ,'大连理工','教师','19410412','20070512'),
('R0000007','154367385895789977','赵曼' ,'大连理工','校长','19550116','20020712'),
('R0000008','197665757865789056','苏西' ,'大连海事','校长','19640112','20070212'),
('R0000009','156785677865789034','高倩' ,'大连海事','学生','19640212','20070712'),
('R0000010','186767876557890364','济济' ,'大连海事','校长','19670412','20070412');
INSERT INTO DEPT
VALUES
('R0000001',34),
('R0000002',43),
('R0000003',43),
('R0000004',34),
('R0000005',23),
('R0000006',12),
('R0000007',20),
('R0000008',43),
('R0000009',14),
('R0000010',53);
INSERT INTO BORROW
VALUES
('B0000001','R0000010','20080101'),
('B0000002','R0000009','20080221'),
('B0000003','R0000008','20080321'),
('B0000004','R0000007','20080511'),
('B0000005','R0000006','20080121'),
('B0000006','R0000005','20080411'),
('B0000007','R0000004','20080411'),
('B0000008','R0000003','20080101'),
('B0000009','R0000002','20080321'),
('B0000010','R0000001','20080211');
INSERT INTO DESTINE
VALUES
('B0000001','R0000010',1),
('B0000001','R0000009',2),
('B0000001','R0000008',3),
('B0000004','R0000007',1),
('B0000004','R0000006',2),
('B0000004','R0000005',3),
('B0000007','R0000004',1),
('B0000007','R0000003',2),
('B0000009','R0000002',1),
('B0000009','R0000001',2);
INSERT INTO NEWBOOK
VALUES
('B0000001','打紧' ,'20070712','20071212',3),
('B0000002','好事' ,'20070212','20071212',5),
('B0000003','开难道','20010112','20071212',6),
('B0000004','按时的','20070312','20071212',3),
('B0000005','额外人','20070412','20071212',3),
('B0000006','特务' ,'20070512','20071212',7),
('B0000007','期望' ,'20020712','20071212',3),
('B0000008','恢复' ,'20070212','20071212',3),
('B0000009','去按时','20070712','20071212',8),
('B0000010','全额外','20070412','20071212',3);
INSERT INTO SCRAPBOOK
VALUES
('B0001201','围绕器','20070712','20080731',3),
('B0010002','特问' ,'20070212','20080731',5),
('B0320003','反对' ,'20010112','20080731',6),
('B0014004','今天' ,'20070312','20080731',3),
('B0000005','地方' ,'20070412','20080731',3),
('B3200006','和发' ,'20070512','20080731',7),
('B0000007','是似的','20020712','20080731',3),
('B0012008','风格' ,'20070212','20080731',3),
('B0320009','恢复' ,'20070712','20080731',8),
('B0001110','期望' ,'20070412','20080731',3);
图书管理系统数据库设计
需积分: 6 120 浏览量
2008-10-01
18:46:43
上传
评论
收藏 793KB RAR 举报
.rar （12个子文件） 
课程设计 实施 
表.txt 2KB 表空间.txt 1KB
抓图.doc 118KB 值.txt 4KB 数据库课程设计说明书模版.doc 1.27MB ~$库课程设计任务书.doc 162B 图 
新建 Microsoft Visio 绘图 (3).vsd 61KB 新建 Microsoft Visio 绘图 (4).vsd 72KB 图书管理业务流程图.vsd 49KB 新建 Microsoft Visio 绘图.vsd 162KB 新建 Microsoft Visio 绘图 (2).vsd 70KB 新建 Microsoft Visio 绘图 (5).vsd 58KB资源评论
