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
Top Related