Download - Basic Database lecture 1
-
8/10/2019 Basic Database lecture 1
1/18
@ JL SM V
J 2011
14 . 11
.
.
@ JL SM V24 . 11
.
. /
-
8/10/2019 Basic Database lecture 1
2/18
-
8/10/2019 Basic Database lecture 1
3/18
1) ( )
A ( . .
, , )E .
@ JL SM V54 . 11
( )
( , , , )
1) ( )
139 L 30.00 1623
@ JL SM V64 . 11
248 F 75.00 1623258 M 87.00 1623416 B 100.00 1369426 B 155.00 1369765 300.00 1502
-
8/10/2019 Basic Database lecture 1
4/18
T .
M
2)
@ JL SM V74 . 11
T I : T
A
F
A ( ) ( )
3)
@ JL SM V84 . 11
T T
W # ( )
P
R #
P
R ( )
-
8/10/2019 Basic Database lecture 1
5/18
F E :
3)
@ JL SM V94 . 11
( , , , #)( , , )
. ,
( ).
EXAMPLE
RDU
PNA
3)
@ JL SM V104 . 11
P #
T ( P P ) I , PRODUCER BEFORE PRODUCTS I
, PRODUCTS BEFORE PRODUCER
-
8/10/2019 Basic Database lecture 1
6/18
T ( ) SAME DOMAINE
.
3)
@ JL SM V114 . 11
T : NULL , MUST
T REFERENTIAL INTEGRITYCONSTRAINT
E
. I :
4)
@ JL SM V124 . 11
A ( ) A ( : DDMMYYY )
-
8/10/2019 Basic Database lecture 1
7/18
( )F , ONE
.
4)
@ JL SM V134 . 11
E : D = , , , .T
..
1)
2)
@ JL SM V144 . 11
4)
5)
-
8/10/2019 Basic Database lecture 1
8/18
D D L (DDL)
(C , ( ), : , ,)
1)
@ JL SM V154 . 11
(I , , )
D Q L (DQL)
( , , )D C L (DCL)
( , ).
DDL .
C / :CREATE DATABASE DROP DATABASE
1)
@ JL SM V164 . 11
C / :CREATE TABLE DROP TABLE.
M : ALTER TABLE.
-
8/10/2019 Basic Database lecture 1
9/18
C :CREATE TABLE.
1)
@ JL SM V174 . 11
(3), ,
(9,2)
);
DDL ( ).
1)
@ JL SM V184 . 11
M ( ) :
D ( ) :
-
8/10/2019 Basic Database lecture 1
10/18
E ( , , , , , )
1)
@ JL SM V194 . 11
, , , ,, )
F ( ). I : SELECT
GRANT
G ( )
1)
@ JL SM V204 . 11
, , , ( , , )
REVOKE
R ( , , )
-
8/10/2019 Basic Database lecture 1
11/18
S ( . . ).A
( ).
2)
@ JL SM V214 . 11
R UNARY BINARY
S , , , , .
( )
E : I PRODUCTS
155 .
139 L 30.00 1623
2)
@ JL SM V224 . 11
248 F 75.00 1623258 M 87.00 1623416 B 100.00 1369426 B 155.00 1369765 300.00 1502
426 B 155.00 1369765 T 300.00 1502
S : R1 = >=155 (PRODUCTS)
-
8/10/2019 Basic Database lecture 1
12/18
( )P 1, 2, 3, 4, (R) R
1, 2, 3, .T , , ( )
2)
@ JL SM V234 . 11
PRODUCTS
139 L 248 F 258 M 416 B 426 B
765
R2 = , (PRODUCTS)
R1 = >=155
(PRODUCTS)R2 = , (R1)
2)
+
@ JL SM V244 . 11
2
426 B 765 T
139 L 30.00 1623248 F 75.00 1623258 M 87.00 1623416 B 100.00 1369426 B 155.00 1369765 300.00 1502
-
8/10/2019 Basic Database lecture 1
13/18
( )T
. T R S : R S R
2)
@ JL SM V254 . 11
S.
G R=PRODUCTS S =PRODUCERSP N
1369 L
1370 ' L
1502 T
1623 D
B !!!!
139 L 30.00 1623
248 F 75.00 1623258 M 87.00 1623416 B 100.00 1369426 B 155.00 1369765 300.00 1502
P N
1369 L 139 L 30.00 1623
1369 L 248 F 75.00 1623
1369 L 258 M 87.00 1623
1369 L 416 B 100.00 1369
1369 L 426 B 155.00 13691369 L 765 300.00 1502
1370 ' L 139 L 30.00 1623
@ JL SM V264 . 11
1370 ' L 248 F 75.00 1623
1370 ' L 258 M 87.00 1623
1370 ' L 416 B 100.00 1369
1370 ' L 426 B 155.00 1369
1370 ' L 765 300.00 1502
1502 139 L 30.00 1623
1502 248 F 75.00 1623
1502 258 M 87.00 1623
1502 416 B 100.00 1369
1502 426 B 155.00 1369
1502 765 300.00 1502
1623 D 139 L 30.00 1623
1623 D 248 F 75.00 1623
1623 D 258 M 87.00 1623
-
8/10/2019 Basic Database lecture 1
14/18
R1= PRODUCTS PRODUCERR2 = = (R1)
P N R U
1369 L 416 100.00 1369
+
2)
@ JL SM V274 . 11
1369 L 426 155.00 13691502 765 300.00 15021623 D 139 30.00 16231623 D 248 F 75.00 1623
1623 D 258 M 87.00 1623
: , 2 (
PRODUCTS PRODUCER)
R= P ( ) P ( )
2 .
( )
2)
@ JL SM V284 . 11
T
B
J , :
-
8/10/2019 Basic Database lecture 1
15/18
416 100.00 426 155.00
2) +
W , ?
@ JL SM V294 . 11
R1= P ( ) P ( )R2= , , (R1)
E .
765 300.00 139 30.00 248 75.00 258 87.00
+
2)
W A ?
P N R U
1623 D 139 30.00 16231623 D 248 F 75.00 1623
@ JL SM V304 . 11
R1= P ( ) P ( )R2 = P . ="A " (R1)
O A .
1623 D 258 M 87.00 1623
-
8/10/2019 Basic Database lecture 1
16/18
W 155 ,
A ?
2)
@ JL SM V314 . 11
.C : :
, ,
( )
I , =>
P >=155: .
R1 = >=155 (PRODUCTS)
2)
@ JL SM V324 . 11
P A : +
R2= P ( ) P ( )R3 = P . ="A " (R2)
B :R4= , (R1)
R5= , (R3) U :
R6 = R4 R5
-
8/10/2019 Basic Database lecture 1
17/18
L , .T R S.
D
2)
@ JL SM V334 . 11
NEGATION.
W .
W ORDER LINES ( 1).
B :
2)
@ JL SM V344 . 11
R1 = (PRODUCTS).
B :R2 = (ORDER LINES)
B :R3 = R1 R2
-
8/10/2019 Basic Database lecture 1
18/18
W .W ORDER LINES
( 1).
2)
@ JL SM V354 . 11
B :R1 = (PRODUCTS).
B :R2 = (ORDER LINES)
B :R3 = R1 R2
2) 1