目錄

1

概述

.

.......................................................................................................................................?1

1.1

設計背景

.

.........................................................................................................................?1

1.2

研究目的

.

.........................................................................................................................?1

1.3

理論基礎的分析

.

.............................................................................................................?2

1.4

預期結果和意義

.

.............................................................................................................?2

2

需求分析

.

...............................................................................................................................?2

2.1

功能需求

.

.........................................................................................................................?2

2.2

數據流圖

.

.........................................................................................................................?3

2.3

功能模塊圖

.

.....................................................................................................................?4

2.4

系統數據流程圖

.

.............................................................................................................?4

3

概念結構設計

.

.......................................................................................................................?5

3.1

局部

E-R

圖

.

....................................................................................................................?5

3.2

整體

E-R

圖

.

....................................................................................................................?7

4

邏輯結構設計

.

.......................................................................................................................?8

4.1

關系模式

.........................................................................................................................?8

4.2

數據關系圖

.

.....................................................................................................................?9

5

物理結構設計

.

.......................................................................................................................?9

5.1

存儲記錄結構設計

.

.........................................................................................................?9

5.2

創建索引

.

.......................................................................................................................?12

6

數據庫實施

.

.........................................................................................................................?13

6.1

建立數據庫

.

...................................................................................................................?13

6.2

數據表的創建

.

...............................................................................................................?13

6.3

建立存儲過程

.

...............................................................................................................?16

6.4

創建觸發器

.

...................................................................................................................?17

7

數據庫運行和維護

.

.............................................................................................................?19

8

結論

.

.....................................................................................................................................?19