Capitulo3

!

"

( -

%& ' *)

+

,

.//01203114

!

$

# $

)

"

#

%

& " !

)

#

CREA TE TA BLE

'(

#

!

"

( *"

+(

, '( %

./ (- -(+

$

% *"

*

%

#

#

0 1 0 1 0

1 1 33 1.67 -/(' 72

5

-,

23 1 4' -5 .6 $/ 23 1 4' -5 .6 $/

' 67 84' -5 .6 $3 1 76-7) ' 67 84' -5 .6 $3 1 76-7)

1 33

6

87) 3 1 9 :() 87) 3 1 9 :() -

31 31

3 3

"

( " #

,

BINA RY 4' -5 .6 $/

' 67 84' -5 .6 $ ( )

0 +. 2 CHAR ACTE R MEMO

#

:;9 69

# NOT NULL 8NULL

" 76-7)

87)

9

,

"

"

"

NULL 9 :() -

"

:;9 69

#

" #

"

)

CONS TRAI NT

)

CONS TRAI NT

0

(962 6 9 6

CREA TE T ABLE

%

&

9(62 9 6

6

0

&

7

(96 7 -

8

"

" ,

#

# # CREA TE TABL E

" 13

* &

"

"

, #

WITH COM PRES SION

* )

(

"

! "

# *" #

;< " )

"

! ;<

*

0 +. 2 CHAR ACTE R

$ WITH C OMPR ESSI ON ' 6

#

(96

"

!

9+ ;< MEMO

&

# &

, " MEMO

#

;<=> MEMO

*

, NOT NUL L "

"

#

" NULL 0

"

;<

! *

"

2

#

DEFA ULT

"

* " DEFA ULT

"

# DEFA ULT

# "

! 6

9+ ;<

" (96 # (

*

#

9(6 ,

"&

* 0

( 2

% CONS TRAI NT

CREA TE T ABLE

#

ALTE R

TABL E CONS TRAI NT FORE IGN

KEY $

NOT /

&

# #

CONS TRAI NT

$

#

$

#

? UNIQ UE PRIM ARY " *

NULL

"

%

( "

*

*

#

,

*

*

TEMP ORAR Y

% ! ;<

*

# .

( * CIF

IdCl ient e

&

"

Clie ntes "

"

9 9

"

6 DEFA ULT?

( (969+ . (

@. A B./ (- -(+ . 0 B B' . ' 7- C / .67 -/(' 7-$ D $/' (/ED E B F G B1 7 . 3 - H-0 I<2 4' -5 .6 $76-7) B FG B.' :- H-0 =2 4' -5 .6 $/ ' 67 76-7) .67 -/(' 7-' .' :)7' ) B9 - H-0 I<2 4' -5 .6 $7) B FG B.$ ' 7- C / 7) 9 :() -JK<<< B F G B - H-0 K<2 4' -5 .6 $7) B FG B$ " - H-0 J<2 4' -5 .6 $7) 9 :() -<
. A 7 P (969+ .

@ 4 * $ " .

,# AB

@( 6

! 6 9+ ;
B

,#

@

# ,

.

@. . 4 *

-,

,#

.

*"

(

+( *"

"

Q N

?

" +(

#

I< !

B FG

"

#

KE Y

& &

* *

?1 : * G( 3

*" *"

7 ,

* #

,

#

R SK *"

&

9+:

*

# ,

#

MEMO 9+-

CONS TRAI NT *" 0

7 ,

*" *"

*" T

2

+(

(

*"

& "

+(

*"

9 9

*"

, +(

#

?

( (969+ . (

@. A B./ (- -(+ . U 0 B B' . ' 7- C / B F G B1 7 . 3 - H-0 I<2 B F G B.' :- H-0 =2 B F G B9 - H-0 I<2 B F G B.$ ' 7- C / B F G B - H-0 K<2 B F G B$ " - H-0 J<2 B F G B$ - H-0 J<2 B F G B- H-0 N<2 B F G B: ,- H-0 N<2 B F G B1 : * ( 3 9(- -' B FG B6 " - H-2B @.

. A 7 P (969+ .

@ 4 * $ " . $ @( 6

,# AB 0 B ,

! 6 9+ ;
Q B I
,#

@

# ,

.

@. . 4 *

.

-,

,#

*"

,

"

? *"

7 * Disa bled Exte nsio ns

,

,

#

"

4 ,

P =>; ? ? W, "

*

*" @

? *

?% ?4 1? *

A

9 , # ? No se pu ede modi fica r el dis eño d e la tab la 'No mbre a rchi vo#t xt'. E sta es u na bas e d e dato s de s ólo l ectu ra

" ?B

#

*"

,

C

*"

#

C

#

TABL E obje to 'NO MBRE #TXT '

El

mot or

*"

,

de

*"

% base de

da tos

M icro soft Jet n o # *" C

pud o

, # CREA TE enc ontr ar el #

, 9

, %

#

*"

#

*"

C

# , $

,

*"

# *"

*"

C

#

"

# *"

C

?

( *"

Date Time Curr ency

,

9 4

*"

,

*

#

?

( (969+ . ( A B./ (- -(+ . U ,0 B FG B' . ' 7- C / B F G B7 - H-0 I<2 B F G B.' :- H-0 =2 B F G B9 - H-0 K<2 B F G B.$ ' 7- C / B F G B - H-0 K<2 B F G B1 : * ( 3 9(- -' B F G B7 - H-2B

@.

@ 4 * $ " . $ @( 6 @

. A 7 P (969+ . ,# AB 0 B ,

*

#

# *"

1 . ,3 . 7 5 A.* A(7 ' : A:, * - ,9 A . NA' . ' 4 *R . JA7 .* 4 *IN . KA.' :.* 4 *N< . ;A9 .* 4 *KN . IA.$ ' 4 *> . >A .* 4 *KN . XAB: * ( B 9 4 *NN . RA7 .* 4 *N<<

9 9

,

P #

*"

(

Deci mal

"

! 6 9+ ;
,#

#

,

./ (- -(+

$ ?

,

.

@. . 4 *

-,

,#

6 & " *

*"

#

*

,

#

/ #

*" # B

"

# #

#

'(

-,

&

?

C

.

" * '(

,

,

" *

*

"

,#

,

Data Sour ce " #

,

,# 0

, #

*

,

*"

*" *"

9 * *

2

,

*

# Gene ral

*

,

CREA TE

#

*

7 ,

*" D

*

(96 ?

#

7

, "

,

,

" " "

"

B

*

D #

JII TEXT LONG TEXT MEMO

CREA TE TABL E

&

7

1 5 * ?

1 5

?

1 5 1 5 1 5

NY(N?ZI<3 0 . N' 7- C /2 NY3 0 . N' 7- C /2 N3 0 . N' 7- C /2

(96 7 6 9+

,

@' '

9

" &

6 9

( 7 P6 9 . ( 7 P6 9 . (

@. 4 * .

,# AG B$ "

NY(N?ZI<3

NY3

%

./ (- -(+ ./ (- -(+ ./ (- -(+

9 9 9

*"

'( ,#

( TABL E

,

?

A

! 6 9+ ;
@7 @7 @

" "

* 9(6

, (96?

"

!

B9 B ,

A.?Q $

ABB H.

Q N, V B FG R
6 0 2 4 * .

* ,( , + , * P0 , B

G ,# B G 6D

+ ,+

+ ,'

,

2

, @. A B./ (- -(+ . 0 B FG B' . ' 7- C / B F G B7 - H-0 I<2 B F G B.' :- H-0 =2 B F G B9 - H-0 K<2 B F G B.$ ' 7- C / B F G B - H-0 K<2 B F G B1 : * ( 3 9(- -' B F G B7 - H-2B @. . @ 4 * . A . -, A . A. , 7 0 2 4 *

-

-,

+ , * P0 B * * B./ (- -(+ B + ,' '

B G + ,+ 2

6D G

@' A B' 7 /-' 7-6 . BN@! # $&

O( ) 0 B FG @ @JIJJJ
&

J;\ R] ' @ JK<J@ 7) 2B

4 * . -, A , 7 0 2 4 * A B' 7 /-' 7-6 . BJ@:& ,. /

O( ) 0 B FG @ @JI=;
'

KI\ X] (@ JK<N@ @

@2B 4 * . -, A , 7 0 2 4 * + , * P0 B * B./ (- -(+ B + ,' ' .

* ,( , + , * P0 , B

+ ,+ 2

B G 6D G

G * + ,+

6D

B G + ,'

,

2

@.

,# .

$ B

0 2

# #

69 6 9

'(

,

&

?

)

"

" %

$

ALTE R TA BLE

# 5

"

&

# #

;<

!

%

#

$

"

(* "

# "

%

&

, (

# (

#

# &

# "

$

ALTE R T ABLE

#

(96

% ! 6

"

,

#

"

?

1 0

23

9 2

( - / -(+ N(99 .6 ) 7 . 4' -5 .6 $76-7) 9 :() -BBO

./

"

0 ?

NO(/.5(/ 0 K<2 BB

"

#

" *

( - / -(+

$

"

9+ ;<

"

( 7

ADD COLU MN B +

#

( - / -(+ (99 .6 ) 7 1 4' -5 .6 $/ ' 67 84' -5 .6 $3 1 76-7) 87) 3 1 9 :() 3 1 3

7 "

ALTE R TABL E

#

(

&

& "

(99 .6 ) 7 ' (

#

" 0 N<2

0 I2?

.6)7- / 0 N
ALTE R TA BLE

ALTE R CO LUMN

$/' (/ED E

*

B ,

+

"

?

( - / -(+ ( - / .6 ) 7 1 4' -5 .6 $/ ' 67 84' -5 .6 $3 1 76-7) 87) 3 1 9 :() 3 1 3

1 0

23

"

( - / -(+

, ?

( - / .6 ) 7

7

-9 :() -

SET

" ,

"

"

SET %

#

" ?

( - / -(+

(" "

(

( - / .6 ) 7

-9 :() -BB! & BB

"

"

&

"

"

(

"

" *

" % DEFA ULT?

1 3 $ "

( - / -(+

(

&

"

(

" "

%

( - / .6 ) 7

-9 :() -

#

"

&

( - / -(+

" ?!

,

*

?

(

( - / .6 ) 7 . $

' 7- C / 9 :() -

,

"

"

" % "

" *

&

#

(96 ( "

"

9(6 NULL

& B

( - / -(+

.

( - / .6 ) 7 9

?

- H-0 K<2

,

% ? #

$ ,

I<

, $

$

%&

" KR #

(96

&

"

9(6

(

* (

"

#

& "

( - / -(+

.

N<

( - / .6 ) 7 ' .

%

(

"

' 9 7-' -E0 N
"

,

%

?

' &

$

"

"

%

FLOA T

&

( - / -(+

:

( - / .6 ) 7 -

&

:

REAL?

/ ( 9 :() -

&

&

6

&

( "

"

&

DEFA ULT 9

" "

5

&

" "

"

"

&

"

<

"

, "

#

,

#

ALTE R TAB LE # ?

$

( - / -(+

& ,

DROP COLU MN

"

9/6$.6 ) 7

?

( - / -(+

-

N9/6$.6 ) 7 .

N

9

#

,

# !

%

(

" &

, ?

@. @ ( - / -(+ @$ @

" .

" (99 .6 ) 7 ' . "

' 7- C /

"

"

$ "

)$9(- . @ @ ( - / -(+

-' .

.

A1 7

.

3

9/6$.6 ) 7 1 7

.

9

3

" #

#

,

SELE CT.. .INT O

# &

*

,

,

7

#

"

5

,

"

#

? ?

.-

1

1

33 ' 7-6

:/6

1 45 / :

3

, "

.-

,

?

1

1

33 ' 7-6

' 7

#"

:/6

1 45 / :

3

,

, ?

.-

1

1

33 ' 7-6

.

:/6

,

' 7

#"

1 45 / :

3

(

,

# *

" *

,

,# (

2

9(-(+(

,

' 7 E/

' 7 EE( ,

IN

& 0 ()

'(

(

,

E

( V 9(-(+( A/ V $49A ,

*

' 7 E.?Q

' 7 EE(

Q +N

(

E

V 9(-(+( A.?Q Q +N V $49A

,

5

6 "

#"

(

/ (

, '( WHER E Fa lse &

*+#,#-

.

"

# WHER E 1= 0

SELE CT.. .INT O

#

* &

'

%

"

#

& ?

& (

#

,

#

SELE CT

# )

"

% F 7 8

$

"

&

(96 (96 7 -

(96?

9 9

/ ( ( ( (969+ /

@( @ @

#

6

A 7 P (969+ / B .-.6)7-0 T2 ( -

+, @ @ @ @

:

W -

/

O

" "

# %

/

:/6

-

NB

"

# , B +,

G .-T' 7-6 -

J:/6

-

NB

/ (

.

/ (

$

(96 7 -?

4 * . .

A -, AB

.-T' 7-6 -

@ @ @

#

+ ,0 ,

7

0 22

J:/6

-

NB

-,

" &

4 *

# #

, (96?

(

9 9 9

(

,

( (969+ . / ( ( (

@. AB @.

.-T' 7-6 1 .

.

.?Q 3' 7 EE1

Q +J

.

B

. A 7 P (969+ .

@ 4 * $ " .

,# AB

@( 6

! 6 9+ ;
Q N

B

,#

@

# ,

/ (

@. . 4 *

(

,

7 /

,#

# " " 69+.

9 9 9

" "

( (969+ . / ( ( (

@.

3 :/6

# AB .-T' 7-6 1 3 :/6 B' 7 EE1 69+.V 9 " A^ " _V B FG B " A7 G " G V B FG B9 A7 *P V B FG B)' 9A V $49A3B

@.

B FG

. A 7 P (969+ .

@ @ @ 4 * $ " . @( 6

AB

,#

(

! 6 9+ ;
Q N

,#

@ , @. . 4 *

/ ( ,#

.

-,

B

?

(

$

%

"

*"

@' '

9

9 9 9

,

(

(96 7 -?

6 9

( 7 P6 9 . ( 7 P6 9 . (

@. @ 4 * .

,# ( AG

B$ " B9 6 0 2 4 * .

* ,(

A

! 6 9+ ;
A.?Q

, + , * P0 ,

B + ,+

G ,# B G 6D

+ ,'

,

2

, @. @ @

#

, .

AB .-' . B' 7 E.?Q B :/6 .

7

' 7-6 . U ,B F G E E- H-V 59/AE EB F G

B

@. . @ 4 * . A . -, A . A. , 7 0 2 4 *

-

+ , * P0 B * B , .

* ,(

-,

*" B

, + , * P0 , B

, B G + ,+ 6D

+ ,'

G + ,+

*" 6D

, B G + ,'

,

2

@.

,# .

0 2

# (

DROP T ABLE

#

0 99 2

,

2

9/6$-(+

1

3

5

6

( TABL E 0 (962

# & & 9

6 9

"

7

(96 7 -

0 9(62

8 "

%

DROP

#

6 9 6

5

(

# 2 $

0

"

2

# -

# DROP TABL E

@ 9/6$-(+

0

$

#

, 9/6$.67 -/(' 7-.

#

:

. .

(

'( DROP TABL E

$

N2

DROP TABL E

#

:

0

#

ALTE R TABL E

@ ( - / -(+

" #

%

#

DROP TABL E

&

*"

%

# *" ).

9

%

*"

( (969+ .

@.

" . A 7 P (969+ .

@

,# .

$ @(

A B$ " B9 0 B ,

A

! 6 A.?Q

$

B2 A B- H-V B

,# 6

@

# ,

@.

%" 7#

&

B9/6$-(+ ,#

1 7

( *" U ,3B

9+ ;
*" ,

#

.

?

9

( (969+ .

@.

" . A 7 P (969+ .

@ 4 * $ " . @( 6

,# AB

! 6 9+ ;
@ ,

B9/6$-(+

@. . 4 *

$

Q

B

,#

# -

1 7

3B

,#

%

(96 7 -

"

,

*

?

@' '

9

9 9

6 9

( 7 P6 9 . ( 7 P6 9 .

@. 4 * .

,# AG B$ " B9 B ,

A

! 6 9+ ;
A.?Q $

6 0 2 4 * .

* ,( , + , * P0 , B

G ,# B G 6D

+ ,+

+ ,'

, @. . @ 4 * . A . - , A B9/6$-(+ 1 . . A. -, , 7 0 2 4 * + , * P0 B * B9/6$-(+ B + ,' .

* ,( , + , * P0 , B

3B

* + ,+ 2

'

B G 6D G

G *

B G

,

2

,

+ ,+

6D

+ ,'

,

2

@.

,# .

0 2

6

& ?

)

8; B

A

#

8;

%

) %B 69G11H.

69G

%B 69G11I.

69G

! 79B ? BJ

"

#

# * 3114 #

9 9

*

)

, -*

"

P *

P

*

E

`