目 录
1.毕设任务概述............................................................ ....... .....3
1.1 软件功能学习..........................................................................................3
1.2 SQL 练习...................................................................................................3
2.软件功能学习.................................................. ....... ....... ......14
2.1 备份....................................................................................................... 15
2.2 用户权限................................................................................................17
3.SQL 练习...............................................................................19
3.1 创建数据库和表....................................................................................19
3.2 表的更新................................................................................................22
3.3 数据查询................................................................................................22
3.4 创建触发器............................................................................................29
3.5 创建并使用自己创建的函数................................................................30
4.应用系统设计.................................................. ....... ....... ......31
4.1 系统设计目标........................................................................................31
4.2 需求分析................................................................................................32