《数据库应用与设计实验3》由会员分享，可在线阅读，更多相关《数据库应用与设计实验3（16页珍藏版）》请在金锄头文库上搜索。
1、实验实验 31 1、自行设计各个表自行设计各个表INSERT INTO 订货.仓库values (CA0001,那边风景好,100);INSERT INTO 订货.仓库values (CA0002,那边风景1,100);INSERT INTO 订货.仓库values (CA0003,那边风景2,100);INSERT INTO 订货.仓库values (CA0004,那边风景3,100);INSERT INTO 订货.仓库values (CA0005,那边风景4,100);INSERT INTO 订货.仓库values (CA0006,那边风景5,100);insert into 订货.职工(
2、仓库号,职工号,工资)values (CA0001,BA000001,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0001,BA000002,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0001,BA000003,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0001,BA000004,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0001,BA000005,1500);insert into 订货.职工(仓库号,职
3、工号,工资)values (CA0002,BA000006,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0002,BA000007,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0002,BA000008,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0003,BA000009,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0003,BA000010,1500);insert into 订货.职工(仓库号,职工号,工资
4、)values (CA0003,BA000011,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0004,BA00012,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0004,BA000013,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0004,BA000014,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0005,BA000015,1500);insert into 订货.职工(仓库号,职工号,工资)value
5、s (CA0005,BA000016,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0005,BA000017,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0006,BA00018,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0002,BA000019,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0004,BA000020,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0
6、005,BA000021,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0006,BA000022,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0006,BA000023,1500);insert into 订货.职工(仓库号,职工号,工资)values (CA0006,BA00024,1500)insert into 订货.供应商values (S001,小李,NULL);insert into 订货.供应商values (S002,小王,NULL);insert into 订货.供应商values (
7、S003,小张,NULL);insert into 订货.供应商values (S004,小李,NULL);insert into 订货.供应商values (S005,小王,NULL);insert into 订货.订购单values (BA000001,S001,OR0001,DEFAULT,NULL,null);insert into 订货.订购单values (BA000002,S001,OR0002,DEFAULT,NULL,null);insert into 订货.订购单values (BA000003,S001,OR0003,DEFAULT,NULL,null);insert i
8、nto 订货.订购单values (BA000004,S001,OR0004,DEFAULT,NULL,null);insert into 订货.订购单values (BA000005,S002,OR0005,DEFAULT,NULL,null);insert into 订货.订购单values (BA000006,S002,OR0006,DEFAULT,NULL,null);insert into 订货.订购单values (BA000007,S002,OR0007,DEFAULT,NULL,null);insert into 订货.订购单values (BA000008,S003,OR00
9、08,DEFAULT,NULL,null);insert into 订货.订购单values (BA000009,S003,OR0009,DEFAULT,NULL,null);insert into 订货.订购单values (BA000010,S003,OR0010,DEFAULT,NULl,null);insert into 订货.订购单values (BA000011,S004,OR0011,DEFAULT,NULL,null);insert into 订货.订购单values (BA000012,S004,OR0012,DEFAULT,NULl,null);insert into 订货
10、.订购单values (BA000013,S004,OR0013,DEFAULT,NULL,null);insert into 订货.订购单values (BA000014,S005,OR0014,DEFAULT,NULL,null);insert into 订货.订购单values (BA000015,S005,OR0015,DEFAULT,NULL,null);insert into 订货.订购单values (BA000016,S005,OR0016,DEFAULT,NULL,null);insert into 订货.订购单values (BA000017,S005,OR0017,DEF
11、AULT,NULL,null);insert into 订货.订购单values (BA000018,NULL,OR0018,DEFAULT,NULL,null);insert into 订货.订购单values (BA000019,NULL,OR0019,DEFAULT,NULL,null);insert into 订货.订购单values (BA000020,NULL,OR0020,DEFAULT,NULL,null);insert 订货.订购单明细values (OR0001,01,NULL,20,100);insert 订货.订购单明细values (OR0001,02,NULL,20
12、,100);insert 订货.订购单明细values (OR0001,03,NULL,20,100);insert 订货.订购单明细values (OR0002,04,NULL,20,100);insert 订货.订购单明细values (OR0002,05,NULL,20,100);insert 订货.订购单明细values (OR0002,06,NULL,20,100);insert 订货.订购单明细values (OR0002,07,NULL,20,100);insert 订货.订购单明细values (OR0003,08,NULL,20,100);INSERT 订货.订购单明细val
13、ues (OR0003,09,NULL,20,100);insert 订货.订购单明细values (OR0003,10,NULL,20,100);insert 订货.订购单明细values (OR0004,11,NULL,20,100);insert 订货.订购单明细values (OR0005,12,NULL,20,100);insert 订货.订购单明细values (OR0005,13,NULL,20,100);insert 订货.订购单明细values (OR0005,14,NULL,20,100);insert 订货.订购单明细values (OR0006,15,NULL,20,1
14、00);insert 订货.订购单明细values (OR0006,16,NULL,20,100);insert 订货.订购单明细values (OR0007,17,NULL,20,100);insert 订货.订购单明细values (OR0007,18,NULL,20,100);insert 订货.订购单明细values (OR0007,19,NULL,20,100);insert 订货.订购单明细values (OR0007,20,NULL,20,100);insert 订货.订购单明细values (OR0008,21,NULL,20,100);insert 订货.订购单明细values (OR0008,22,NULL,20,100);insert 订货.订购单明细values (OR0009,23,NULL,20,100);insert 订货.订购单明细values (OR0009,24,NULL,20,100);insert 订货.订购单明细values (OR0009,25,NULL,20,100);insert 订货.订购单明细values (OR0010,26,NULL,20,100);insert 订货.订购单明细values (OR0010,27,NULL,20,100);insert 订货.订购单
