📄 《数据库实验及课程设计》实验指导书.mht
字号:
pan
lang=3DEN-US><o:p></o:p></span></span></p>
</td>
<td width=3D288 valign=3Dtop style=3D'width:216.0pt;border-top:none;borde=
r-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1=
.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid window=
text .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal style=3D'mso-line-height-alt:0pt'><span style=3D'mso=
-bidi-font-size:
10.5pt;font-family:SimSun;color:black'>熟悉<span lang=3DEN-US=
>MDI</span>应用的建立和编程=
<span
lang=3DEN-US><o:p></o:p></span></span></p>
</td>
<td width=3D48 rowspan=3D2 style=3D'width:36.0pt;border-top:none;border-l=
eft:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid window=
text .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center;mso-line-h=
eight-alt:
0pt'><span lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:Si=
mSun;
color:black'>4<o:p></o:p></span></p>
</td>
</tr>
<tr style=3D'mso-yfti-irow:5'>
<td width=3D216 valign=3Dtop style=3D'width:162.0pt;border-top:none;borde=
r-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1=
.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid window=
text .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal style=3D'mso-line-height-alt:0pt'><span style=3D'mso=
-bidi-font-size:
10.5pt;font-family:SimSun'>运用数据窗ࡣ=
5;实现数据处理<span
lang=3DEN-US style=3D'color:black'><o:p></o:p></span></span></p>
</td>
<td width=3D288 valign=3Dtop style=3D'width:216.0pt;border-top:none;borde=
r-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1=
.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid window=
text .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal style=3D'mso-line-height-alt:0pt'><span style=3D'mso=
-bidi-font-size:
10.5pt;font-family:SimSun;color:black'>熟练建立&#=
25968;据窗口对象及控件<span
lang=3DEN-US><o:p></o:p></span></span></p>
</td>
</tr>
<tr style=3D'mso-yfti-irow:6'>
<td width=3D48 style=3D'width:36.0pt;border:solid windowtext 1.0pt;border=
-top:
none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid window=
text .5pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center;mso-line-h=
eight-alt:
0pt'><span lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:Si=
mSun;
color:black'>5<o:p></o:p></span></p>
</td>
<td width=3D216 valign=3Dtop style=3D'width:162.0pt;border-top:none;borde=
r-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1=
.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid window=
text .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal style=3D'mso-line-height-alt:0pt'><span style=3D'mso=
-bidi-font-size:
10.5pt;font-family:SimSun'>运用数据窗ࡣ=
5;实现条件查询和数据&=
#26356;新<span
lang=3DEN-US style=3D'color:black'><o:p></o:p></span></span></p>
</td>
<td width=3D288 valign=3Dtop style=3D'width:216.0pt;border-top:none;borde=
r-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1=
.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid window=
text .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal style=3D'mso-line-height-alt:0pt'><span style=3D'mso=
-bidi-font-size:
10.5pt;font-family:SimSun;color:black'>掌握数据&#=
31383;口的条件检索和数þ=
54;更新。<span
lang=3DEN-US><o:p></o:p></span></span></p>
</td>
<td width=3D48 style=3D'width:36.0pt;border-top:none;border-left:none;bor=
der-bottom:
solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;mso-border-top=
-alt:
solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;mso-borde=
r-alt:
solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center;mso-line-h=
eight-alt:
0pt'><span lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:Si=
mSun;
color:black'>4<o:p></o:p></span></p>
</td>
</tr>
<tr style=3D'mso-yfti-irow:7;mso-yfti-lastrow:yes'>
<td width=3D48 valign=3Dtop style=3D'width:36.0pt;border:solid windowtext=
1.0pt;
border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:s=
olid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center;mso-line-h=
eight-alt:
0pt'><span lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:Si=
mSun;
color:black'>6<o:p></o:p></span></p>
</td>
<td width=3D216 valign=3Dtop style=3D'width:162.0pt;border-top:none;borde=
r-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1=
.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid window=
text .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal style=3D'mso-line-height-alt:0pt'><span style=3D'mso=
-bidi-font-size:
10.5pt;font-family:SimSun;color:black'>综合设计<s=
pan
lang=3DEN-US><o:p></o:p></span></span></p>
</td>
<td width=3D288 valign=3Dtop style=3D'width:216.0pt;border-top:none;borde=
r-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1=
.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid window=
text .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal style=3D'mso-line-height-alt:0pt'><span style=3D'mso=
-bidi-font-size:
10.5pt;font-family:SimSun;color:black'>基本掌握&#=
25968;据库应用程序的开Ö=
57;方法<span
lang=3DEN-US><o:p></o:p></span></span></p>
</td>
<td width=3D48 valign=3Dtop style=3D'width:36.0pt;border-top:none;border-=
left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid window=
text .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt'>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center;mso-line-h=
eight-alt:
0pt'><span lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:Si=
mSun;
color:black'>20<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><b style=3D=
'mso-bidi-font-weight:
normal'><span lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:S=
imSun'><o:p> </o:p></span></b></p>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><b style=3D=
'mso-bidi-font-weight:
normal'><span lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:S=
imSun'><o:p> </o:p></span></b></p>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><b style=3D=
'mso-bidi-font-weight:
normal'><span lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:S=
imSun'><o:p> </o:p></span></b></p>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><b style=3D=
'mso-bidi-font-weight:
normal'><span lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:S=
imSun'><o:p> </o:p></span></b></p>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><b style=3D=
'mso-bidi-font-weight:
normal'><span style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>౑=
2;一部分
基础实验<span lang=3DEN-US><o:p></o:p></span></span=
></b></p>
<p class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><b style=3D=
'mso-bidi-font-weight:
normal'><span lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:S=
imSun'><o:p> </o:p></span></b></p>
<p class=3DMsoNormalIndent align=3Dcenter style=3D'text-align:center;text-i=
ndent:
0cm'><b style=3D'mso-bidi-font-weight:normal'><span style=3D'mso-bidi-font-=
size:
10.5pt;font-family:SimSun'>实验<span lang=3DEN-US>1 </span>=
289;教学管理数据库结构=
;设计<span
lang=3DEN-US><o:p></o:p></span></span></b></p>
<p class=3DMsoNormalIndent align=3Dcenter style=3D'text-align:center;text-i=
ndent:
0cm'><b style=3D'mso-bidi-font-weight:normal'><span lang=3DEN-US style=3D'm=
so-bidi-font-size:
10.5pt;font-family:SimSun'><o:p> </o:p></span></b></p>
<p class=3DMsoNormalIndent style=3D'text-indent:0cm'><b><span style=3D'mso-=
bidi-font-size:
10.5pt;font-family:SimSun'>一、实验目的=
<span
lang=3DEN-US><o:p></o:p></span></span></b></p>
<p class=3DMsoNormalIndent><span lang=3DEN-US style=3D'mso-bidi-font-size:1=
0.5pt;
font-family:SimSun'>1</span><span style=3D'mso-bidi-font-size:10.5pt;font-f=
amily:
SimSun'>、学习<span lang=3DEN-US>SQL<span
style=3D'mso-spacerun:yes'> </span>Server </span>数据=
211;管理系统的体系结构=
;。<span
lang=3DEN-US><o:p></o:p></span></span></p>
<p class=3DMsoNormalIndent><span lang=3DEN-US style=3D'mso-bidi-font-size:1=
0.5pt;
font-family:SimSun'>2</span><span style=3D'mso-bidi-font-size:10.5pt;font-f=
amily:
SimSun'>、能够利用<span lang=3DEN-US>SQL Serv=
er</span>工具创建和维护数&#=
25454;库。<span
lang=3DEN-US><o:p></o:p></span></span></p>
<p class=3DMsoNormalIndent><span lang=3DEN-US style=3D'mso-bidi-font-size:1=
0.5pt;
font-family:SimSun'>3</span><span style=3D'mso-bidi-font-size:10.5pt;font-f=
amily:
SimSun'>、理解关系数据库=
0340;基本概念。<span
lang=3DEN-US><o:p></o:p></span></span></p>
<p class=3DMsoNormalIndent><span lang=3DEN-US style=3D'mso-bidi-font-size:1=
0.5pt;
font-family:SimSun'>4</span><span style=3D'mso-bidi-font-size:10.5pt;font-f=
amily:
SimSun'>、掌握数据库结构=
5774;计方法。<span
lang=3DEN-US><o:p></o:p></span></span></p>
<p class=3DMsoNormalIndent style=3D'text-indent:0cm'><b><span style=3D'mso-=
bidi-font-size:
10.5pt;font-family:SimSun'>二、考察知识=
点<span
lang=3DEN-US><o:p></o:p></span></span></b></p>
<p class=3DMsoNormalIndent style=3D'text-indent:24.0pt'><span style=3D'mso-=
bidi-font-size:
10.5pt;font-family:SimSun'>关系数据库的=
基础知识（《数据库=
1995;统概论》第二章）<span
lang=3DEN-US><o:p></o:p></span></span></p>
<p class=3DMsoNormalIndent style=3D'text-indent:24.0pt'><span lang=3DEN-US
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>1</span><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>、关=
995;<span
lang=3DEN-US>--</span>表<span lang=3DEN-US><o:p></o:p></span></span><=
/p>
<p class=3DMsoNormalIndent style=3D'text-indent:24.0pt'><span lang=3DEN-US
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>2</span><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>、主=
721;（主键），外码（外=
;键）<span
lang=3DEN-US><o:p></o:p></span></span></p>
<p class=3DMsoNormalIndent style=3D'text-indent:24.0pt'><span lang=3DEN-US
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>3</span><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>、关=
995;的完整性<span
lang=3DEN-US><o:p></o:p></span></span></p>
<p class=3DMsoNormalIndent style=3D'margin-left:60.0pt;text-indent:-36.0pt;
mso-list:l9 level1 lfo4;tab-stops:list 60.0pt'><![if !supportLists]><span
lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun;mso-bidi=
-font-family:
SimSun'><span style=3D'mso-list:Ignore'>（1）<span style=3D'fon=
t:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style=3D'mso-bidi-font-size:10.5pt;
font-family:SimSun'>实体完整性（主=
;码）<span
lang=3DEN-US><o:p></o:p></span></span></p>
<p class=3DMsoNormalIndent style=3D'margin-left:60.0pt;text-indent:-36.0pt;
mso-list:l9 level1 lfo4;tab-stops:list 60.0pt'><![if !supportLists]><span
lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun;mso-bidi=
-font-family:
SimSun'><span style=3D'mso-list:Ignore'>（2）<span style=3D'fon=
t:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style=3D'mso-bidi-font-size:10.5pt;
font-family:SimSun'>参照完整性 （ࣨ=
6;码）<span
lang=3DEN-US><o:p></o:p></span></span></p>
<p class=3DMsoNormalIndent style=3D'margin-left:60.0pt;text-indent:-36.0pt;
mso-list:l9 level1 lfo4;tab-stops:list 60.0pt'><![if !supportLists]><span
lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun;mso-bidi=
-font-family:
SimSun'><span style=3D'mso-list:Ignore'>（3）<span style=3D'fon=
t:7.0pt "Times New Roman"'>
</span></span></span><![endif]><span style=3D'mso-bidi-font-size:10.5pt;
font-family:SimSun'>用户定义的完整=
;性（规则，默认）<span
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -