AP6-AA2-Ev2-Construcción de Elementos de Programación Para El Proyecto de Formación LARRY SALDARRIAGA

AP6-AA2-Ev2-Construcción de elementos de programación para el proyecto de formación

LARRY STEVEN SALDARRIAGA ANDRADE

SENA ANALISIS Y DESARROLLO DESARROLLO DE SISTEMAS SIS TEMAS DE INFORMACIÓN

LENGUAJE TRANSACCIONAL DB Una vez realizado lo e!er"i"io de #r$"%i"a e&#'e%o en el la(ora%orio la(ora%orio ) validado validado #or el %'%or %*"ni"o+ e de(e "on"er%ar 'n en"'en%ro in"r,ni"o in"r,ni"o "on el %'%or %*"ni"o ) el e-'i#o de #ro)e"%o #ara de%er.inar lo ele.en%o de #ro/ra.a"i,n a "on%r'ir #ara el i%e.a de in0or.a"i,n+ e%o de(en ela(orar e en el SGBD ele""ionado1 E%o ele.en%o de(en "'.#lir "on la i/'ien%e e#e"i0i"a"ione2 3ara "ada ele.en%o e de(e iden%i0i"ar a -'e re-'eri.ien%o 0'n"ional o "ao de 'o a#o)an1 De(en "on%r'ire .4ni.o 56 #ro"edi.ien%o al.a"enado1 De(en "on%r'ire .4ni.o 7 0'n"ione1 De(en "on%r'ire .4ni.o 7 deen"adenadore1 Lo an%eriore ele.en%o de(en er #reen%ado en 'n do"'.en%o donde e e#e"i0i-'en lo 4%e. de%er.inado an%erior.en%e+ el o(!e%ivo de "ada 'no de lo ele.en%o #ro#'e%o+ lo ",di/o "orre#ondien%e a lo ele.en%o #ro/ra.ado ) lo re'l%ado de la e!e"'"i,n o(re la (ae de da%o del #ro)e"%o1 51 3ROC 3ROCED EDIM IMIE IENT NTOS OS 5151 3ro"edi.ien%o Ai%en%eAd.ini%ra%ivo

deli.i%er 8

LENGUAJE TRANSACCIONAL DB "rea%e #ro"ed're iner%arai%en%e 9in idai%en%e in%956:+ in #ro0eion var";ar 9576:+ in "'ro var";ar 9576:+ in area in% 956:: (e/in iner% in%o ai%en%ead.ini%ra%ivo 9E.#leado1 3ro"edi.ien%o Clien%e

deli.i%er 8 "rea%e #ro"ed're iner%ar"lien%e 9in ideClien%e in%956:+ in no.(re var";ar 9576:+ in a#ellido var";ar 9576:+ in dire""ion var";ar 9576:+in %ele0ono in% 956:+ in "el'lar in% 956:+ in "orreo var";ar 9?7:: (e/in iner% in%o "lien%e 9idClien%e+ CliNo.(re+ CliA#ellido+ CliDire""i,n+ CliTel*0ono+ CliCel'lar+ CliE.ail: val'e 9ideClien%e+ no.(re+ a#ellido+ dire""ion+ %ele0ono+ "el'lar+ "orreo:= end 8

51@1 3ro"edi.ien%o Co.#'%ador LENGUAJE TRANSACCIONAL DB

deli.i%er 8 "rea%e #ro"ed're iner%ar"o.#'%ador 9in ideerial var";ar9?7:+ in ide-'i#o in%956:+ in e"ri%orio TINYINT95:+ in #or%a%il TINYINT95:+ in %odoen'no TINYINT95:+ Board var";ar9?7:+ in #ro"eador var";ar9?7:+ in video var";ar9?7:+ in red var";ar9?7:+ in onido var";ar 9576:+in RAM var";ar9?7:+ in Di"oD'ro var";ar9?7:+ in SO var";ar9?7:: (e/in iner% in%o "o.#'%ador 9E-'i#o
(e/in iner% in%o dire"%or 9E.#leado
LENGUAJE TRANSACCIONAL DB val'e 9iddire"%or+ #ro0eion+ e#e"ializa"ion: = end 8

5171 3ro"edi.ien%o e.#leado

deli.i%er 8

LENGUAJE TRANSACCIONAL DB "rea%e #ro"ed're iner%arE.#leado 9in idee.#leado in% 956:+ in no.(re var";ar9?7:+ in a#ellido var";ar9?7:+ in dire""ion var";ar9?7:+ in "el'lar in%956:+ in %ele0ono in% 956:+ in "orreo var";ar9?7:+ in "ar/o var";ar 9?7:+ in lo/in var";ar 9?7:+ in "lave var";ar 9?7:: (e/in iner% in%o e.#leado 9idE.#leado+ E.#No.(re+ E.#A#ellido+ E.#Dire""ion+ E.#Cel'lar+ E.#Tele0ono+ E.#E.ail+ E.#Car/o+ E.#Lo/in+ E.#3aord: val'e 9idee.#leado+ no.(re+ a#ellido+ dire""ion+ "el'lar+ %ele0ono+ "orreo+ "ar/o+ lo/in+ "lave: = end 8 511 3ro"edi.ien%o e-'i#o

deli.i%er 8 "rea%e #ro"ed're e-'i#o 9in ideE-'i#o in% 956:+ in eriale var";ar 9?7:+ in %i#o var";ar9?7:+ in .ar"a var";ar9?7:+ in .odelo var";ar 9?7:: (e/in iner% in%o e-'i#o 9idE-'i#o+ idSerial+ E-'Ti#o+ E-'Mar"a+ U-'Modelo: val'e 9ideE-'i#o+ eriale+ %i#o+ .ar"a+ .odelo: = end 8

511 3ro"edi.ien%o I.#reora

LENGUAJE TRANSACCIONAL DB

deli.i%er 8 "rea%e #ro"ed're iner%ari.#reora 9in iderial var";ar 9?7:+ in ide-'i#o in% 956:+ in .ono"ro.a%i"a TINYINT95:+ in #oli"ro.a%i"a TINYINT95:+ in #'n%o TINYINT95:+ in %in%a TINYINT95:+ in laer TINYINT95: : (e/in iner% in%o i.#reora 9E-'i#o
end 8

LENGUAJE TRANSACCIONAL DB

511 3ro"edi.ien%o .an%eni.ien%o

deli.i%er 8 "rea%e #ro"ed're iner%ar.an%eni.ien%o 9in id.%%o in% 956:+ in id"lien%e in% 955:+ in "orre"%ivo TINYINT95:+ in #reven%ivo TINYINT 95:+

LENGUAJE TRANSACCIONAL DB in la(ora%orio TINYINT95:+ in do.i"ilio TINYINT95:+ in 0e";aa%en"ion DATETIME 95:+ in 0e";aen%re/a DATETIME95:: (e/in iner% in%o .an%eni.ien%o 9idMan%eni.ien%o+ Clien%e
51561 3ro"edi.ien%o .oni%or

deli.i%er 8 "rea%e #ro"ed're iner%ar.oni%or 9in ideriale var";ar 9>7:+ in ide-'i#o in% 955:+ in #'l/ada in% 955:+ in %i#o var";ar 9?7:: (e/in iner% in%o .oni%or9E-'i#o
end 8

LENGUAJE TRANSACCIONAL DB 51551 3ro"edi.ien%o #roveedor1

deli.i%er 8 "rea%e #ro"ed're iner%ar#roveedor 9in ide#roveedor in% 955:+ in idre#'e%o in% 955:+ in no.(re var";ar 9>6:+ in dire""ion var";ar 9>6:+ in %ele0ono in% 955:+ in "el'lar in% 955:+ in "orreo in% 955:: (e/in iner% in%o .oni%or9id3roveedor+ Re#'e%o
515>1 3ro"edi.ien%o re#'e%o1 deli.i%er 8 "rea%e #ro"ed're iner%arre#'e%o 9in idere#'e%o in% 955:+ in eriale var";ar 9>6:+ in no.(re var";ar 9?7:+ in de"ri#"ion var";ar 9>77:: (e/in

iner% in%o re#'e%o 9idRe#'e%o+ Re#Serial+ Re#No.(re+ Re#De"ri#"ion:

LENGUAJE TRANSACCIONAL DB val'e 9idere#'e%o + eriale + no.(re+ de"ri#"ion:= end 8

515@1 3ro"edi.ien%o re#'e%o

LENGUAJE TRANSACCIONAL DB deli.i%er 8 "rea%e #ro"ed're iner%ar%a(le%a9in ideeriale var";ar 9>7:+ in ide-'i#o in% 955:+ in #'l/ada var";ar 9?7:+ in %a(le%a var";ar 9>77:: (e/in iner% in%o %a(le%a 9ideeriale+ E-'i#o
515?1 3ro"edi.ien%o %*"ni"o

deli.i%er 8 "rea%e #ro"ed're iner%ar%e"ni"o9in ide.#leado in% 955:+ in e%'dio var";ar 9>7:+ in "'ro var";ar 9?7:: (e/in iner% in%o %e"ni"o 9E.#leado
LENGUAJE TRANSACCIONAL DB >1 FUNCIONES >151 M'e%re la #ro0ei,n del dire"%or "on id 55@7

>1>1 M'e%ra 0e";a a%en"i,n ) en%re/a de "lien%e "on id 55?@>65

>1@1 M'e%re lo e-'i#o de .ar"a Sa.'n/1

>1?1 M'e%re la dire""i,n+ %el*0ono+ "el'lar ) "orreo de "lien%e 3edro 3*rez1

LENGUAJE TRANSACCIONAL DB >171 M'e%re el id del in0or.e #roveedore

@1 Deen"adenadore 1 @151 Con%r'ir "lien%e

@1>1 Modi0i"ar Clien%e

@1@1 Borrar "lien%e