中南大学数据库实验(二)

《中南大学数据库实验(二)》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

1、数据库原理与技术第二次试验课程名称：数据库原理与技术实验报告要求：1.列出所有的SQL语句和源代码；2.程序耍求有适当的注释；3.对数据完整性约束实施要求给岀相应的测试用例。4.实验报告提交电子档。实验内容：存储过程与触发器1.编写一段程序，将每种玩具的价格提高¥0.5,直到玩具的平均价格接近$24.5为止。此夕卜，任何玩具的最人价格不应超过$53。在执行语句前查询：select*fromToys结果如卜cToyldvToyNamevToyDescriptioncCategoryldmToyRatecBrandkiimPhotosiToyQohsiL

2、ow>1

3、000001RobbytheWhaleAgiantBlueWhalewithtwoheavy-dutyhandlest...0018.99001NULL50312000002WaterChanneiSystemChildrenenjoyplayingwithwaterTheWaterCha...00133.99001NULL605三3000003ParachuteandRocketSteponthelaunchpadandtherocketkslaunche...0016.99003NULL907口4000004SuperDeJugeCre

4、ateartificialrainfallinyourgardenwththissup...00135.99005NULL7485000005LightShowLampBuildarevolving.glowingmoodlampwthasetof.・・0021599001NULL5876000006GlassDecorationMakeyourownbeautiful.artwxkSetndudesei..・0021299004NULL9987000007TieDyeKtCHECKTHEORIGINALTOYLIST0021999002NULL76

5、78000008AbceinWondedandAhugecoloringbook0021499001NULL8249000009GlamorousDoiSheisreadyforheractingaudboninthisblueden...00218.99001NULL3961044000011SleepingBeautyDollr••c■Letyourchildenactthismagicalfarytalewiththe...A•eef11IIMtM«00218.99.rrr05NULL654▼J执行代码如下：createprocedu

6、reinprove_pri/★仓U建存彳诸过程*/asdeclare@averagemoney/*定义变［量*/select@average=AVG(mToyRate)fromToysbeginwhile@average<24/*为保证进行最后一次循环后的@averagev24・5*/beginupdateToyssetmToyRate=mToyRate+0•5wheremToyRate<53/*循环条件*/select@average=AVG(mToyRate)fromToysendendgoexecinprove_priselect*fromTo

7、ys运行结來：口结果一」消息cToyldvToyNamevToyDescriptioncCategoryldmToyRatecBrandklimPhotosiToyQohsiLow>1000001IRobbytheWhaleAgwtBlueWhalewithtwoheavy-dutyhandlest...00113.49001NULL503n2000002WaterCharmelSystemChidrenenjoyplayingwithwater.TheWaterCha...00138.49001NULL605m3000003Parachuteand

8、RocketSteponthelaunchpadandtherocketislaunche...00111.49003NULL907LJ4000004SuperDelugeCreateartificialrainfallinyourgardenwiththissup...00140.49005NULL7485000005LightShowLampBuidarevolving.glowingmoodlampwithasetof...00220.49001NULL5876000006GlassDecocabonMakeyourownbeautiful,a

9、rtwork.Setineludesei...00217.49004NULL9987000007TieDye