web系统开发技术交流平台数据库设计说明书.doc

是一个自己做的关于WEB交流平台的软件工程的十个文档

style='mso-bidi-font-weight:normal'><span lang=EN-US style='font-size:14.0pt'><o:p></o:p></span></b></span></span></p>

<p class=MsoNormal style='text-indent:18.0pt;mso-char-indent-count:1.5'><span
style='mso-bookmark:_Toc445704833'><span style='mso-bookmark:_Toc436445619'><a
name="_Toc445704836">系统名称：<span lang=EN-US>Web</span>系统开发技术交流平台</a></span></span></p>

<p class=a style='margin-left:28.5pt;text-indent:-18.0pt;mso-list:l1 level1 lfo2;
tab-stops:list 28.5pt'><span style='mso-bookmark:_Toc445704833'><span
style='mso-bookmark:_Toc436445619'><span style='mso-bookmark:_Toc445704836'><![if !supportLists]><span
lang=EN-US style='mso-fareast-font-family:Arial;mso-bidi-font-family:Arial'><span
style='mso-list:Ignore'>a.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]><span style='font-family:宋体;mso-ascii-font-family:
Arial;mso-hansi-font-family:"Times New Roman"'>项目提出者：本小组全体成员</span></span></span></span></p>

<p class=a style='margin-left:28.5pt;text-indent:-18.0pt;mso-list:l1 level1 lfo2;
tab-stops:list 28.5pt'><span style='mso-bookmark:_Toc445704833'><span
style='mso-bookmark:_Toc436445619'><span style='mso-bookmark:_Toc445704836'><![if !supportLists]><span
lang=EN-US style='font-family:"Times New Roman";mso-fareast-font-family:"Times New Roman"'><span
style='mso-list:Ignore'>b.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]><span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>项目开发者：</span></span></span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bookmark:_Toc436445619'><span
style='mso-bookmark:_Toc445704836'><span style='font-family:宋体;mso-ascii-font-family:
Arial;mso-hansi-font-family:"Times New Roman"'>本小组全体成员</span></span></span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bookmark:_Toc436445619'><span
style='mso-bookmark:_Toc445704836'><span lang=EN-US style='font-family:"Times New Roman"'><o:p></o:p></span></span></span></span></p>

<p class=a style='margin-left:28.5pt;text-indent:-18.0pt;mso-list:l1 level1 lfo2;
tab-stops:list 28.5pt'><span style='mso-bookmark:_Toc445704833'><span
style='mso-bookmark:_Toc436445619'><span style='mso-bookmark:_Toc445704836'><![if !supportLists]><span
lang=EN-US style='font-family:"Times New Roman";mso-fareast-font-family:"Times New Roman"'><span
style='mso-list:Ignore'>c.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]><span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>项目管理者：</span></span></span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bookmark:_Toc436445619'><span
style='mso-bookmark:_Toc445704836'><span style='font-family:宋体;mso-ascii-font-family:
Arial;mso-hansi-font-family:"Times New Roman"'>本小组全体成员</span></span></span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bookmark:_Toc436445619'><span
style='mso-bookmark:_Toc445704836'><span lang=EN-US style='font-family:"Times New Roman"'><o:p></o:p></span></span></span></span></p>

<p class=a style='margin-left:28.5pt;text-indent:-18.0pt;mso-list:l1 level1 lfo2;
tab-stops:list 28.5pt'><span style='mso-bookmark:_Toc445704833'><span
style='mso-bookmark:_Toc436445619'><span style='mso-bookmark:_Toc445704836'><![if !supportLists]><span
lang=EN-US style='font-family:"Times New Roman";mso-fareast-font-family:"Times New Roman"'><span
style='mso-list:Ignore'>d.<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;
</span></span></span><![endif]><span style='font-family:宋体;mso-ascii-font-family:
"Times New Roman";mso-hansi-font-family:"Times New Roman"'>最终用户：</span></span></span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bookmark:_Toc436445619'><span
style='mso-bookmark:_Toc445704836'><span style='font-family:宋体;mso-ascii-font-family:
Arial;mso-hansi-font-family:"Times New Roman"'>三明学院全体师生</span></span></span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bookmark:_Toc436445619'><span
style='mso-bookmark:_Toc445704836'><span lang=EN-US style='font-family:"Times New Roman"'><o:p></o:p></span></span></span></span></p>

<p><span style='mso-bookmark:_Toc445704833'><span style='mso-bookmark:_Toc436445619'><span
style='mso-bookmark:_Toc445704836'><b style='mso-bidi-font-weight:normal'><span
lang=EN-US style='font-size:14.0pt'>1.3 </span></b></span></span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bookmark:_Toc436445619'><span
style='mso-bookmark:_Toc445704836'><b style='mso-bidi-font-weight:normal'><span
style='font-size:14.0pt'>定义</span></b></span></span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bookmark:_Toc436445619'><b
style='mso-bidi-font-weight:normal'><span lang=EN-US style='font-size:14.0pt'><o:p></o:p></span></b></span></span></p>

<p class=MsoNormal style='margin-left:78.0pt;mso-para-margin-left:1.5gd;
text-indent:-60.0pt;mso-char-indent-count:-5.0'><span style='mso-bookmark:_Toc445704833'><span
style='mso-bookmark:_Toc436445619'>实现环境：</span></span><span style='mso-bookmark:
_Toc445704833'><span style='mso-bookmark:_Toc436445619'><span style='mso-bidi-font-size:
10.5pt'>学生、<st1:PersonName ProductID="任课" w:st="on">任课</st1:PersonName>老师通过访问服务器获得</span></span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bookmark:_Toc436445619'><span
style='mso-bidi-font-size:10.5pt;mso-ascii-font-family:STSong-Light;mso-hansi-font-family:
STSong-Light'>学生自主选择学习</span></span></span><span style='mso-bookmark:_Toc445704833'><span
style='mso-bookmark:_Toc436445619'><span lang=EN-US style='mso-bidi-font-size:
10.5pt;font-family:Times-Roman'>,</span></span></span><span style='mso-bookmark:
_Toc445704833'><span style='mso-bookmark:_Toc436445619'><span style='mso-bidi-font-size:
10.5pt;mso-ascii-font-family:STSong-Light;mso-hansi-font-family:STSong-Light'>教师和学生相互交流等功能</span>。</span></span></p>

<p class=MsoNormal style='margin-left:18.0pt;mso-para-margin-left:1.5gd'><span
style='mso-bookmark:_Toc445704833'><span style='mso-bookmark:_Toc436445619'>实现技术：系统所采用的软件技术为后台数据库技术。</span></span></p>

<p class=MsoNormal style='text-indent:18.0pt;mso-char-indent-count:1.5'><span
style='mso-bookmark:_Toc445704833'><span style='mso-bookmark:_Toc436445619'>实现语言或工具：实现系统最终采用的编程语言为<span
lang=EN-US>VB</span>。</span></span></p>

<p class=MsoNormal style='line-height:150%'><span style='mso-bookmark:_Toc445704833'><span
style='mso-bookmark:_Toc436445619'><span lang=EN-US><o:p>&nbsp;</o:p></span></span></span></p>

<p><span style='mso-bookmark:_Toc445704833'><span style='mso-bookmark:_Toc436445619'><a
name="_Toc445704837"><b style='mso-bidi-font-weight:normal'><span lang=EN-US
style='font-size:14.0pt'>1.4 </span></b></a></span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bookmark:_Toc436445619'><span
style='mso-bookmark:_Toc445704837'><b style='mso-bidi-font-weight:normal'><span
style='font-size:14.0pt'>参考资料</span></b></span></span></span><span
style='mso-bookmark:_Toc445704833'><b style='mso-bidi-font-weight:normal'><span
lang=EN-US style='font-size:14.0pt'><o:p></o:p></span></b></span></p>

<p class=MsoNormal style='margin-left:26.65pt;mso-para-margin-left:-.28gd;
text-indent:-30.0pt;mso-char-indent-count:-2.5'><span style='mso-bookmark:_Toc445704833'><span
lang=EN-US>[1]</span></span><span style='mso-bookmark:_Toc445704833'><span
style='mso-bidi-font-size:9.0pt;mso-ascii-font-family:STSong-Light;mso-hansi-font-family:
STSong-Light'>　施威铭研究室</span><span lang=EN-US>.SQLServer2000</span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bidi-font-size:9.0pt;
mso-ascii-font-family:STSong-Light;mso-hansi-font-family:STSong-Light'>中文版管理实务</span><span
lang=EN-US>[M].</span></span><span style='mso-bookmark:_Toc445704833'><span
style='mso-bidi-font-size:9.0pt;mso-ascii-font-family:STSong-Light;mso-hansi-font-family:
STSong-Light'>北京</span><span lang=EN-US>:</span></span><span style='mso-bookmark:
_Toc445704833'><span style='mso-bidi-font-size:9.0pt;mso-ascii-font-family:
STSong-Light;mso-hansi-font-family:STSong-Light'>人民邮电出版社</span><span
lang=EN-US>.2006:16-18.</span></span></p>

<p class=MsoNormal style='margin-left:30.0pt;text-indent:-30.0pt;mso-char-indent-count:
-2.5'><span style='mso-bookmark:_Toc445704833'><span lang=EN-US>[2]</span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bidi-font-size:9.0pt;
mso-ascii-font-family:STSong-Light;mso-hansi-font-family:STSong-Light'>　张能立</span><span
lang=EN-US>,</span></span><span style='mso-bookmark:_Toc445704833'><span
style='mso-bidi-font-size:9.0pt;mso-ascii-font-family:STSong-Light;mso-hansi-font-family:
STSong-Light'>谢佳</span><span lang=EN-US>,</span></span><span style='mso-bookmark:
_Toc445704833'><span style='mso-bidi-font-size:9.0pt;mso-ascii-font-family:
STSong-Light;mso-hansi-font-family:STSong-Light'>杨新泉</span><span lang=EN-US>.ASP.NET</span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bidi-font-size:9.0pt;
mso-ascii-font-family:STSong-Light;mso-hansi-font-family:STSong-Light'>在网站开发中的应用</span><span
lang=EN-US>[J].</span></span><span style='mso-bookmark:_Toc445704833'><span
style='mso-bidi-font-size:9.0pt;mso-ascii-font-family:STSong-Light;mso-hansi-font-family:
STSong-Light'>计算机与数程</span><span lang=EN-US>,2005,33(6):83-86.</span></span></p>

<p class=MsoNormal><span style='mso-bookmark:_Toc445704833'><span lang=EN-US>[3]</span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bidi-font-size:9.0pt;
mso-ascii-font-family:STSong-Light;mso-hansi-font-family:STSong-Light'>　张海潘</span><span
lang=EN-US>.</span></span><span style='mso-bookmark:_Toc445704833'><span
style='mso-bidi-font-size:9.0pt;mso-ascii-font-family:STSong-Light;mso-hansi-font-family:
STSong-Light'>软件工程导论</span><span lang=EN-US>(</span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bidi-font-size:9.0pt;
mso-ascii-font-family:STSong-Light;mso-hansi-font-family:STSong-Light'>第四版</span><span
lang=EN-US>)[M].</span></span><span style='mso-bookmark:_Toc445704833'><span
style='mso-bidi-font-size:9.0pt;mso-ascii-font-family:STSong-Light;mso-hansi-font-family:
STSong-Light'>北京</span><span lang=EN-US>:</span></span><span style='mso-bookmark:
_Toc445704833'><span style='mso-bidi-font-size:9.0pt;mso-ascii-font-family:
STSong-Light;mso-hansi-font-family:STSong-Light'>清华大学出版社</span><span
lang=EN-US>,2003.</span></span></p>

<p class=MsoNormal><span style='mso-bookmark:_Toc445704833'><span lang=EN-US>[4]</span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bidi-font-size:9.0pt;
mso-ascii-font-family:STSong-Light;mso-hansi-font-family:STSong-Light'>　桂思强</span><span
lang=EN-US>.ASP.NET</span></span><span style='mso-bookmark:_Toc445704833'><span
style='mso-bidi-font-size:9.0pt;mso-ascii-font-family:STSong-Light;mso-hansi-font-family:
STSong-Light'>数据库开发圣经</span><span lang=EN-US>[M].</span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bidi-font-size:9.0pt;
mso-ascii-font-family:STSong-Light;mso-hansi-font-family:STSong-Light'>北京</span><span
lang=EN-US>.</span></span><span style='mso-bookmark:_Toc445704833'><span
style='mso-bidi-font-size:9.0pt;mso-ascii-font-family:STSong-Light;mso-hansi-font-family:
STSong-Light'>中国青年出版社</span><span lang=EN-US>,2005.</span></span></p>

<p class=MsoNormal style='margin-left:24.0pt;text-indent:-24.0pt;mso-char-indent-count:
-2.0'><span style='mso-bookmark:_Toc445704833'><span lang=EN-US>[5] </span>谭</span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bidi-font-size:9.0pt;
mso-ascii-font-family:STSong-Light;mso-hansi-font-family:STSong-Light'>明佳</span><span
lang=EN-US>.</span></span><span style='mso-bookmark:_Toc445704833'><span
style='mso-bidi-font-size:9.0pt;mso-ascii-font-family:STSong-Light;mso-hansi-font-family:
STSong-Light'>基于</span><span lang=EN-US>ASP.NET</span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bidi-font-size:9.0pt;
mso-ascii-font-family:STSong-Light;mso-hansi-font-family:STSong-Light'>的</span><span
lang=EN-US>Web</span></span><span style='mso-bookmark:_Toc445704833'><span
style='mso-bidi-font-size:9.0pt;mso-ascii-font-family:STSong-Light;mso-hansi-font-family:
STSong-Light'>程序优化分析</span><span lang=EN-US>[J].</span></span><span
style='mso-bookmark:_Toc445704833'><span style='mso-bidi-font-size:9.0pt;
mso-ascii-font-family:STSong-Light;mso-hansi-font-family:STSong-Light'>计算机与现代化</span><span
lang=EN-US>,2005(3):45-47.</span></span></p>

<p class=MsoNormal><span style='mso-bookmark:_Toc445704833'><span lang=EN-US>[6]<span
style='mso-spacerun:yes'>&nbsp; </span></span>《<span lang=EN-US>ASP</span>动态网站开发基础教程》
清华大学出版社</span></p>

<p><span style='mso-bookmark:_Toc445704833'><b style='mso-bidi-font-weight:
normal'><span lang=EN-US style='font-size:14.0pt'>2.</span></b></span><span
style='mso-bookmark:_Toc445704833'><b style='mso-bidi-font-weight:normal'><span
style='font-size:14.0pt'>　外部设计</span></b> </span></p>

<p><span style='mso-bookmark:_Toc445704833'><b style='mso-bidi-font-weight:
normal'><span lang=EN-US style='font-size:14.0pt'>2.1</span></b></span><span
style='mso-bookmark:_Toc445704833'><b style='mso-bidi-font-weight:normal'><span
style='font-size:14.0pt'>　标识符和状态 <span lang=EN-US><o:p></o:p></span></span></b></span></p>

<p><span style='mso-bookmark:_Toc445704833'><span style='font-size:10.0pt'>　　</span>本系统使用的数据库名称是<span
lang=EN-US>TECHING</span>，是专门为高校计算机学院开发的，供高校师生日常交流使用，实现资源共享，方便师生交流。它是基于网络平台技术交流与资源共享实现的。本数据库的建立已完善，可以投入使用。
</span></p>

<p><span style='mso-bookmark:_Toc445704833'><b style='mso-bidi-font-weight:
normal'><span lang=EN-US style='font-size:14.0pt'>2.2</span></b></span><span
style='mso-bookmark:_Toc445704833'><b style='mso-bidi-font-weight:normal'><span
style='font-size:14.0pt'>　使用它的程序 <span lang=EN-US><o:p></o:p></span></span></b></span></p>

<p><span style='mso-bookmark:_Toc445704833'></span><!--[if mso & !supportInlineShapes & supportFields]><span
style='mso-bookmark:_Toc445704833'></span><span style='mso-element:field-begin;
mso-field-lock:yes'></span><span style='mso-bookmark:_Toc445704833'><span
lang=EN-US style='color:white'><span style='mso-spacerun:yes'>&nbsp;</span>SHAPE
<span style='mso-spacerun:yes'>&nbsp;</span>\* MERGEFORMAT <span
style='mso-element:field-separator'></span></span></span><![endif]--><span
style='mso-bookmark:_Toc445704833'><span lang=EN-US style='color:white'><!--[if gte vml 1]><v:group
 id="_x0000_s1096" editas="canvas" style='width:585pt;height:342pt;
 mso-position-horizontal-relative:char;mso-position-vertical-relative:line'
 coordorigin="72,1832" coordsize="11700,6840">
 <o:lock v:ext="edit" aspectratio="t"/>
 <v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75"
  o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
  <v:stroke joinstyle="miter"/>
  <v:formulas>
   <v:f eqn="if lineDrawn pixelLineWidth 0"/>
   <v:f eqn="sum @0 1 0"/>
   <v:f eqn="sum 0 0 @1"/>
   <v:f eqn="prod @2 1 2"/>
   <v:f eqn="prod @3 21600 pixelWidth"/>
   <v:f eqn="prod @3 21600 pixelHeight"/>
   <v:f eqn="sum @0 0 1"/>
   <v:f eqn="prod @6 1 2"/>
   <v:f eqn="prod @7 21600 pixelWidth"/>
   <v:f eqn="sum @8 21600 0"/>
   <v:f eqn="prod @7 21600 pixelHeight"/>
   <v:f eqn="sum @10 21600 0"/>
  </v:formulas>
  <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
  <o:lock v:ext="edit" aspectratio="t"/>
 </v:shapetype><v:shape id="_x0000_s1097" type="#_x0000_t75" style='position:absolute;
  left:72;top:1832;width:11700;height:6840' o:preferrelative="f">
  <v:fill o:detectmouseclick="t"/>
  <v:path o:extrusionok="t" o:connecttype="none"/>
 </v:shape><v:group id="_x0000_s1098" style='position:absolute;left:504;top:2192;
  width:8928;height:5760' coordorigin="2340,1988" coordsize="7560,5928">
  <v:rect id="_x0000_s1099" style='position:absolute;left:4140;top:1988;
   width:3961;height:469'>
   <v:textbox style='mso-next-textbox:#_x0000_s1099'>
    <![if !mso]>
    <table cellpadding=0 cellspacing=0 width="100%">
     <tr>
      <td><![endif]>
      <div>
      <p class=MsoNormal><span lang=EN-US>Web</span>系统开发技术交流平台设计</p>
      </div>
      <![if !mso]></td>
     </tr>
    </table>
    <![endif]></v:textbox>
  </v:rect><v:rect id="_x0000_s1100" style='position:absolute;left:4500;top:3082;
   width:3420;height:467'>
   <v:textbox style='mso-next-textbox:#_x0000_s1100'>
    <![if !mso]>
    <table cellpadding=0 cellspacing=0 width="100%">
     <tr>
      <td><![endif]>
      <div>
      <p class=MsoNormal><span style='mso-bidi-font-size:10.5pt'>用户登录（管理员、教师和学生）<span
      lang=EN-US><o:p></o:p></span></span></p>
      </div>
      <![if !mso]></td>
     </tr>
    </table>
    <![endif]></v:textbox>
  </v:rect><v:rect id="_x0000_s1101" style='position:absolute;left:2341;top:4797;
   width:1438;height:467'>
   <v:textbox style='mso-next-textbox:#_x0000_s1101'>
    <![if !mso]>
    <table cellpadding=0 cellspacing=0 width="100%">
     <tr>
      <td><![endif]>
      <div>
      <p class=MsoNormal><span style='mso-bidi-font-size:10.5pt'>教师讲授区<span
      lang=EN-US><o:p></o:p></span></span></p>
      </div>
      <![if !mso]></td>
     </tr>
    </table>
    <![endif]></v:textbox>
  </v:rect><v:rect id="_x0000_s1102" style='position:absolute;left:4501;top:4799;