数据库系统原理     

目录

1 

   

系统概述

 

                                                                                                                                           

 

 

..........................................................................................................................................

 

 2  

1.1 

   

系统开发前景

 

                                                                                                                                

 

 

...............................................................................................................................

 

 2  

1.2 

   

项目原因阐述

 

                                                                                                                        

 

 

.......................................................................................................................

 

 2  

1.3 

   

项目目标与任务

 

                                                                                                                    

 

 

...................................................................................................................

 

 2  

1.4 

   

开发环境与技术

 

                                                                                                                    

 

 

...................................................................................................................

 

 2  

2 

   

系统分析

 

                                                                                                                                           

 

 

..........................................................................................................................................

 

 3  

2.1

       

图书馆管理系统需求分析

 

                                                                                                    

 

 

...................................................................................................

 

 3  

2.2 

   

基础信息维护

 

                                                                                                                        

 

 

.......................................................................................................................

 

 3  

2.3 

   

读者管理

 

                                                                                                                                

 

 

...............................................................................................................................

 

 4  

2.4 

   

图书管理

 

                                                                                                                                

 

 

...............................................................................................................................

 

 5  

2.5 

   

期刊管理

 

                                                                                                                                

 

 

...............................................................................................................................

 

 6  

2.6 

   

图书流通管理

 

                                                                                                                        

 

 

.......................................................................................................................

 

 6  

2.7 

   

期刊流通管理

 

                                                                                                                        

 

 

.......................................................................................................................

 

 7  

2.8 

   

统计分析管理

 

                                                                                                                        

 

 

.......................................................................................................................

 

 7  

3      

数据库设计阶段

 

                                                                                                                               

 

 

..............................................................................................................................

 

 8  

3.1 

   

图书馆系统数据库分析

 

                                                                                                        

 

 

.......................................................................................................

 

 8  

3.2 

   

图书馆实现功能

 

                                                                                                                    

 

 

...................................................................................................................

 

 8  

3.3 

   

图书管理系统

 

 

    E-R

 

     

图

                                                                                                              

 

 

...........................................................................................................

 

 9  

3.4 

   

数据库设计

 

                                                                                                                          

 

 

.........................................................................................................................

 

 13

   

3.5 

   

系统流程图

 

                                                                                                                          

 

 

.........................................................................................................................

 

 14

   

4 

   

创建数据库

 

                                                                                                                                     

 

 

....................................................................................................................................

 

 15

   

4.1 

   

创建读者信息表

 

                                                                                                                  

 

 

.................................................................................................................

 

 15

   

4.2 

   

创建图书信息表

 

                                                                                                                  

 

 

.................................................................................................................

 

 16

   

4.3 

   

创建图书借阅表

 

                                                                                                                  

 

 

.................................................................................................................

 

 17

   

 4.5 

 

 

创建期刊表

 

                                                                                                                         

 

 

........................................................................................................................

 

 19

   

4.6 

   

创建主键及外键等表约束

 

                                                                                                  

 

 

.................................................................................................

 

 21

   

4.7 

   

创建存储过程

 

                                                                                                                      

 

 

.....................................................................................................................

 

 27

   

6 

   

设计总结

 

                                                                                                                                         

 

 

........................................................................................................................................

 

 35