RS TU V W XY U Z RS TU V W XY U Z RS TU V W XY U Z RS TU V W XY U Z

 103      





       F9602^

          2 ^{                                      } Sybase ^!!!!SQL Server ^{        } )






 ________________

                      ! "# $ % & '(  ) *

+,   -# . / 021

3  465 7 89  : "; <= > ?@ A=  B /

100 ⁰¹

?@ A= C D E  F GH IJ KL IM   N O P Q

P Q

P Q

P Q  

 RS TU V W XY U Z

RS TU V W XY U Z

RS TU V W XY U Z

RS TU V W XY U Z\[

[[[ ']   ^

_5 `a b c  de fg hi . j 01

'k M   N c l m     J n  o p > qr s tJ  1

3u vw xy z{ |} ~ € ‚ƒ

xy z{ |} ~ € ‚ƒ

xy z{ |} ~ € ‚ƒ

xy 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 6 7 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 & N O P Q}

R S TUV(Subquery)^A6^

  2 3 W X Y  Z [  ;\Supplier A^]@\Supplier B^{] Z [ D}

B  Z [ 6^ _ `a b c  TUVd
  UVefB R A7^

SELECT * FROM SupplierA WHERE EXISTS ( SELECT * FROM SupplierB WHERE ItemName= SupplierA.ItemName AND Price > SupplierA.Price )

SupplierA SupplierB

ItemName Price ItemName Price

LG^{g h i} 19,900 ^{j k l m h i} 14,880

n o g h i 19,900 ^{p qr g h i} 19,900

0s g h i 18,900 ^{t ? g h i} 35,990

u v g h i 24,750 ^{u v g h i} 24,000

j k l m h i 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^

" " " "  ))))

ª  2 3 W « ¬ ­ {  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}computeTÆCDÇUVefÈÉÊËÌ [ Í Î Ï L Í Î 6‚Ð „ (group)^{6Ñ 5 ef`
J K QÒ Ó L Ô  6­ {  2 [ º}

Sybase ⁶ select ^{Ä Å J Œ m … € Õ ‚Œ m ­ { 6Œ m ° ± ²­ { ³  ²­ { µ ¶ »} • / compute^{TƇ‚Œ m d Ö  » × Œ m  µ  Ø Ù`}12^