【用例】研究生招生报名管理系统设计

Bertha 。 2022-09-25 04:24 157阅读 0赞

前一篇博客对报名管理系统进行了系统分析，以下是对该系统的设计。

系统设计分为五个部分：

1.  系统体系结构  
    ![46a897d5-0483-3b98-9c10-28df943b9124.png][]

横向：1、考生向服务器提出请求；

2、服务器将请求转发给控制器；

3、控制器根据请求的不同调用模型，进行必要的数据操作；

4、控制器把处理结果转发给显示视图；

5、视图对信息处理结果进行格式化并返回结果给服务器

6、服务器把信息处理结果回送给客户机并呈现于考生。

纵向：

系统软件层：

由操作系统或应用服务器提供的某些功能包，如：对磁盘的操作、应用服务器提供的负载均衡；

中间件层：

有某些开发环境或专门的应用工具提供的功能包，如：考生填报系统所需的Java的java.sql包，成绩统计分析所需的报表工具提供的相关功能；

通用应用层：

能在当前项目内实现重用的功能包，如：数据库功能包（考生信息存储），打印功能包（准考证打印）等；

专用应用层：

该系统所需的专门应用功能包，通常有开发者自己开发该功能包用于考生专业的业务功能，如：报考系统的考生信息管理功能，学籍、推荐信审核功能等。

1.  “考生报名”用例设计
    
    用例设计流：
    
    用例名：考生报名
    
    基本操作流程：

1.  考生登录进入到个人信息填写页面，在基本信息填写完后考生点击“确认并提交”按钮，系统审核该考生是否具有学信网学籍；
2.  之后进入到报考信息填写界面，考生填写报考信息，在考生选择了报考学院（下拉框列表）后，系统在专业一项的下拉框列表中提供可选的专业，选择完专业后，系统在导师一项的下拉框列表里提供可选的导师，在填写完成后考生点击“确认并提交”按钮；
3.  考生进行专家推荐信上传，通过文件浏览的方式进行推荐信的上传，考生点击“确认并上传”按钮，系统审核推荐信是否通过（两封且推荐信符合规范）；
4.  系统整理并通过视图将考生所填写的资料呈现给考生，并让考生通过点击按钮“确认”和“修改”对所填信息进行确认或修改；
5.  考生进行考试报名费的缴支付，系统显示报名费的金额，考生单击系统超链接“在线支付报名费”；
6.  系统审核考生的个人信息、报考信息、专家推荐信以及报名费；
7.  信息审核通过，系统报存考生报考信息，并显示准考证原件页面；
8.  系统自动生成考生准考证号，准考证号规则：年份（4位）\+学院编号（4位）\+专业编号（3位）\+序号（两位）；
9.  系统生成考生准考证，考生可通过点击“打印准考证”超链接进行准考证的打印。

1.  用例“考生报名”交互图设计

用例顺序图

![45f203b6-ad56-338e-8dc3-df52fcb66e31.png][]

1.  整个系统的类设计
    
      
    ![45f203b6-ad56-338e-8dc3-df52fcb66e31.png][]  
    
2.  数据库表设计
    
    （1）考生表

<table style="margin: auto auto auto 20.4pt; border-image: none; border-collapse: collapse;"> 
 <tbody> 
 <tr> 
 <td style="padding: 0cm 5.4pt; border-image: none; width: 60.85pt; background-color: transparent;"> 字段名 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 60.85pt; background-color: transparent;"> 数据类型 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 60.85pt; background-color: transparent;"> 数据宽度 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 60.85pt; background-color: transparent;"> 是否为空 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 60.9pt; background-color: transparent;"> 键 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 60.9pt; background-color: transparent;"> 自动增加 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 60.9pt; background-color: transparent;"> 默认值 </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 60.85pt; background-color: transparent;"> stu_ID </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> Int </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> no </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> PK </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 60.85pt; background-color: transparent;"> stu_name </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> Char </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> no </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 60.85pt; background-color: transparent;"> age </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> int </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> no </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 60.85pt; background-color: transparent;"> graduate_school </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> Char </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> no </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 60.85pt; background-color: transparent;"> Major_ID </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> Int </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> no </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> FK </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 60.85pt; background-color: transparent;"> Phone_num </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> Int </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> 11 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.85pt; background-color: transparent;"> no </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 60.9pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 </tbody> 
</table>

（2）导师表

<table style="margin: auto auto auto 20.4pt; border-image: none; border-collapse: collapse;"> 
 <tbody> 
 <tr> 
 <td style="padding: 0cm 5.4pt; border-image: none; width: 57.9pt; background-color: transparent;"> 字段名 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 57.9pt; background-color: transparent;"> 数据类型 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 57.95pt; background-color: transparent;"> 数据宽度 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 57.95pt; background-color: transparent;"> 是否为空 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 58pt; background-color: transparent;"> 键 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 58pt; background-color: transparent;"> 自动增加 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 58pt; background-color: transparent;"> 默认值 </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 57.9pt; background-color: transparent;"> Teacher_ID </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.9pt; background-color: transparent;"> Int </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> No </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> PK </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 57.9pt; background-color: transparent;"> Name </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.9pt; background-color: transparent;"> Char </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> No </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 57.9pt; background-color: transparent;"> School </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.9pt; background-color: transparent;"> Char </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> No </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 57.9pt; background-color: transparent;"> Major_ID </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.9pt; background-color: transparent;"> Int </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> no </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> FK </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 </tbody> 
</table>

（3）推荐信表

（4）专业表

<table style="margin: auto auto auto 20.4pt; border-image: none; border-collapse: collapse;"> 
 <tbody> 
 <tr> 
 <td style="padding: 0cm 5.4pt; border-image: none; width: 57.9pt; background-color: transparent;"> 字段名 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 57.9pt; background-color: transparent;"> 数据类型 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 57.95pt; background-color: transparent;"> 数据宽度 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 57.95pt; background-color: transparent;"> 是否为空 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 58pt; background-color: transparent;"> 键 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 58pt; background-color: transparent;"> 自动增加 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 58pt; background-color: transparent;"> 默认值 </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 57.9pt; background-color: transparent;"> Major_ID </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.9pt; background-color: transparent;"> Int </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> No </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> PK </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 57.9pt; background-color: transparent;"> Name </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.9pt; background-color: transparent;"> Char </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> No </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 57.9pt; background-color: transparent;"> School </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.9pt; background-color: transparent;"> Char </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> No </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 57.9pt; background-color: transparent;"> Teacher_ID </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.9pt; background-color: transparent;"> Int </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> No </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> FK </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 57.9pt; background-color: transparent;"> Rules </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.9pt; background-color: transparent;"> Varchar </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> 100 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 57.95pt; background-color: transparent;"> no </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 58pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 </tbody> 
</table>

（5）报名表

<table style="margin: auto auto auto 20.4pt; border-image: none; border-collapse: collapse;"> 
 <tbody> 
 <tr> 
 <td style="padding: 0cm 5.4pt; border-image: none; width: 73.5pt; background-color: transparent;"> 字段名 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 55.8pt; background-color: transparent;"> 数据类型 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 55.15pt; background-color: transparent;"> 数据宽度 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 55.4pt; background-color: transparent;"> 是否为空 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 55.2pt; background-color: transparent;"> 键 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 55.45pt; background-color: transparent;"> 自动增加 </td> 
 <td style="border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0cm 5.4pt; border-image: none; width: 55.2pt; background-color: transparent;"> 默认值 </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 73.5pt; background-color: transparent;"> Form_ID </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.8pt; background-color: transparent;"> int </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.15pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.4pt; background-color: transparent;"> No </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.2pt; background-color: transparent;"> PK </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.45pt; background-color: transparent;"> Yes </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.2pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 73.5pt; background-color: transparent;"> Stu_ID </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.8pt; background-color: transparent;"> Int </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.15pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.4pt; background-color: transparent;"> NO </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.2pt; background-color: transparent;"> FK </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.45pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.2pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 73.5pt; background-color: transparent;"> Stu_name </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.8pt; background-color: transparent;"> Char </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.15pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.4pt; background-color: transparent;"> No </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.2pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.45pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.2pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 73.5pt; background-color: transparent;"> Teacher_nam </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.8pt; background-color: transparent;"> Char </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.15pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.4pt; background-color: transparent;"> No </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.2pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.45pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.2pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 <tr> 
 <td style="border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext windowtext; padding: 0cm 5.4pt; border-image: none; width: 73.5pt; background-color: transparent;"> School </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.8pt; background-color: transparent;"> Char </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.15pt; background-color: transparent;"> 10 </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.4pt; background-color: transparent;"> No </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.2pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.45pt; background-color: transparent;"> &nbsp; </td> 
 <td style="border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0cm 5.4pt; width: 55.2pt; background-color: transparent;"> &nbsp; </td> 
 </tr> 
 </tbody> 
</table>

以上的系统类设计图、用例顺序图均用Enterprise Architect（EA）制作。

初次上手系统设计，许多设计分析不到位，思维不严谨。这里仅供自己留存以及与各位探讨学习之用。

*  [![点击查看原始大小图片][46a897d5-0483-3b98-9c10-28df943b9124-thumb.png]][46a897d5-0483-3b98-9c10-28df943b9124.png]
 *  大小: 30.8 KB

*  [![点击查看原始大小图片][45f203b6-ad56-338e-8dc3-df52fcb66e31-thumb.png]][45f203b6-ad56-338e-8dc3-df52fcb66e31.png]
 *  大小: 50.8 KB

*  [![点击查看原始大小图片][b78789f2-04bd-36e7-b8f1-04eaef56ea06-thumb.png]][b78789f2-04bd-36e7-b8f1-04eaef56ea06-thumb.png 1]
 *  大小: 43.8 KB

*  查看图片附件

[46a897d5-0483-3b98-9c10-28df943b9124.png]: /images/20220718/75dfe312b51d4dae886adce71eaf7204.png
[45f203b6-ad56-338e-8dc3-df52fcb66e31.png]: /images/20220718/189cabdefb4748d0a256262b4d2339dd.png
[46a897d5-0483-3b98-9c10-28df943b9124-thumb.png]: http://dl2.iteye.com/upload/attachment/0116/4882/46a897d5-0483-3b98-9c10-28df943b9124-thumb.png
[45f203b6-ad56-338e-8dc3-df52fcb66e31-thumb.png]: http://dl2.iteye.com/upload/attachment/0116/4884/45f203b6-ad56-338e-8dc3-df52fcb66e31-thumb.png
[b78789f2-04bd-36e7-b8f1-04eaef56ea06-thumb.png]: http://dl2.iteye.com/upload/attachment/0116/4888/b78789f2-04bd-36e7-b8f1-04eaef56ea06-thumb.png
[b78789f2-04bd-36e7-b8f1-04eaef56ea06-thumb.png 1]: /images/20220718/4f53790bda9a40d8a36a8de1c12e5808.png