选课系统数据库设计.doc

1、choose the correct meaning; (4) to correct the typos; (5) so the child write words (ABAB, and AABB); (6) in accordance with written words; (7) the complete word, and explain the meaning of the word; (8) collocation; (9) make sentences with the word; (10) the written language as required. (C) the mai

2、n sentence types (1) complete sentences; (2) write down the meaning of a sentence or expression of thoughts and feelings; (3) write sentences as required; (4) finish malalignment of the sentence; (5) modified sentences. 2, knowledge classification (1) the common conjunctions coordinate: . . 一面 . 1,

3、to examine the topic, identify problems associated with two 2, analysis, alternative question two is in direct proportion to the amount of the associated relationship is inversely proportional relationship. 3, and set unknown, column proportion type 4, and solutions proportion type 5, and test, wrot

4、e answer language plenary, and subject: application problem (1)-simple application problem and composite application problem review content simple application problem composite application problem answers application problem of general steps 1, and figure out meaning-through examines the, find known

5、 conditions and by seeking problem 2, and analysis number relationship-analysis known conditions Zhijian, and conditions and problem Zhijian of relationship, determine problem-solving method and problem-solving steps. 3, and column type calculation-lists formula, is out subdivisions 4, and test, and

6、 wrote answer-check, and checking, and wrote answers typical application problem 13, and subject: application problem (3)-column equation solutions application problem review content overview problem-solving steps 1, and figure out meaning, find by seeking of unknown and x said 2, and according to m

7、eaning find equivalent relationship, lists Equation 3, and solutions equation 4, and test, and wrote answers according to meaning find equivalent relationship of common method 1 , And according to common of number relationship type, established equivalent relationship 2, and according to has learn h

8、ad of calculation formula, 3, and according to problem in the of focus described sentence from overall Shang determine basic of equivalent relationship 4, and using segment figure, and list method, method analysis number目录HEFEI UNIVERSITY.0第 1 章. 系统分析 .21.1 系统分析与总体设计 .21.2 数据库设计与实现 .21.3 系统总体设计 .2第

9、2 章 课题的可行性分析 .32.1 可行性分析 .32.2 数据字典 .4第 3 章 数据库逻辑设计 .53.1 系统逻辑设计 .53.2 主图 .63.3 部分 E-R 实体图 .63.3.1 学生 E-R 实体图 .63.3.2 课程 E-R 实体图 .73.3.3 教学楼，教室 E-R 实体图 .73.3.4 课程时间地点，选课 E-R 实体图 .73.3.5 教师，管理员 E-R 实体图 .8第 4 章数据库物理实现 .84.1 数据库物理实现 .84.1.1 建立数据库 .84.1.2 建立表 .94.1.3 建立关系 .124.2 数据库查询功能 .124.2.1 查询功能 .1

10、24.2.2 插入功能 .134.2.3 删除功能 .134.2.4 更新功能 .14第 5 章总结 .15choose the correct meaning; (4) to correct the typos; (5) so the child write words (ABAB, and AABB); (6) in accordance with written words; (7) the complete word, and explain the meaning of the word; (8) collocation; (9) make sentences with the wo

11、rd; (10) the written language as required. (C) the main sentence types (1) complete sentences; (2) write down the meaning of a sentence or expression of thoughts and feelings; (3) write sentences as required; (4) finish malalignment of the sentence; (5) modified sentences. 2, knowledge classificatio

12、n (1) the common conjunctions coordinate: . . 一面 . 1, to examine the topic, identify problems associated with two 2, analysis, alternative question two is in direct proportion to the amount of the associated relationship is inversely proportional relationship. 3, and set unknown, column proportion t

13、ype 4, and solutions proportion type 5, and test, wrote answer language plenary, and subject: application problem (1)-simple application problem and composite application problem review content simple application problem composite application problem answers application problem of general steps 1, a

14、nd figure out meaning-through examines the, find known conditions and by seeking problem 2, and analysis number relationship-analysis known conditions Zhijian, and conditions and problem Zhijian of relationship, determine problem-solving method and problem-solving steps. 3, and column type calculati

15、on-lists formula, is out subdivisions 4, and test, and wrote answer-check, and checking, and wrote answers typical application problem 13, and subject: application problem (3)-column equation solutions application problem review content overview problem-solving steps 1, and figure out meaning, find

16、by seeking of unknown and x said 2, and according to meaning find equivalent relationship, lists Equation 3, and solutions equation 4, and test, and wrote answers according to meaning find equivalent relationship of common method 1 , And according to common of number relationship type, established e

17、quivalent relationship 2, and according to has learn had of calculation formula, 3, and according to problem in the of focus described sentence from overall Shang determine basic of equivalent relationship 4, and using segment figure, and list method, method analysis number第 1 章. 系统分析1.1 系统分析与总体设计学生

18、选课系统数据库使用 SQL Server2000 建立，并用 ASP 设计和编程实现。学校管理人员通过该学生选课管理系统完成所有的日常教务工作。用户在学校内的所有和教务相关的数据都通过教务管理系统进行管理，如学生管理、师资管理、选课管理、成绩管理等；完成对学校人员，如教师、学生等。该系统需要具有美观容易的操作界面、方便系统的使用者。系统的使用者为不同身份，不同的身份登录系统后可以进入自己的操作界面，不能越权访问其他功能，保证系统的安全、系统数据库设计需方便程序进行访问，方便系统程序的维护、系统的模块都能正常运行，并且满足学校要求。1.2 数据库设计与实现数据库是此系统的核心，系统中所有的信息都

19、存储在数据库中，在所有ASP.NET 页面中与数据库连接，从而实现所有需要的功能。本系统中数据库采用 Microsoft SQL Server 作为数据库工具。数据库设计的合理与功能的实现有着至关重要的影响。一个良好的数据库开发过程一般是先系统分析，再逻辑设计，然后物理实现。系统分析中分析数据库用户需求，并画出 E-R 图直观地表示出数据库系统的需求。通常选取一个常用数据库软件，用数据库软件创建与逻辑设计中数据模型对应的数据库。1.3 系统总体设计在前面的系统的系统功能分析中，将系统划分成 10 个模块，如图：choose the correct meaning; (4) to correct

20、 the typos; (5) so the child write words (ABAB, and AABB); (6) in accordance with written words; (7) the complete word, and explain the meaning of the word; (8) collocation; (9) make sentences with the word; (10) the written language as required. (C) the main sentence types (1) complete sentences; (

21、2) write down the meaning of a sentence or expression of thoughts and feelings; (3) write sentences as required; (4) finish malalignment of the sentence; (5) modified sentences. 2, knowledge classification (1) the common conjunctions coordinate: . . 一面 . 1, to examine the topic, identify problems as

22、sociated with two 2, analysis, alternative question two is in direct proportion to the amount of the associated relationship is inversely proportional relationship. 3, and set unknown, column proportion type 4, and solutions proportion type 5, and test, wrote answer language plenary, and subject: ap

23、plication problem (1)-simple application problem and composite application problem review content simple application problem composite application problem answers application problem of general steps 1, and figure out meaning-through examines the, find known conditions and by seeking problem 2, and

24、analysis number relationship-analysis known conditions Zhijian, and conditions and problem Zhijian of relationship, determine problem-solving method and problem-solving steps. 3, and column type calculation-lists formula, is out subdivisions 4, and test, and wrote answer-check, and checking, and wro

25、te answers typical application problem 13, and subject: application problem (3)-column equation solutions application problem review content overview problem-solving steps 1, and figure out meaning, find by seeking of unknown and x said 2, and according to meaning find equivalent relationship, lists

26、 Equation 3, and solutions equation 4, and test, and wrote answers according to meaning find equivalent relationship of common method 1 , And according to common of number relationship type, established equivalent relationship 2, and according to has learn had of calculation formula, 3, and accordin

27、g to problem in the of focus described sentence from overall Shang determine basic of equivalent relationship 4, and using segment figure, and list method, method analysis number设置选课时间模块录入信息模块 开设课程模块编辑程序时间地点模块评分模块查看课程模块 选课和锁定模块第 2 章 课题的可行性分析2.1 可行性分析在系统开发过程中进行可行性分析，对于保证资源的合理使用，避免浪费和一些不必要的失败，都是十分重要的。

28、1. 目标和方案的可行性：如果采用人工操作的方式，不仅操作不方便，耗费人力，而且还容易出现错误。所以当前迫切需要一个计算机化的管理信息系统。开发这个系统，能更好地满足学校要求，使学校的各种信息管理实现无纸化，高效化。2. 技术方面的可行性：本系统是用 ASP 结合 SqlServer2000 数据库来开发的一个信息管理软件。ASP 在数据库方面的特长显得尤为突出：适用于多种数据库结构，结合客户端的 html 能够创建出完美漂亮且高效的软件系统。3. 管理方面的可行性：作为学校教务信息管理系统之一的选课系统，对它的管理也是很方便的，只需要先将系统配置运行起来，然后分配好系统的三个主要角色，就可以

29、投入实际的院校中进行使用。根据以上几方面的可行性分析，可以得出结论：开发该学生选课管理系统是可以进行的。系统介绍，如图：用户登录身份验证模块choose the correct meaning; (4) to correct the typos; (5) so the child write words (ABAB, and AABB); (6) in accordance with written words; (7) the complete word, and explain the meaning of the word; (8) collocation; (9) make sente

30、nces with the word; (10) the written language as required. (C) the main sentence types (1) complete sentences; (2) write down the meaning of a sentence or expression of thoughts and feelings; (3) write sentences as required; (4) finish malalignment of the sentence; (5) modified sentences. 2, knowled

31、ge classification (1) the common conjunctions coordinate: . . 一面 . 1, to examine the topic, identify problems associated with two 2, analysis, alternative question two is in direct proportion to the amount of the associated relationship is inversely proportional relationship. 3, and set unknown, col

32、umn proportion type 4, and solutions proportion type 5, and test, wrote answer language plenary, and subject: application problem (1)-simple application problem and composite application problem review content simple application problem composite application problem answers application problem of ge

33、neral steps 1, and figure out meaning-through examines the, find known conditions and by seeking problem 2, and analysis number relationship-analysis known conditions Zhijian, and conditions and problem Zhijian of relationship, determine problem-solving method and problem-solving steps. 3, and colum

34、n type calculation-lists formula, is out subdivisions 4, and test, and wrote answer-check, and checking, and wrote answers typical application problem 13, and subject: application problem (3)-column equation solutions application problem review content overview problem-solving steps 1, and figure ou

35、t meaning, find by seeking of unknown and x said 2, and according to meaning find equivalent relationship, lists Equation 3, and solutions equation 4, and test, and wrote answers according to meaning find equivalent relationship of common method 1 , And according to common of number relationship typ

36、e, established equivalent relationship 2, and according to has learn had of calculation formula, 3, and according to problem in the of focus described sentence from overall Shang determine basic of equivalent relationship 4, and using segment figure, and list method, method analysis number学生选课管理系统 用

37、户系统管理员录入的选课信息录入的用户信息查询的用户信息成绩信息选课方案建议选课信息2.2 数据字典数据流字典编号 数据流名 来源 组成 去向 备注L01 用户信息 S1 系统管理员 P1 提供选课方案L02 成绩信息 S1 系统管理员 P4 成绩查询L03 成绩清单 P4 成绩查询 S2 用户L04 成绩信息 P4 成绩查询 D3 成绩记录L05 选课方案 P1 提供方案 D1 选课记录L06 选课方案 D1 选课记录 P1 提供方案L07 选课方案建议 P1 提供方案 S2 用户L08 选课信息 S2 用户 P2 处理选课L09 更新的选课信息 S2 用户 P3 修改选课L10 选课信息 P

38、2 处理选课 D2 选课信息L11 选课信息 D2 选课信息 P2 处理选课L12 更新的选课信息 P3 修改选课 D2 选课信息L13 更新的选课信息 D2 选课信息 P3 修改选课L14 更新的选课信息 S1 系统管理员 P3 修改选课数据存储字典编号 数据存储名 输入数据流 输出数据流 内容 备注D1 选课方案 L05 选课方案 L06 选课方案D2 选课信息 L10 选课信息 L11 选课信息数据处理字典choose the correct meaning; (4) to correct the typos; (5) so the child write words (ABAB, and AABB); (6) in accordance with