《数据库实验及课程设计》实验指导书.mht

酒店管理系统

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'>&#19977;&#12289;&#23454;&#39564;&#20869;&#23481;=
<span
lang=3DEN-US><o:p></o:p></span></span></b></p>

<p class=3DMsoNormalIndent style=3D'margin-left:21.25pt;text-indent:0cm'><s=
pan
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'>&#12289;&#36827;&#20=
837;&#20225;&#19994;&#31649;&#29702;&#22120;&#24314;&#31435;&#19968;&#20010=
;&#25945;&#23398;&#31649;&#29702;&#25968;&#25454;&#24211;<span
lang=3DEN-US>.</span>&#21253;&#21547;&#20197;&#19979;&#34920;&#65306;<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'><span style=3D'mso-spacerun:yes'>&nbsp; </span></span><=
span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>&#23398;&#29983;&#65=
288;&#23398;&#21495;&#65292;&#22995;&#21517;
&#65292;&#24615;&#21035;&#65292;&#24180;&#40836;&#65292;&#25152;&#22312;&#3=
1995;&#65289;
<span lang=3DEN-US><span
style=3D'mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'text-indent:28.9pt;mso-char-indent-coun=
t:2.75'><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>&#35838;&#31243;&#65=
288;&#35838;&#31243;&#21495;&#65292;&#35838;&#31243;&#21517;&#65292;&#20808=
;&#34892;&#35838;&#65292;&#23398;&#20998;&#65289;<span
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'text-indent:28.9pt;mso-char-indent-coun=
t:2.75'><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>&#36873;&#35838;&#65=
288;&#23398;&#21495;&#65292;&#35838;&#31243;&#21495;&#65292;&#25104;&#32489=
;&#65289;<span
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'text-indent:28.9pt;mso-char-indent-coun=
t:2.75'><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>&#25945;&#24072;&#65=
288;&#25945;&#24072;&#21495;&#65292;&#22995;&#21517;&#65292;&#32844;&#31216=
;&#65289;<span
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'text-indent:28.9pt;mso-char-indent-coun=
t:2.75'><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>&#20219;&#35838;&#65=
288;&#25945;&#24072;&#21495;&#65292;&#25945;&#24072;&#21495;&#65292;&#26102=
;&#38388;&#65289;<span
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'text-indent:28.9pt;mso-char-indent-coun=
t:2.75'><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>&#24182;&#20026;&#21=
508;&#34920;&#36873;&#25321;&#20027;&#38190;&#21644;&#22806;&#38190;<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'>&#12289;&#24314;&#31435;&#35268;&#21017;<span lang=3DEN-US>rule_sex=
,</span>&#21644;<span
lang=3DEN-US>rule_age<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'><span style=3D'mso-spacerun:yes'>&nbsp;&nbsp; </span></=
span><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>&#20351;&#23398;&#29=
983;&#30340;&#24615;&#21035;&#21482;&#33021;&#20026;<span
lang=3DEN-US>&#8217;</span>&#30007;<span lang=3DEN-US>&#8217;</span>&#25110=
;<span
lang=3DEN-US>&#8217;</span>&#22899;<span lang=3DEN-US>&#8217;<o:p></o:p></s=
pan></span></p>

<p class=3DMsoNormalIndent><span lang=3DEN-US style=3D'mso-bidi-font-size:1=
0.5pt;
font-family:SimSun'><span style=3D'mso-spacerun:yes'>&nbsp;&nbsp; </span></=
span><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>&#20351;&#23398;&#29=
983;&#30340;&#24180;&#40836;&#22312;<span
lang=3DEN-US>10 </span>&#21040;<span lang=3DEN-US> 40 </span>&#20043;&#3838=
8;<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'>&#12289;&#24314;&#31435;&#40664;&#35748;&#20540;<span lang=3DEN-US>=
default_department<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'><span style=3D'mso-spacerun:yes'>&nbsp;&nbsp; </span></=
span><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>&#20351;&#25152;&#22=
312;&#31995;&#30340;&#40664;&#35748;&#20540;&#20026;&#8216;&#35745;&#31639;=
&#26426;<span
lang=3DEN-US>&#8217;</span>&#12290;<span lang=3DEN-US><o:p></o:p></span></s=
pan></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'>&#12289;&#36755;&#20837;&#25968;&#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'><span style=3D'mso-spacerun:yes'>&nbsp;&nbsp; </span></=
span><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>&#25353;&#12298;&#25=
968;&#25454;&#24211;&#31995;&#32479;&#27010;&#35770;&#12299;&#31532;<span
lang=3DEN-US>59</span>&#39029;&#36755;&#20837;&#25968;&#25454;<span lang=3D=
EN-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'>5</span><span style=3D'mso-bidi-font-size:10.5pt;font-f=
amily:
SimSun'>&#12289;&#26816;&#39564;&#23454;&#20307;&#23436;&#25972;&#24615;&#6=
5292;&#21442;&#29031;&#23436;&#25972;&#24615;&#65292;&#35268;&#21017;&#6529=
2;&#21450;&#40664;&#35748;<span
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'margin-left:68.95pt;text-indent:-36.0pt;
mso-list:l15 level1 lfo5;tab-stops:list 68.95pt'><![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'>&#65288;1&#65289;<span style=3D'fon=
t:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]><span style=3D'mso-bidi-font-size:10.5pt;
font-family:SimSun'>&#22312;&#23398;&#29983;&#34920;&#20013;&#36755;&#20837=
;&#65288;<span
lang=3DEN-US>95004</span>&#65292;&#20309;&#38190;&#65292;&#30007;&#65292;<s=
pan
lang=3DEN-US>20</span>&#65292;&#35745;&#31639;&#26426;&#65289;&#12290;<span
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'margin-left:32.95pt;mso-para-margin-lef=
t:3.14gd;
text-indent:31.5pt;mso-char-indent-count:3.0'><span style=3D'mso-bidi-font-=
size:
10.5pt;font-family:SimSun'>&#22914;&#26524;&#25968;&#25454;&#26080;&#27861;=
&#20445;&#23384;&#65292;&#35299;&#37322;&#25968;&#25454;&#26080;&#27861;&#2=
0445;&#23384;&#30340;&#21407;&#22240;<span
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'margin-left:68.95pt;text-indent:-36.0pt;
mso-list:l15 level1 lfo5;tab-stops:list 68.95pt'><![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'>&#65288;2&#65289;<span style=3D'fon=
t:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]><span style=3D'mso-bidi-font-size:10.5pt;
font-family:SimSun'>&#22312;&#36873;&#35838;&#34920;&#20013;&#36755;&#20837=
;&#65288;<span
lang=3DEN-US>01002</span>&#65292;<span lang=3DEN-US>1</span>&#65292;<span
lang=3DEN-US>70</span>&#65289;&#12290;<span lang=3DEN-US><o:p></o:p></span>=
</span></p>

<p class=3DMsoNormalIndent style=3D'text-indent:60.4pt;mso-char-indent-coun=
t:5.75'><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>&#22914;&#26524;&#25=
968;&#25454;&#26080;&#27861;&#20445;&#23384;&#65292;&#35299;&#37322;&#25968=
;&#25454;&#26080;&#27861;&#20445;&#23384;&#30340;&#21407;&#22240;&#12290;<s=
pan
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'margin-left:68.95pt;text-indent:-36.0pt;
mso-list:l15 level1 lfo5;tab-stops:list 68.95pt'><![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'>&#65288;3&#65289;<span style=3D'fon=
t:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]><span style=3D'mso-bidi-font-size:10.5pt;
font-family:SimSun'>&#22312;&#23398;&#29983;&#34920;&#20013;&#36755;&#20837=
;&#65288;<span
lang=3DEN-US>95005</span>&#65292;&#20309;&#38190;&#65292;<span lang=3DEN-US=
>male</span>&#65292;<span
lang=3DEN-US>20</span>&#65292;&#35745;&#31639;&#26426;&#65289;&#12290;<span
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'margin-left:32.95pt;mso-para-margin-lef=
t:3.14gd;
text-indent:31.5pt;mso-char-indent-count:3.0'><span style=3D'mso-bidi-font-=
size:
10.5pt;font-family:SimSun'>&#22914;&#26524;&#25968;&#25454;&#26080;&#27861;=
&#20445;&#23384;&#65292;&#35299;&#37322;&#25968;&#25454;&#26080;&#27861;&#2=
0445;&#23384;&#30340;&#21407;&#22240;<span
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'margin-left:68.95pt;text-indent:-36.0pt;
mso-list:l15 level1 lfo5;tab-stops:list 68.95pt'><![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'>&#65288;4&#65289;<span style=3D'fon=
t:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]><span style=3D'mso-bidi-font-size:10.5pt;
font-family:SimSun'>&#22312;&#23398;&#29983;&#34920;&#20013;&#36755;&#20837=
;&#65288;<span
lang=3DEN-US>95005</span>&#65292;&#20309;&#38190;&#65292;&#30007;&#65292;<s=
pan
lang=3DEN-US>20</span>&#65289;&#12290;<span lang=3DEN-US><o:p></o:p></span>=
</span></p>

<p class=3DMsoNormalIndent style=3D'margin-left:32.95pt;mso-para-margin-lef=
t:3.14gd;
text-indent:31.5pt;mso-char-indent-count:3.0'><span style=3D'mso-bidi-font-=
size:
10.5pt;font-family:SimSun'>&#20445;&#23384;&#25968;&#25454;&#65292;&#24182;=
&#26597;&#30475;&#25968;&#25454;&#24211;&#20013;&#35813;&#35760;&#24405;&#1=
2290;&#19982;&#36755;&#20837;&#27604;&#36739;&#35813;&#35760;&#24405;&#2637=
7;&#21644;&#19981;&#21516;&#12290;<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'>&#22235;&#12289;&#23454;&#39564;&#27493;&#39588;=
<span
lang=3DEN-US><o:p></o:p></span></span></b></p>

<p class=3DMsoNormalIndent style=3D'margin-left:57.0pt;text-indent:-21.0pt;
mso-list:l8 level1 lfo6;tab-stops:list 57.0pt'><![if !supportLists]><span
lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:Wingdings;mso-f=
areast-font-family:
Wingdings;mso-bidi-font-family:Wingdings;mso-bidi-font-weight:bold'><span
style=3D'mso-list:Ignore'>u<span style=3D'font:7.0pt "Times New Roman"'>&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]><b><span style=3D'mso-bidi-font-size:10.5pt;
font-family:SimSun'>&#24314;&#31435;&#25968;&#25454;&#24211;&#21644;&#34920=
;<span
lang=3DEN-US><o:p></o:p></span></span></b></p>

<p class=3DMsoNormalIndent style=3D'text-indent:36.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'>&#12289;&#22312;&#31=
243;&#24207;&#20013;&#36873;&#25321;<span
lang=3DEN-US>MICROSOFT SQL SERVER<o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'text-indent:36.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'>&#12289;&#36827;&#20=
837;&#26381;&#21153;&#31649;&#29702;&#22120;&#65292;&#28857;&#20987;&#8212;=
&#8212;&#8212;&#24320;&#22987;<span
lang=3DEN-US>/</span>&#32487;&#32493;<span lang=3DEN-US><o:p></o:p></span><=
/span></p>

<p class=3DMsoNormalIndent style=3D'text-indent:36.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'>&#12289;&#20877;&#36=
827;&#20837;&#20225;&#19994;&#31649;&#29702;&#22120;&#65292;<span
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'text-indent:42.0pt;mso-char-indent-coun=
t:4.0'><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>&#28857;&#20987;<span
lang=3DEN-US>MICROSOFT SQL SERVERS<o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'text-indent:36.0pt'><span lang=3DEN-US
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'><span
style=3D'mso-spacerun:yes'>&nbsp; </span></span><span style=3D'mso-bidi-fon=
t-size:
10.5pt;font-family:SimSun'>&#28857;&#20987;<span lang=3DEN-US>SQL SERVER</s=
pan>&#32452;&#65292;<span
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'text-indent:42.0pt;mso-char-indent-coun=
t:4.0'><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>&#28857;&#20987;&#26=
381;&#21153;&#22120;&#65292;<span
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'text-indent:42.0pt;mso-char-indent-coun=
t:4.0'><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>&#28857;&#20987;&#25=
968;&#25454;&#24211;<span
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'text-indent:18.4pt;mso-char-indent-coun=
t:1.75'><span
lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'><span
style=3D'mso-spacerun:yes'>&nbsp;&nbsp; </span>4</span><span style=3D'mso-b=
idi-font-size:
10.5pt;font-family:SimSun'>&#12289;&#22312;&#25968;&#25454;&#24211;&#25991;=
&#20214;&#22841;&#19979;&#21015;&#20986;&#20102;&#26381;&#21153;&#22120;&#1=
9978;&#30340;&#25152;&#26377;&#25968;&#25454;&#24211;<span
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'text-indent:18.4pt;mso-char-indent-coun=
t:1.75'><span
lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'><span
style=3D'mso-spacerun:yes'>&nbsp;&nbsp;&nbsp;&nbsp; </span></span><span
style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'>&#21491;&#38190;&#28=
857;&#20987;&#25968;&#25454;&#24211;&#65292;&#36873;&#25321;&#26032;&#24314=
;&#25968;&#25454;&#24211;&#65292;&#36755;&#20837;&#25945;&#23398;&#31649;&#=
29702;&#65292;&#24182;&#30830;&#23450;<span
lang=3DEN-US><o:p></o:p></span></span></p>

<p class=3DMsoNormalIndent style=3D'text-indent:18.4pt;mso-char-indent-coun=
t:1.75'><span
lang=3DEN-US style=3D'mso-bidi-font-size:10.5pt;font-family:SimSun'><span
style=3D'mso-spacerun:yes'>&nbsp;&nbsp; </span>5</span><span style=3D'mso-b=
idi-font-size:
10.5pt;font-family:SimSun'>&#12289;&#28857;&#20987;&#25968;&#25454;&#24211;=
&#25991;&#20214;&#22841;&#19979;&#30340;&#25945;&#23398;&#31649;&#29702;&#6=
5292;&#2999