数据库原理实验一、实验1 认识DBMS二、实验2 简单SQL查询三、实验3 高级SQL查询四、实验4 数据的更新weixin_52948586ZIP数据库实验.zip 22.54MB 立即下载资源文件列表:ZIP 数据库实验.zip 大约有7个文件 SQLQuery1.sql 28B SQLQuery2.sql 30B SQLQuery3.sql 66B 课设.docx 14.44KB 实验5.pkt 68.43KB 数据库实验.doc 23.68MB 数据库原理A实验指导书(学生用).pdf 388.88KB 资源介绍: 一、实验1 认识DBMS 二、实验2 简单SQL查询 三、实验3 高级SQL查询 四、实验4 数据的更新 五、实验总结 <link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/base.min.css" rel="stylesheet"/><link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css" rel="stylesheet"/><link href="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89544020/raw.css" rel="stylesheet"/><div id="sidebar" style="display: none"><div id="outline"></div></div><div class="pf w0 h0" data-page-no="1" id="pf1"><div class="pc pc1 w0 h0"><img alt="" class="bi x0 y0 w1 h1" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89544020/bg1.jpg"/><div class="c x0 y1 w2 h0"><div class="t m0 x1 h2 y2 ff1 fs0 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y3 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y4 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y5 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x3 h4 y6 ff3 fs2 fc0 sc0 ls0 ws0">数据库原理<span class="ff2">A </span></div><div class="t m0 x2 h3 y7 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y8 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y9 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x4 h5 ya ff3 fs3 fc0 sc0 ls0 ws0">实验指导书<span class="ff2"> </span></div><div class="t m0 x5 h6 yb ff3 fs4 fc0 sc0 ls0 ws0">(学生用书)<span class="ff2"> </span></div><div class="t m0 x2 h3 yc ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 yd ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x6 h6 ye ff3 fs4 fc0 sc0 ls0 ws0">适用专业<span class="ff2"> </span></div><div class="t m0 x3 h6 yf ff3 fs4 fc0 sc0 ls0 ws0">(计算机类各专业)<span class="ff2"> </span></div><div class="t m0 x2 h3 y10 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y11 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y12 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y13 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y14 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y15 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y16 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y17 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y18 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y19 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y1a ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y1b ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y1c ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x2 h3 y1d ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 x7 h6 y1e ff3 fs4 fc0 sc0 ls0 ws0">南华大学计算机学院软件工<span class="_ _0"></span>程系<span class="ff2"> </span></div><div class="t m0 x2 h6 y1f ff2 fs4 fc0 sc0 ls0 ws0"> </div><div class="t m0 x8 h6 y20 ff2 fs4 fc0 sc0 ls1 ws0">20<span class="ls2">21<span class="ff3 ls0">年<span class="ff2">2</span>月<span class="ff2 fs1"> </span></span></span></div></div></div><div class="pi" data-data='{"ctm":[1.568627,0.000000,0.000000,1.568627,0.000000,0.000000]}'></div></div><div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89544020/bg2.jpg"><div class="c x0 y1 w2 h0"><div class="t m0 x1 h2 y2 ff1 fs0 fc0 sc0 ls0 ws0"> </div><div class="t m0 x9 h4 y21 ff3 fs2 fc0 sc0 ls0 ws0">目<span class="ff2 ls3"> </span>录<span class="ff2"> </span></div><div class="t m0 x2 h3 y22 ff2 fs1 fc0 sc0 ls0 ws0"> </div><div class="t m0 xa h7 y23 ff1 fs5 fc0 sc0 ls0 ws0"> </div><div class="t m0 xa h8 y24 ff4 fs1 fc0 sc0 ls0 ws0">实验<span class="_ _1"> </span><span class="ff5 ls1">1 </span><span class="ls4">认识<span class="_ _1"> </span><span class="ff5 ls1">DBMS<span class="ls0"> <span class="_ _2"></span><span class="ls1">..........................................<span class="ls0"> <span class="_ _3"></span>1 </span></span></span></span></span></div><div class="t m0 xa h8 y25 ff4 fs1 fc0 sc0 ls0 ws0">实验<span class="_ _1"> </span><span class="ff5">2 </span><span class="ls4">简单<span class="_ _1"> </span><span class="ff5 ls1">SQL<span class="_ _1"> </span></span></span>查询<span class="ff5"> <span class="_ _4"></span><span class="ls1">......................................<span class="ls0"> <span class="_ _3"></span>6 </span></span></span></div><div class="t m0 xa h8 y26 ff4 fs1 fc0 sc0 ls0 ws0">实验<span class="_ _1"> </span><span class="ff5">3 </span><span class="ls4">高级<span class="_ _1"> </span><span class="ff5 ls1">SQL<span class="_ _1"> </span></span></span>查询<span class="ff5"> <span class="_ _4"></span><span class="ls1">......................................<span class="ls0"> <span class="_ _3"></span>8 </span></span></span></div><div class="t m0 xa h8 y27 ff4 fs1 fc0 sc0 ls0 ws0">实验<span class="_ _1"> </span><span class="ff5">4 </span>数据的更新<span class="ff5"> <span class="_ _4"></span><span class="ls1">........................................<span class="ls0"> <span class="_ _3"></span>9<span class="ff1 fs5"> </span></span></span></span></div><div class="t m0 x1 h3 y28 ff2 fs1 fc0 sc0 ls0 ws0"> </div></div><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a><a class="l"><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.568627,0.000000,0.000000,1.568627,0.000000,0.000000]}'></div></div><div id="pf3" class="pf w3 h9" data-page-no="3"><div class="pc pc3 w3 h9"><img class="bi x0 y0 w4 ha" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89544020/bg3.jpg"><div class="c x0 y1 w5 h9"><div class="t m0 x1 h2 y29 ff1 fs0 fc0 sc0 ls0 ws0"> </div></div><div class="c xb y2a w6 hb"><div class="t m0 x0 h2 y2b ff1 fs0 fc0 sc0 ls0 ws0"> </div></div><div class="c xc y2a w7 hb"><div class="t m0 x0 h2 y2b ff6 fs0 fc0 sc0 ls0 ws0">1<span class="ff1"><span class="fc2 sc0"> </span></span></div></div><div class="c x0 y1 w5 h9"><div class="t m0 x1 hc y2c ff3 fs4 fc0 sc1 ls4 ws0">实验<span class="_ _5"> </span><span class="ff7 sc0 ls0">1 <span class="_ _1"> </span></span>认识<span class="_ _5"> </span><span class="ff7 sc0 ls0">DBMS </span></div><div class="t m0 x1 h3 y2d ff3 fs1 fc0 sc0 ls0 ws0">一、利用管理工具创建数据库、表和表间关系<span class="_ _6"></span><span class="ff2"> </span></div><div class="t m0 x1 h3 y2e ff3 fs1 fc0 sc0 ls0 ws0">实验目的和注意事项<span class="ff2"> </span></div><div class="t m0 xd hd y2f ff4 fs6 fc0 sc0 ls0 ws0">实验目的:熟悉<span class="ff1">SQL Server Management Studio <span class="_"> </span></span>的基本操作,进一步理解数</div><div class="t m0 x1 he y30 ff4 fs6 fc0 sc0 ls0 ws0">据库、表、表间关系的概念。<span class="ff2"> </span></div><div class="t m0 xd he y31 ff4 fs6 fc0 sc0 ls0 ws0">注意事项:创建数据库和数据表时应认真,如果出现错误,应相应地修改</div><div class="t m0 x1 he y32 ff4 fs6 fc0 sc0 ls0 ws0">结构或删除。<span class="ff5"> </span></div><div class="t m0 x1 h3 y33 ff3 fs1 fc0 sc0 ls0 ws0">实验内容<span class="ff2"> </span></div><div class="t m0 xd hd y34 ff1 fs6 fc0 sc0 ls0 ws0">(1) <span class="_"> </span><span class="ff4">利用</span>SQL Server Management Studio <span class="_"> </span><span class="ff4">创建数据库,名称为【学生选课</span></div><div class="t m0 x1 he y35 ff5 fs6 fc0 sc0 ls0 ws0">YYXXXX<span class="ff4">】。其中,</span>YY<span class="ff4">为入学年份的后两位,</span>XXXX<span class="ff4">为学生自己学号的后</span>4<span class="ff4">位(下</span></div><div class="t m0 x1 he y36 ff4 fs6 fc0 sc0 ls0 ws0">同)。<span class="fc1 sc2">例如,某学生<span class="_ _6"></span>学号为<span class="ff5">20<span class="_ _6"></span>200441234<span class="_ _6"></span></span>,则他创建的<span class="_ _6"></span>数据库名称为“<span class="_ _6"></span><span class="ls4">学生选</span></span></div><div class="t m0 x1 he y37 ff4 fs6 fc1 sc2 ls0 ws0">课<span class="ff5 ls4">20<span class="ls0">1234</span></span>”。<span class="_ _6"></span>注意,如果未按<span class="_ _6"></span>要求命名数据库和表<span class="_ _6"></span>,实验成绩评定为“<span class="_ _6"></span>不及</div><div class="t m0 x1 he y38 ff4 fs6 fc1 sc2 ls4 ws0">格”。<span class="ff5 ls0"> </span></div><div class="t m0 xd hd y39 ff1 fs6 fc0 sc0 ls0 ws0">(2) <span class="_"> </span><span class="ff4">在【学生选课<span class="ff5">YYXXXX</span>】中建立数据表,表的定义如下所示。<span class="ff5"> </span></span></div><div class="t m0 x1 hd y3a ff4 fs6 fc0 sc0 ls0 ws0">学生<span class="ff5">YYXXXX<span class="ff1">(</span></span>学号,姓名,性别,出生日期,院系名称,备注<span class="ff1">)</span>;<span class="ff5"> </span></div><div class="t m0 x1 hd y3b ff4 fs6 fc0 sc0 ls0 ws0">课程<span class="ff5">YYXXXX<span class="ff1">(</span></span>课程号,课程名,先行课,学分<span class="ff1">)</span>;<span class="ff5"> </span></div><div class="t m0 x1 hd y3c ff4 fs6 fc0 sc0 ls0 ws0">选修<span class="ff5">YYXXXX<span class="ff1">(</span></span>学号,课程号,分数<span class="ff1">)</span>。<span class="ff5"> </span></div><div class="t m0 xd he y3d ff4 fs6 fc0 sc0 ls0 ws0">要求定义每张表的主码,为属性选择合适的数据类型,决定是否允许为</div><div class="t m0 x1 he y3e ff4 fs6 fc0 sc0 ls0 ws0">空,为【性别】和【学分】属性定义默认值。<span class="ff5"> </span></div><div class="t m0 xd hd y3f ff1 fs6 fc0 sc0 ls0 ws0">(3) <span class="_"> </span><span class="ff4">定义表之间的关系。<span class="ff5"> </span></span></div><div class="t m0 xd hd y40 ff1 fs6 fc0 sc0 ls0 ws0">(4) <span class="_"> </span><span class="ff4">分别为表录入几行数据记录,同时练习数据的修改和删除操作。<span class="ff5"> </span></span></div><div class="t m0 x1 h3 y41 ff3 fs1 fc0 sc0 ls0 ws0">实验步骤<span class="ff2"> </span></div><div class="t m0 xd hd y42 ff1 fs6 fc0 sc0 ls0 ws0">(1) <span class="_"> </span><span class="ff4">启动</span>SQL Server Management Studio<span class="ff4">,连接数据库服务器,进入</span>SQL </div><div class="t m0 x1 hd y43 ff1 fs6 fc0 sc0 ls0 ws0">Server </div><div class="t m0 x1 hd y44 ff1 fs6 fc0 sc0 ls0 ws0">Management Studio <span class="_"> </span><span class="ff4">主界面。<span class="ff5"> </span></span></div><div class="t m0 xd hd y45 ff5 fs6 fc0 sc0 ls0 ws0">(2)<span class="ff8"> <span class="ff4">右击【对象资源管理器】<span class="ff1">|</span>【数据库】,选择快捷菜单中的【新建数据</span></span></div><div class="t m0 x1 hd y46 ff4 fs6 fc0 sc0 ls0 ws0">库】命令,弹出【新建数据库】窗口<span class="ff1">,</span>在各属性页中设置新建数据库的属性,包</div><div class="t m0 x1 he y47 ff4 fs6 fc0 sc0 ls0 ws0">括设置数据库逻辑名、所有者、文件的逻辑名、文件的物理名、文件类型、文</div><div class="t m0 x1 hd y48 ff4 fs6 fc0 sc0 ls0 ws0">件增长方式、文件的路径、文件组等属性,如图<span class="ff1">1.1 <span class="_"> </span></span>所示。<span class="ff5"> </span></div></div></div><div class="pi" data-data='{"ctm":[1.568627,0.000000,0.000000,1.568627,0.000000,0.000000]}'></div></div><div id="pf4" class="pf w3 h9" data-page-no="4"><div class="pc pc4 w3 h9"><img class="bi x0 y0 w4 ha" alt="" src="/image.php?url=https://csdnimg.cn/release/download_crawler_static/89544020/bg4.jpg"><div class="c x0 y1 w5 h9"><div class="t m0 x1 h2 y29 ff1 fs0 fc0 sc0 ls0 ws0"> </div></div><div class="c xb y2a w6 hb"><div class="t m0 x0 h2 y2b ff1 fs0 fc0 sc0 ls0 ws0"> </div></div><div class="c xc y2a w7 hb"><div class="t m0 x0 h2 y2b ff6 fs0 fc0 sc0 ls0 ws0">2<span class="ff1"><span class="fc2 sc0"> </span></span></div></div><div class="c x0 y1 w5 h9"><div class="t m0 xe h7 y49 ff1 fs5 fc0 sc0 ls0 ws0"> </div><div class="t m0 xf hf y4a ff3 fs0 fc0 sc0 ls0 ws0">图<span class="ff8">1.1 <span class="_ _7"> </span></span>新建数据库<span class="ff2"> </span></div><div class="t m0 xd hd y4b ff1 fs6 fc0 sc0 ls0 ws0">(3) <span class="_"> </span><span class="ff4">保存新建的数据库,该数据库的逻辑名为【学生选课<span class="ff5">XXXX</span>】。<span class="ff5"> </span></span></div><div class="t m0 xd hd y4c ff1 fs6 fc0 sc0 ls0 ws0">(4) <span class="_"> </span><span class="ff4">在【对象资源管理器】中,右击【学生选课<span class="ff5">XXXX</span>】</span>|<span class="ff4">【表】,选择快捷</span></div><div class="t m0 x1 hd y4d ff4 fs6 fc0 sc0 ls0 ws0">菜单中的【新建表】命令,弹出表设计器对话框,新建“学生、课程、选修”<span class="ff1">3 </span></div><div class="t m0 x1 hd y4e ff4 fs6 fc0 sc0 ls0 ws0">个表,如图<span class="ff1">1.2 <span class="_"> </span></span>所示。<span class="ff2"> </span></div><div class="t m0 x10 h7 y4f ff1 fs5 fc0 sc0 ls0 ws0"> </div><div class="t m0 x11 hf y50 ff3 fs0 fc0 sc0 ls0 ws0">图<span class="ff8 ls5">1.2 <span class="_ _7"> </span></span>新建表<span class="ff2"> </span></div><div class="t m0 xd hd y51 ff1 fs6 fc0 sc0 ls0 ws0">(5) <span class="_"> </span><span class="ff4">通过设计关系图,设置数据库的数据完整性。在【对象资源管理器】</span></div><div class="t m0 x1 hd y52 ff4 fs6 fc0 sc0 ls0 ws0">中,右击【学生选课】<span class="ff1">|</span>【数据库关系图】,选择快捷菜单中的【新建数据库关</div><div class="t m0 x1 hd y53 ff4 fs6 fc0 sc0 ls0 ws0">系图】命令,弹出【添加表】对话框。将这<span class="ff1">3 <span class="_"> </span></span>个表添加到关系图设计器中,设</div><div class="t m0 x1 hd y54 ff4 fs6 fc0 sc0 ls0 ws0">置数据完整性,如图<span class="ff1">1.3 <span class="_"> </span></span>所示。<span class="ff2"> </span></div><div class="t m0 x12 h7 y55 ff1 fs5 fc0 sc0 ls0 ws0"> </div><div class="t m0 xf hf y56 ff3 fs0 fc0 sc0 ls0 ws0">图<span class="ff8">1.3 <span class="_ _7"> </span></span>新建关系图<span class="ff2"> </span></div><div class="t m0 xd hd y57 ff1 fs6 fc0 sc0 ls0 ws0">(6) <span class="_"> </span><span class="ff4">右击要操作的表,选择快捷菜单中的【打开表】命令,弹出表数据窗</span></div><div class="t m0 x1 he y58 ff4 fs6 fc0 sc0 ls0 ws0">口。直接在表数据窗口中对表数据进行操作,包括插入、删除、修改记录,如</div><div class="t m0 x1 hd y59 ff4 fs6 fc0 sc0 ls0 ws0">图<span class="ff1">1.4 <span class="_"> </span></span>所示。<span class="ff2"> </span></div></div></div><div class="pi" data-data='{"ctm":[1.568627,0.000000,0.000000,1.568627,0.000000,0.000000]}'></div></div>