數(shù)據(jù)庫(kù)圖書管理系統(tǒng)(含代碼)

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

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

2..............................................................................................................................

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

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

4

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

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

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

7..................................................................................................................................

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

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

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

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

13.................................................................................................................. ................................................................................ ......................................................

17..........................................................

17一．需求描述和系統(tǒng)邊界

二．需求分析1.業(yè)務(wù)需求2.功能需求及數(shù)據(jù)需求分析

3.業(yè)務(wù)規(guī)則分析

三．實(shí)體集及屬性

E-R

E-R

E-R

E-R

四．聯(lián)系集及

E-R

圖

n

m

n

n

五．邏輯數(shù)據(jù)庫(kù)設(shè)計(jì)

六．?dāng)?shù)據(jù)庫(kù)編程1.創(chuàng)建表

CREATE TABLE

PRIMARY

KEY

CREATE TABLE

,

), , ),

PRIMARY

KEY),

KEY

REFERENCES

CREATE TABLE

PRIMARY

KEY

CREATE TABLE

,

,

,

),

,

PRIMARY

KEY

CREATE TABLE

PRIMARY

KEY,,),

KEY

REFERENCES),

KEYREFERENCES),

KEY

REFERENCES),

CREATE TABLE

,

PRIMARY

KEY,),

KEY

REFERENCES),

CREATE TABLE

PRIMARY

KEY,,),

KEY

REFERENCES),

KEY

REFERENCES),

KEY

REFERENCES2.創(chuàng)建觸發(fā)器

If

=+

=end3.管理員操作INSERT

DELETE

INSERT

DELETE

INSERT

DELETE

4.讀者操作INSERT

,

VALUES

,

DELETE

WHERE

SET

=#

,

SELECT

*

WHERE

bookNo=#bookNo

bookName=#bookName5.

管理員對(duì)借閱關(guān)系的操作

INSERT

=#

=

=#

=#

’0’)

SET

INSERT

SET

WHERE

=#

=#

=#七．代碼實(shí)現(xiàn)1．輸入數(shù)據(jù)設(shè)計(jì)INSERT

,VALUES,INSERT

,VALUES,INSERT

,VALUES,INSERT

,VALUES,INSERT

,

,

,

,

VALUES,,,,INSERT

,

,

,

,

,,

,

,VALUES,,,,,,,,INSERT

,

,,

,

,,

VALUES,,,,,,INSERT

,

,,

,

,,

VALUES,,,,,,INSERT

,

,,

,

,,

VALUES,,,,,,INSERT

,

,,

,

,,

VALUES,,,,,,INSERT

,

,,

,

,,

VALUES,,,,,,_INSERT

,

,,

VALUES,,,INSERT

,

,

,

VALUES,,,INSERT

, ,,,

,VALUES,,,,,INSERT

,

,

,

VALUES,,,

2.完成借閱、續(xù)借、歸還的操作設(shè)計(jì)假設(shè)讀者想借書籍名為《JAVA》且不知道bookNo

=

INSERT

,

,,,

,VALUES,,,,,

SET

=WHERE =

SET

=+WHERE

=INSERT

,

,

,

VALUES,,,

end

SELECT

WHER