4.1 4.2 4.3 4.4 4.5 SQL4

84~6

4.1 4.1.1

Data)(Data Processing) :

Type)value ,:

4.1 Database,DB)

4.1.1

4.1 DBMS)

4.1.1 (Database Management System,DBMS) : ,.

4.1 DBMS)

4.1.1 (Database Management System,DBMS) DBMS : Foxpro Access DBMS: ,ORACLEPowerBuilderSQLServer

4.1 DBS)

4.1.1 (Database SystemDBS) (DB) (DBMS) (Database Administrator,DBA): : : DBS(

4.1 4.1.2 )

980120980219980320983918

4.1 4.1.2

4.1

4.1.3 3(1 50123 4

4.1

4.1.3 3(25060

4.1

4.1.3 3(360

4.1 2.

1 4.1.3 2

4.1 2.

1 4.1.3 23,

4.1 2.

1 4.1.3 234: : : 5

4.1 1.

4.1.4

( ()()

4.1 1.

4.1.4 :

4.1 2.

4.1.4 (1) .(2)

4.1 2.

4.1.4 DBMS

1______ A. B. C. D. 2______ A. B. C. D. 3______ A. B. C. D. 4______ A. B. C. D. BCAA

5 ______ A. B. C. D. 6______ A. DBF B. C. D. 7______ A. B. C. D. ACA

(8) ___(05.4) A. B. C. D.(9) _____ A. B. C. D. (10)( ) A) B) C) D)DAC

1.______2. _____. (11) () A) B) C) D) B

4.2

4.2.1

: :

4.2

4.2.1

4.2

2.

4.2.1

4.2 E-R2.

4.2.1

200510101 07/05/1987200510102 02/23/1988 200510103 01/19/1987

4.2 E-R2.

4.2.1

DBMS

4.2

4.2.3

E-R,E-R

4.2

4.2.3 E-RE-R

1.ER (1)(Entity) ,(20061001, 1988-5-6)(2)(Attribute)

4.2

4.2.2 E-RE-R

1.ER (3) .,.

(4) ,0150

4.2

4.2.2 E-RE-R

1.ER (5)Entity Type (6)Entity Set:

4.2

4.2.2 E-RE-R

1.ER (7)

4.2

4.2.2 E-RE-R

1.ER (7) 1:1ABBA 1:mABBA m:nABBA

4.2

4.2.2 E-RE-R

2. ER ERER ():,(): ,,

4.2

4.2.2 E-RE-R

2. ER(1) :(2) (3) (4) (): .(5) : ,(1:11:n n:m)

11E-R 11

1nE-R n1

mnE-R nm

E-R

ER :ER,,,ERER,ER,,,ER,E-R

ER1. ,,,,,,E-R()

ER1

ER2mn11nmn

ER2. ,,,,,.E-R

ER1 21nnmn1n1m

ER1nmnmnpn11n1n1n1p1n1 p111n

ER3. ,,,,,E-R

4.3 4.3.1

()()5

980120980219980320983918

4.3 4.3.1

() , nnn (n)n(), .

4.3 4.3.1 (Table) (Field) (Row) (Key) 123

4.3 4.3.1

1

9901209902189903119990421981/2/28

22

990120990218990319990420

3

990120990218990319990420

990120990218990319990420

4

990120990218990319990420990120

5

990120990218990319990420

990420990120990319990218

6

4.3 4.3.2 1.()

,2.

4.3 4.3.2

2.

4.3 4.3.2

2.

(1)U R RR()RST=RUSS R

4.3 4.3.2

2.

(2) RRSRS RST=RSR-S

4.3 4.3.2

2.

(3): R SRS RST=R SR S

(1)U R R R()(2) RRSRS (3): R SRS

RSRS A(R-S) S B R (R-S)CS-(R-S) DR-(R-S)D

RR-ST=R(R-S)128070279 1 80

5.3 5.3.2

2.

(4)() nnRmmSpq(RSRSn+mpqRS

5.3 5.3.2

2.

(5)() x (R) ={ t [X] | t R } XR

()

4.3 4.3.2

2.

(6)() : F (R) ={t | t R F(t)=} F

()

18= 18 =()

0702112041807021130318

19 , (< 19 )

4.3 4.3.2

2.

(7):

,:

RSR S

ABCa1b15a1b26a2b38a2b412

BEb13b27b310b32b52

ABCEa1b153a1b267a2b3810a2b382

4.3 4.3.2

1.1 2.(), 3.

ABC

4.3 4.3.3 E-R

E-R

E-RE-R

4.3 4.3.3 E-R

E-RE-R (1)

4.3 4.3.3 E-R

E-RE-R : E-R

4.3 4.3.3 E-R

E-RE-R : E-R 11(,,) (,)

4.3 4.3.3 E-R

E-RE-R :(,,) (,)(1)

4.3 4.3.3 E-R

E-RE-R (2)1n(,,) (,,)

4.3 4.3.3 E-R

E-RE-R (3) mn

4.3 4.3.4

,RDB

4.3 4.3.4

4.3 4.3.4

1. (1) (

4.3 4.3.4 1.(2) AR,S,AR () () (1)

9901990299039904

C01C02C03C04100708060

99019901990299049904C01C02C04C04C039080908570

(R2)(R1)

980198029803980498050101

0203

01020304

RABCSDA10RASDA. SA.12 B.2NULLC.33 D.44D

4.3 4.3.4

1.(2)(1)(3) 0100(0-150) (13

4.3 4.3.4

2.

4.3 4.3.4

2.: X X->Y

4.3 4.3.4

3. E.F.CoddCodd(Normal Form)(1NF)1NF(2NF)(3NF)CoddBoyceBC(BCNF)(4NF)(5NF)

4.3 4.3.4

3.

1. ______ A. B. C. D. 2. ,_____. A. B. C. D. 3. _____. A. B. C. D. -4. ______ A. B. C. D. BCDA

5. ______ A. B. C. D. 6. ______ A. B. C. D. 7. ______ A. B. C. D. 8. E-R____ A. B. C. D. BBDB

9. ARANULL, A. B. C. D. 10. ,____RS . A. R S B. R S C. R S D. R S11. ,___ A. E-R B. C. D. 12. fR______ A. R|X|R B. R|X|R C. f(R) D. f(R) ijADAC

13. A. 1 B. 2 C. 3 D. 14. ____. A. B. C. D. 15. SRS R A. B. C. D. DCA

16. ( ) A) B) C) D) 17. A B C D CD

1. ______ 2. ______ 3. ______ 4. ______5. ______ 1.1N1:n 2. 3. 4.5. DBMS

6.______ 7. ERER ______

6. 7.

8. ______9. R4,5,S5,6,TRS,T=RS,T____, ____.10. ____ ____.11. ____.12.ERER______.8. 9. 930 10. 11. 12. 3

4.4

4.4

(DBMS)

4.4

(DBMS)

4.4

E-RDBMS DBMS

4.4

1.1 . 2

4.4

2.1

4.4

2.2 ER (-) ER

4.4

2.3 (ER) ;E-R; ,,,,E-R

4.4

2.3 (ER) () 3

4.4

2.3 (ER)

4.4

3. ERRDBMS

4.4

4.1DBA

4.4

4.2

4.4

4.3 DBA4 5 DBA

1. ______ A. B. C. D. 2. 3___A. B. C. D. 3. E-R A. B. C. D. ABB

4. A. B. C. D. 5.E-R A. B. C. D. 6.E-R______. A. B. C. D. 7 . A. ER B. C. D.8 .DBA( ) A. B. C. D.CABAC

1.6______2. ______3. ______4.E-RE-RE-RE-R

20039802003 2003980

: :: Electronic Data ProcessingEDP(1) , .(2) .(3)

*************************12 3 4 DBMS : : :

(: ,(): ():

BCAA

ACA

DA

DA

*******************************DBMS