加載中. ..
PDF
103
F9602
2
Sybase
!
!!
!
SQL Server
)
________________
!
" #
$
%
&
'(
)
*
+ ,
-#
.
/
021
3
465
7
8 9
:
" ;
<=
>
?@
A
=
B
/
100
01
?@
A
=
C
D
E
F
G H
I J
KL
I M
N
O
P
Q
P
Q
P
Q
P
Q
RS
T U
V
W
X Y
U
Z
RS
T U
V
W
X Y
U
Z
RS
T U
V
W
X Y
U
Z
RS
T U
V
W
X Y
U
Z[
[
[
[
' ]
^
_
5
`a
b
c
d e
f g
hi
.
j
01
'k
M
N
c
l
m
J
n
o
p
>
qr
s
t
J
1
3 u
vw
x y
z{
| }
~
x y
z{
| }
~
x y
z{
| }
~
x y
z{
| }
~
(
#
qr
)
#
)
M
vw
#
>
L
/
¡
M
9
J
¢
D£
¤
¥ ¦
o
§
¨
©
¢
D
f
g
h
j
10
0
g
L
/
ª«
(
)
* ¬
®
g
¯
vw
°
±²
³
´ 1
µ
¶
·¸
S
¹ º
µ
¶
·¸
S
¹ º
µ
¶
·¸
S
¹ º
µ
¶
·¸
S
¹ º
[
[
[
[
»
¹ º
¼ ½
¾ ¿
ÀÁ
»
¹ º
¼ ½
¾ ¿
ÀÁ
»
¹ º
¼ ½
¾ ¿
ÀÁ
»
¹ º
¼ ½
¾ ¿
ÀÁ
6Â
Â
Â
Â
"#
"#"#
" #
HIPO
(Hierarchical Input Process Output)
6
(Entity Relationship Diagram, ERD)
6
"$
"$"$
" $
! " # $ % &
' ( ) * #
(Agile Development)
7
+ , - ) * #
(eXtreme Programming)
6
"%
"%"%
" %
. / 01 2 3 4 5 67 8 9 : ;< = 2 > ?
(Logical Data Independence)
@2>?
(Physical Data Independence)
AB 9 : CDE F 2 > ? A
12
G
H I
"&
"&"&
" &
J K
MS SQL Server
L./6
T-SQL
M&NOPQ
R S TUV
(Subquery)
A
6
2 3 W X Y Z [ ;
Supplier A
]@
Supplier B
] Z [ D
B Z [ 6^ _ `a b c TUVd UVefB R A
7
SELECT * FROM SupplierA WHERE EXISTS ( SELECT * FROM SupplierB
WHERE ItemName= SupplierA.ItemName AND Price > SupplierA.Price )
SupplierA SupplierB
ItemName Price ItemName Price
LG
ghi
19,900
jklmhi
14,880
noghi
19,900
p qr g h i
19,900
0s g h i
18,900
t?ghi
35,990
uvghi
24,750
uvghi
24,000
jklmhi
14,000
0s g h i
17,500
"
" "
" '
''
'
w * # x - 6y z { | CD}I~qy z
(Top-Down Testing)
CD}Iq~
y z
(Bottom-Up Testing)
I~qy z 6y z - ;y z 6 `
4
Iq~y z 6y z - ;y z 6 `
4
0 l y z - y z x - W y z 6 }/
(Stub)
(Driver)
l y z - R / A
5
"
" "
" (
((
(
" M
(UML)
;
14
¡ ! " ¢ @£ ¤ ¥ /
¡ 6/ ¦
. / Y §
(Use Case Diagram)
4
¨
(Class Diagram)
4
0©
(Sequence Diagram)
4
"
" "
" )
))
)
ª23W«¬{2[
Employee(EmpNum, EmpName, DeptNum, Salary)
® ¯ ° [ { ° ± ² { ³ ² { L ´ m ° ± ² { µ ¶· W
EmpNum
;
primary
key
`
Employee
2[¸¹
CREATE TABLE Employee
(
EmpNum CHAR(12) NOT NULL,
EmpName CHAR(12) NOT NULL,
DeptNum CHAR(4),
Salary MONEY
)
º
SQL
UVU» ¼ ½ ¾ x
3
¼ 6 m m ° ± ¿ À µ ¶²Á µ ¶²Á
à µ ¶`
13
"
" "
" *
**
*
Sybase Transact-SQL select
Ä Å W 6
compute
TÆCDÇUVefÈÉÊËÌ
[ÍÎÏLÍÎ6Ð
(group)
6Ñ 5 ef`J K QÒ Ó L Ô 6 { 2 [ º
Sybase
6
select
Ä Å J m Õ m { 6 m ° ± ² { ³ ² { µ ¶ »
/
compute
TÆ m d Ö » × m µ Ø Ù`
12