目录
1 系统概述 ....................................................................................................................................................................2
1.1 开发目的 .........................................................................................................................................................2
1.2 开发任务 .........................................................................................................................................................2
1.3 开发环境 .........................................................................................................................................................2
2 需求分析 ....................................................................................................................................................................2
2.1 系统需求 .........................................................................................................................................................3
2.2 实现目标 .........................................................................................................................................................3
2.3 功能设计 .........................................................................................................................................................3
2.4 数据需求 .........................................................................................................................................................3
2.5 数据字典 .........................................................................................................................................................4
3 概念结构设计 ............................................................................................................................................................5
3.1 E-R 图...............................................................................................................................................................5
4 逻辑结构设计 ............................................................................................................................................................7
4.1 关系模型 .........................................................................................................................................................7
4.2 细化表结构 .....................................................................................................................................................8
5 物理结构设计 ............................................................................................................................................................9
5.1 数据库设置 .....................................................................................................................................................9
6 数据库实施 ................................................................................................................................................................9
6.1 创建数据库 .....................................................................................................................................................9
6.2 建立基本表 ...................................................................................................................................................10
7 数据库的运行和维护 .............................................................................................................................................11
7.1 数据增加 .......................................................................................................................................................11
7.2 数据删除 .......................................................................................................................................................11
7.3 数据修改 .......................................................................................................................................................11
7.4 数据排序 .......................................................................................................................................................12
7.5 数据查询 .......................................................................................................................................................12
7.6 使用 python 操作..........................................................................................................................................12
8 管理系统的运行展示..............................................................................................................................................14
8.1 登录页面 .......................................................................................................................................................14
8.2 增加操作 .......................................................................................................................................................15
8.3 查询操作 .......................................................................................................................................................18
8.4 修改操作 .......................................................................................................................................................20
8.5 删除操作 .......................................................................................................................................................21
8.6 退出界面 .......................................................................................................................................................22
参考文献 ......................................................................................................................................................................22
附录一 ..........................................................................................................................................................................23