文档介绍:实验报告
课程名称 数据库原理实验
实验名称 数据更新
实验类型 综合型
实验地点304机房实验日期2010-11-02
指导教师 竺
专 业
班 级
学 号
姓 名
成 绩
辽宁石油化工大学计算机与通联合利华;
M04,舒肤佳,,香皂,宝洁;
M05,夏士莲,,香皂,联合利华;
M06,雕牌,,洗衣粉,纳爱斯
M07,中华,,牙膏,联合利华;
M08,汰渍,,洗衣粉,宝洁;
M09,碧浪,,洗衣粉,宝洁;)
insert into
insert into
insert into
insert into
insert into
insert into
insert into
insert into
insert into
Goods values
Goods values
Goods values
Goods values
Goods values
Goods values
Goods values
Goods values
Goods values
I'M板丁
J - - . . ・ n- n- 5 n- n- 2 3 3 4 士吉,佳度::; 洁露诺肤士牌华渍浪 佳高洁舒夏雕中汰碧
WW,莺皂粉,稔粉 牙牙膏香香衣W液衣 ,,,,牙,,,,洗牙洗洗 ----? - - - - ? 7 7 7 O 5 J _u O J , ■口 ・・ o o o O S 6 O 3 5 5 5 o O
,)洁华?)利斯华,),) 洁露利洁含爱利洁洁 宝高台宝联纳台宝宝 ? ?-联■,,•■.-联? ? J 1-1 J J 1-1 J J
顾客
(
C01, Dennis,海淀;
C02,John,朝阳;
C03,Tom,东城;
C04,Jenny,东城;
C05,Rick,西城;
)
ntntntntnt
o Cust omer values (? CO T 3 ? Dennis, 3 , )
o Cust omer values (? C02,, ? Johri? '朝阳’) o Cust omer values (? C03,, ? Tom,, , )
o Cust omer values (? C04?, ? Jenny? j , )
o Cust omer valuEM ('CDS'Rick'西城’)
购买(
C01,
M01,
3;
C01,
M05,2;
C01,
M08,
2;
C02,
M02,
5;
C02,
M06,
4;
C03,
M01,
1;
C03,
M05,
1;
C03,
M06,
3;
C03,
M08,
1;
C04,
M03,
7;
C04,
M04,
3;
C05,
M06,
2;
C05, M07, 8;
注:商品表数据(9),顾客表数据(5),购买表数据(5)
insert insert insert insert insert insert insert insert insert insert insert insert insert
into Buy values MO 1? ? COT ? )
into Buy values , 2,)
into Buy values (?M08\ ? 2,)
into Buy values (? M02, j ? C02, j ? 5,) into Buy values (? M06, j ? C02, 3 ? 4,) into Buy values (' MD1', ' CD3' 丁 1') into Buy values (? M05, ? C03,, ? 1,) into Buy values (? M06, ? C03?,, 3,)
into Buy values (? M08, ? C03,,? 1,) into Buy values (? M03, ? C04,,? 7,)
into Buy values (? M04, ? C04, ? 3,)
into Buy values (? M06, ? C05, ? 2,)
into Buy values (? M07, , C05, , 8,)
:
select * from Customer where
C_Id in(selet:t distinct C_Id from Buy where
G_Id in(select G_Id from Goods where G_Provider :