final base datos (2)

7/23/2019 Final Base Datos (2)

1/113

Integrantes:

IDAD:ctica todos los conocimientos adquiridos durante mi formacin profesional para mi b

Gallardo Cerna, Luis Alberto

Garca Zrate, Richard

Lpez Quito, Augusto


2/113

#$

#$

#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+CARR&RA )ARA G&$*& Q#& *RAA!A

A'& (& (A*+'

#$

MPR SA D TRANSPORT S S TRAMI SAC

CONT NIDO

Presentacin..................................................................................................................5

La Empresa................................................................................................................6

Nombre de la Empresa................................................................................6

Representante Legal...................................................................................6

Direccin..................................................................................................... 6

Rubro...........................................................................................................6

Descripcin de la Empresa..........................................................................7

Misin.......................................................................................................7

Visin.......................................................................................................7

Definicin de Procesos de Negocio...................................................................8

Lista de proceso de negocios......................................................................9

Gestin de datos....................................................................................1

Gestin de !lmac"n...............................................................................1

#acturacin............................................................................................ 1

!signacin de cargas.............................................................................1

Descripcin detallada de las acti$idades %ue se reali&a en cada proceso denegocio.....................................................................................................11

Gestin de Datos...................................................................................11

Gestin de !lmac"n...............................................................................1'

#acturacin............................................................................................ 1(

Reglas del negocio basado en la descripcin de las acti$idades de cadaproceso de negocio................................................................................... 1)

Los *onductores.....................................................................................1)

+!,E DE


3/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+

CARR&RA )ARA G&$*& Q#& *RAA!AA'& (& (A*+'

&'&(&)&)******

##'

#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+CARR&RA )ARA G&$*& Q#& *AA!A

A'& (& (A*+'

##'


Las #acturas...........................................................................................1)

Los -edidos............................................................................................ 1)

Los ,olares.............................................................................................1)

Los Repuestos de mantenimiento..........................................................1)

Los Materiales........................................................................................16Los *lientes............................................................................................16

-ro$eedores........................................................................................... 16

Ve/culos................................................................................................16

Identificacin de Entidades...............................................................................17

Lista de las entidades principales 0 sus relaciones desde las reglas denegocio.....................................................................................................17

Diagrama DER Entidad Relacin2 3nicial...................................................14

Lista de atributos 0 -5s %ue describen adecuadamente a las entidades. .

*liente....................................................................................................

Ve/culo.................................................................................................

*onductores...........................................................................................

-ro$eedores........................................................................................... 1

Repuestos.............................................................................................. 1

Materiales..............................................................................................1

3ncidencias.............................................................................................1

Gastos....................................................................................................

,iniestros...............................................................................................

!lbaranes...............................................................................................

,eguros..................................................................................................'

Destinos.................................................................................................'

-edidos..................................................................................................'

ari8as.................................................................................................... '

Diagrama DER.........................................................................................................24

Relaciones entre entidades inclu0e las relaciones de cla$es primarias 08or:neas....................................................................................................)

Diagrama Entidad Relacin !;nado..........................................................6

Diagrama DER E 1#N................................................................'

,EG?ND! #=RM! N=RM!L @ #N.............................................................'

ER*ER! #=RM! N=RM!L @ '#N...............................................................'1


4/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Modelo !sico de Datos....................................................................................... 33

Estructura del modelo 8/sico de datos.......................................................''

Elaboracin de sentencias DDL.................................................................''

3mplementacin de la base de datos........................................................''

Elaboracin de *onsultas ,AL...................................................................''

Elaboracin de ,entencias DML................................................................''

Planificacin...........................................................................................................34

Concl"siones...........................................................................................................35

Recomendaciones.................................................................................................36

Diccionario de datos.............................................................................................38

Ane#os......................................................................................................................68


5/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


)resentacin

ESTIMADO DOCENTE DE C!"SO A'& (& (A*+'-

En c#$%&i$ient' c'n &as (is%'sici'nes esta)&eci(as en e& S*&a)' %ara &a ')tencin (e&a Ca&i+icacin en e& Tra)a,' C'&ecti-' (e &a Esc#e&a (e Inenier*a (e C'$%#tacin /Siste$as en s# %r'ra$a Para ente #e Tra)a,a esta)&ece$'s &a %resentein-estiacin a -#estra c'nsi(eracin / e&e-a(' criteri' e& tra)a,' tit#&a('P"OECTO DE MODEAMIENTO DE ASE DE DATOS DE !NA EMP"ESA DET"ANSPO"TES DE "IDOS.

!na -e e9a$ina('s s#$aria$ente e& c'nce%t' (e ase (e Dat's / s#sC'rres%'n(ientes caracter*sticas :a/ #e (iriir &a atencin a &'s as%ect's #e enc'ncret' e& A($inistra('r (e ase (e (at's as#$e en &a rea&i(a( :istrica (e &'s

'r(ena$ient's res#&ta(' e-i(ente se;n #na s#$aria in-estiacin c'$%ara(a &ae9tre$a -arie(a( (e +'r$as / ca$)i's #e %#e(en s#rir en #na ase (e Dat's.

E& %resente tra)a,' :a si(' rea&ia(' c'n e& %r'%sit' (e ')tener &a Partici%acin en &aCa&i+icacin e#i-a&ente a& Tra)a,' C'&ecti-' ' Tra)a,' (e Pr'/ect' r#%a& %r'(#ct'(e n#estr' es+#er' / (ese$%e


6/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


La mpresa

Nombre de la Empresa

EMP"ESA DE T"ANSPO"TES SET"AMI SAC

+epresentante ,egal

i-ic/ "'sse&&'n #is "e/na&('

erente enera&

Direccin

Ca&. C'r'ne& $e N> 415 ? Tr#,i&&'

+ubro

Trans%'rte (e cara %'r carretera

*!-C?L= 3


7/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Descripcin de la Empresa

Es #na e$%resa #)ica(a en &a ci#(a( (e Tr#,i&&' c'n $@s (e 10 a


8/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Definicin de Procesos de Negocio

!n %r'ces' (e ne'ci' es #n c'n,#nt' (e tareas re&aci'na(as &ica$ente &&e-a(as a

ca)' %ara enerar %r'(#ct's / ser-ici's. 's %r'ces's reci)en ins#$'s %ara

trans+'r$ar&'s #ti&ian(' rec#rs's (e &a e$%resa. 's %r'ces's (e ne'ci'

n'r$a&$ente atra-iesan -arias @reas +#nci'na&es.

*!-C?L= 33


9/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


,ista de proceso de negocios

Dentr' (e s#s %r'ces's +#n(a$enta&es (e& ne'ci' tene$'s &'s si#ientes &'s c#a&es

&'s ra+ica$'s (e &a si#iente $anera.

(escripcin pictogr.ica de los )rocesos de $egocio


10/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


/estin de datos

Pr'ces' %'r e& c#a& se intr'(#cen / act#a&ian &'s (at's (e &a )ase (e (at's (e &a

e$%resa. Per$ite rea&iar c'ns#&tas / ')tener in+'r$es (e (ic:'s (at's.

/estin de Almac0n

Pr'ces' #e rea&ia e& c'ntr'& (e& in-entari' (e& a&$ac=n (e re%#est's / (e& s'&ar (e

$ateria&es rea&ia in+'r$es / $#estra a-is's (e re%'sicin (e $ateria&es se;n

criteri'.

1acturacin

Pr'ces' #e reistra &'s a&)aranes (e c&ientes / %r'-ee('res / rea&ia &as +act#rasc'rres%'n(ientes.

Asignacin de cargas

Pr'ces' #e c'te,a &'s %e(i('s / &'s $ateria&es (is%'ni)&es en s'&ar %r'-ee('res /

-e:*c#&' %ti$' / asina &as caras $an#a& ' a#t'$@tic'B.


11/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Descripcin detallada de las actividades que se reali2a en

cada proceso de negocio

/estin de Datos

estin (e Se#r's Se encara (e rea&iar t'(as &as +#nci'nes #e tenan #e

-er c'n &'s se#r's. estin (e Inci(encias "ea&ia e& c'ntr'& (e &as inci(encias #e se %r'(#cen %'r

c'n(#ct'r / -e:*c#&' en ca(a %e(i('. estin (e Siniestr's "ea&ia t'(as &as +#nci'nes (e c'ntr'& (e siniestr's (e &'s

-e:*c#&'s. estin (e Pe(i('s Pr'ces' #e se encara (e t'(as &as +#nci'nes

c'rres%'n(ientes a &a estin (e %e(i('s. estin (e e:*c#&'s Pr'ces' #e rea&ia t'(as &as +#nci'nes #e tenan #e

-er c'n &'s -e:*c#&'s. estin (e C'n(#ct'res Pr'ces' #e rea&ia t'(as &as +#nci'nes #e tenan

#e -er c'n &'s c'n(#ct'res. estin (e C&ientes Pr'ces' #e rea&ia t'(as &as +#nci'nes #e tenan #e -er

c'n &'s c&ientes. estin (e Pr'-ee('res Pr'ces' #e rea&ia t'(as &as +#nci'nes #e tenan

#e -er c'n &'s %r'-ee('res. estin (e Tari+as Pr'ces' #e se encara (e t'(as &as +#nci'nes #e tenan

#e -er c'n &as tari+as. estin (e Destin's Pr'ces' #e se encara (e &a rece%cin creacin /

+act#racin (e %e(i('s.


12/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


(escripcin pictogr.ica de las acti/idades dentro del proceso de Gestin de (atos


13/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


/estin de Almac0n

estin (e "e%#est's Se encara (e rea&iar t'(as &as +#nci'nes #e tenan

#e -er c'n e& in-entari' (e &'s re%#est's (e& a&$ac=n. estin (e Materia&es Se encara (e rea&iar t'(as &as +#nci'nes #e tenan

#e -er c'n e& in-entari' (e &'s $ateria&es (e& s'&ar. estin (e& S#rti('r "ea&ia t'(as &as +#nci'nes (e c'ntr'& (e& s#rti('r.

(escripcin pictogr.ica de las acti/idades dentro del proceso de Alac"n


14/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


1acturacin

estin (e A&)aranes Se encara (e rea&iar t'(as &as +#nci'nes #e tenan

#e -er c'n &'s a&)aranes act#ras C&iente "ea&ia t'(as &as +#nci'nes (e rea&iacin / c'ntr'& (e &as

+act#ras %ara &'s c&iente. act#ras Pr'-ee('r "ea&ia t'(as &as +#nci'nes (e rea&iacin / c'ntr'& (e &as

+act#ras (e &'s %r'-ee('res.

(escripcin pictogr.ica de las acti/idades dentro del proceso de 0acturacin


15/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


+eglas del negocio basado en la descripcin de las

actividades de cada proceso de negocio

,os 3onductores

's c:'+eres (e)en rea&iar sie$%re #na ins%eccin (iaria a s# #ni(a( $-i& a&

%rinci%i' (e& (*a. 's c:'+eres s'&' (e)en c'ntar c'n 8 :'ras (e $ane,'. E& c:'+er n' (e)e rea&iar %ara(as n' a#t'ria(as :asta e& %#nt' (e (estin'.

,as 1acturas

Ca(a %e(i(' (e #n c&iente enera #n a&)ar@n (e entrea as'cia(' a este. Ca(a %e(i(' a #n %r'-ee('r enera #n a&)ar@n (e rec',' as'cia(' a este. a +act#ra (e& ser-ici' est@ +'r$a(a %'r &'s a&)aranes e9istentes (entr' (e #n

(eter$ina(' %eri'(' (e tie$%' %ara #n (eter$ina(' %r'-ee('r ' c&iente.

,os 4edidos

!n %e(i(' %#e(e tener as'cia(' -ari's ast's /' -arias inci(encias. !n c'n(#ct'r %#e(e tener as'cia('s -ari's siniestr's. Ca(a %e(i(' ten(r@ as'cia(' #n $ateria& ' #n re%#est'.

,os 5olares

a e$%resa (is%'ne (e #n s'&ar. En (ic:' s'&ar se (is%'ne (e %a&as

e9ca-a('ras %ara rea&iar e& &&ena(' (e &'s ca$i'nes ' -'etes (estina('s a&

trans%'rte (e &'s @ri('s. 's $ateria&es %e(i('s %'r &'s c&ientes %'(r@n %r'ce(er (e (ic:' s'&ar ' (e

%r'-ee('res (e &a e$%resa (e%en(ien(' (e &a canti(a( ca&i(a( / (is%'sicin(e& $ateria&.

,os +epuestos de mantenimiento

's re%#est's :a)it#a&es (e &'s #e se (is%'nen s'n t#ercas t'rni&&'s +i&tr's (e

aceite / (e aire r#e(as &*#i(' (e +ren's aceite etc. ciertas :erra$ientas

%ara e& )anc' (e tra)a,'.


16/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


,os -ateriales

's $ateria&es c'n &'s #e tra)a,a &a e$%resa s'n ra-a ra-i&&a / arena. Ca(a ti%' (e $ateria& %'see $ateria&es / ca(a $ateria& es a(#iri(' en #n

'rien (e #n %r'-ee('r %ara #n (eter$ina(' (estin' (e #n c&iente / tiene #na

tari+a (e ser-ici'.

,os 3lientes

E& a)anic' (e c&ientes a &'s #e se s#$inistran @ri('s -an (es(e #n c&iente

%artic#&ar a &as ran(es e$%resas (e c'nstr#ccin. 's c&ientes rea&ian s#s %e(i('s %'r te&=+'n' a &a '+icina (e &a e$%resa s'n

in+'r$a('s (e &as tari+as / e& %&a' (e entrea (e &'s $ateria&es s'&icita('s. A &a

:'ra (e &a entrea (e& $ateria& &'s c&ientes +ir$an #n a&)ar@n (e& %e(i('

reci)ien(' &as +act#ras %'r %arte (e &a e$%resa %'steri'r$ente.

4roveedores

's %r'-ee('res s'n a#e&&'s arener's c'n $e,'r re&acin ca&i(a(%reci' en

t'(' e& %a*s. a e$%resa ac'%ia &'s @ri('s (e &'s %r'-ee('res a#t'ria('s en &'s (istint's

ti%'s (e $ateria&es arena %ie(ra ra-i&&a etc.B +ir$an(' a&)aranes %'r ca(a

cara / reci)ien(' &as +act#ras a %aar %'steri'r$ente.

.e67culos

Se (is%'nen (e tr@i&er (e ti%' (')&e carr' artic#&a('s / (e c'ntene('res

in(#stria&es (e (i+erentes $arcas / $'(e&'s. Ca(a -e:*c#&' tiene #n n;$er' (e %&ia as'cia(' a& se#r' c'ntrata(' c'n s#

c'$%a


17/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Identificacin de ntidades

,ista de las entidades principales y sus relaciones desdelas reglas de negocio

C'n(#ct'res Inci(encias Se#r's Siniestr's e:*c#&'s Pe(i('s

ast's C&ientes Materia&es Tari+as Destin's Pr'-ee('res "e%#est's A&)aranes

*!-C?L= 333


18/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Diagrama DE+ 8Entidad +elacin9 Inicial

(iagraa &ntidad Relacin %nicial 1$otacin #2L3


19/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


(iagraa &ntidad Relacin &4tendido

,ista de atributos y 4s que describen adecuadamente a

las entidades

3liente


20/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


.e67culo

3onductores

4roveedores


21/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


+epuestos

-ateriales

Incidencias

/astos


22/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


5iniestros

Albaranes

5eguros


23/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Destinos

4edidos

;arifas

*!-C?L= 3V


24/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Diagrama D R

+elaciones entre entidades< incluye las relaciones de

claves primarias y forneas


25/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Diagrama Entidad +elacin A!nado

(iagraa &ntidad Relacin A.inado

Diagrama DE+ E=tendido

G&$&RAL%ZAC%5$-C'n,#nt' (e enti(a(es en ni-e&es (e s#)r#%'s (e enti(a(es re%resenta(' %'r

#n %r'ces' (e (ise


26/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


A'+C%AC%5$Es enera&$ente #na re&acin estr#ct#ra& entre c&ases.a $#&ti%&ici(a( en #na As'ciacin (ice )astante /a #e (e es' (e%en(er@ si

e& atri)#t' es #na c'&eccin ' si$%&e$ente #na -aria)&e (e re+erencia a #n

'),et'.

C+2)+'%C%5$

Es #na re&acin estr#ct#ra& %er' se &e s#$a #e tiene #n $=t'(' (e(estr#ccin (e &'s '),et's. a (i+erencia (e &a as'ciacin e& cic&' (e -i(a (e&

'),et' @rea est@ re&aci'na(' c'n e& (e& '),et' r#ta. Es (ecir #e si &a r#ta (e

-ia,e se &e-anta &as @reas #e s#r*an a %artir (e e&&a (esa%arecen. Ta$)i=n

se %#e(e &eer c'$' #e #na r#ta tiene -arias @reas (e c')ert#ra.

M#c:' se :a (isc#ti(' a cerca (e &as areaci'nes / &as c'$%'sici'nes e&

(e)ate es casi tan ca&iente c'$' e& (e &'s inc(e / e9ten(s (e &'s cas's (e

#s'. a #e an's s'stienen #e &'s &en#a,es 'rienta('s a '),et's tienen

ar)ae c'&&ect'r %'r &' #e n' necesitan $=t'('s (e (estr#ccin (e &'s'),et's re&aci'na('s a &'s cic&'s (e -i(a en &a c'$%'sicinB. #e &a


27/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


%r'ra$acin es &a $is$a %ara &as c'$%'sici'nes / &as areaci'nes / #e &a

(i+erencia es $era$ente c'nce%t#a& entre #na / 'tras. Es $@s e9isten -arias

inter%retaci'nes %er' &a e9%#esta es a &a c#a& /' a(:ier'.


28/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


(iagraa &ntidad Relacin &4tendido

Normalizacin

4+I-E+A 1O+-A NO+-A, > #1N

!na ta)&a est@ en Pri$era 'r$a N'r$a& si

*!-C?L= V


29/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


T'('s &'s atri)#t's s'n at$ic's. !n atri)#t' es at$ic' si &'s e&e$ent's (e&

('$ini' s'n si$%&es e in(i-isi)&es. a ta)&a c'ntiene #na c&a-e %ri$aria ;nica. a c&a-e %ri$aria n' c'ntiene atri)#t's n#&'s. N' (e)e e9istir -ariacin en e& n;$er' (e c'$nas.

's Ca$%'s n' c&a-e (e)en i(enti+icarse %'r &a c&a-e De%en(encia #nci'na&B De)e E9istir #na in(e%en(encia (e& 'r(en tant' (e &as +i&as c'$' (e &as

c'$nas es (ecir si &'s (at's ca$)ian (e 'r(en n' (e)en ca$)iar s#s

sini+ica('s

Esta +'r$a n'r$a& e&i$ina &'s -a&'res re%eti('s (entr' (e #na ase (e Dat's.

5E/UNDA 1O+-A NO+-A, ? &1N

's reistr's n' (e)en (e%en(er (e na(a #e n' sea #na c&a-e %rinci%a& (e #na ta)&a

#na c&a-e c'$%#esta si es necesari'. P'r e,e$%&' c'nsi(ere &a (ireccin (e #n c&iente

en #n siste$a (e c'nta)i&i(a(. a (ireccin se necesita en &a ta)&a C&ientes %er'

ta$)i=n en &as ta)&as Pe(i('s En-*'s act#ras C#entas %'r c')rar / C'&ecci'nes.

En ar (e a&$acenar &a (ireccin (e #n c&iente c'$' #na entra(a in(e%en(iente en

ca(a #na (e estas ta)&as a&$ac=ne&a en #n ar /a sea en &a ta)&a C&ientes ' en #na

ta)&a Direcci'nes in(e%en(iente.

;E+3E+A 1O+-A NO+-A, ? *1N

's -a&'res (e #n reistr' #e n' sean %arte (e &a c&a-e (e ese reistr' n' %ertenecen

a &a ta)&a. En enera& sie$%re #e e& c'nteni(' (e #n r#%' (e ca$%'s %#e(a

a%&icarse a $@s (e #n ;nic' reistr' (e &a ta)&a c'nsi(ere c'&'car est's ca$%'s en

#na ta)&a in(e%en(iente. P'r e,e$%&' en #na ta)&a C'ntratacin (e e$%&ea('s %#e(e

incirse e& n'$)re (e &a #ni-ersi(a( / &a (ireccin (e #n can(i(at'. Per' necesita #na

&ista c'$%&eta (e #ni-ersi(a(es %ara en-iar $ensa,es (e c'rre' e&ectrnic' en r#%'.

Si &a in+'r$acin (e &as #ni-ersi(a(es se a&$acena en &a ta)&a Can(i(at's n' :a/

+'r$a (e en#$erar &as #ni-ersi(a(es #e n' tenan can(i(at's en ese $'$ent'.Cree #na ta)&a !ni-ersi(a(es in(e%en(iente / -inc;&e&a a &a ta)&a Can(i(at's c'n e&

c(i' (e #ni-ersi(a( c'$' c&a-e.

EHCEPCIN c#$%&ir &a tercera +'r$a n'r$a& a#n#e en te'r*a es (esea)&e n'

sie$%re es %r@ctic'. Si tiene #na ta)&a C&ientes / (esea e&i$inar t'(as &as

(e%en(encias %'si)&es entre &'s ca$%'s (e)e crear ta)&as in(e%en(ientes %ara &as

ci#(a(es c(i's %'sta&es re%resentantes (e -enta c&ases (e c&ientes / c#aier

'tr' +act'r #e %#e(a estar (#%&ica(' en -ari's reistr's. En te'r*a &a n'r$a&iacin$erece e& tra)a,' #e s#%'ne. Sin e$)ar' $#c:as ta)&as %e#e


30/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


P#e(e ser $@s +acti)&e a%&icar &a tercera +'r$a n'r$a& s&' a &'s (at's #e ca$)ian

c'n +rec#encia. Si #e(an an's ca$%'s (e%en(ientes (ise


31/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


)riera 0ora $oral 6 70$

'egunda 0ora $oral 8 90$


32/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



33/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


*ercer 0ora $oral 8 :0$

*!-C?L= V3


34/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Modelo !sico de Datos

Estructura del modelo f7sico de datos

!na .D. tiene #n' ' $@s +ic:er's (e (at's. Est's +ic:er's s'n (e ta$a


35/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



36/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



37/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



38/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



39/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



40/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



41/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



42/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



43/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



44/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



45/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



46/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



47/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



48/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



49/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



50/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



51/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



52/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



53/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



54/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



55/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



56/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



57/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



58/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



59/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



60/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Elaboracin de sentencias DD,

C"EATE TAE AACEIAACEIJID N!ME"8B NOT N!AACEIJ"EP!JID N!ME"8B NOT N!AACEIJP!NTOJE!ICION N!ME"182B NOT N!AACEIJISCOCIDAD N!ME"182B NOT N!

BLC"EATE TAE A"!ED

A"!EDJID N!ME"8B NOT N!A"!EDJ"EP!JID N!ME"8B NOT N!A"!EDJANCOJ"!EDA N!ME"182B NOT N!A"!EDJINDICEJCA"A N!ME"182B NOT N!A"!EDJN!ME"OJA"O N!ME"182B NOT N!

BL

C"EATE TAE ACETACETJID N!ME"8B NOT N!

ACETJNOM"EJTIPO A"CA"250B NOT N!BL

C"EATE TAE DASE!


61/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


DASE!JID N!ME"8B NOT N!DASE!JNOM"EJASE!"ADO"A A"CA"250B NOT N!DASE!J"!C A"CA"211B NOT N!DASE!J"AONJSOCIA A"CA"2150B NOT N!

BL

C"EATE TAE A"EPTA"EPTJID N!ME"8B NOT N!A"EPTJNOM"E NA"CA"218B NOT N!

BL

C"EATE TAE AMATTAMATTJID N!ME"8B NOT N!AMATTJNOM"E NA"CA"218B NOT N!

BL

C"EATE TAE "PDD

"PDDJID N!ME"8B NOT N!"PDDJPDDCJID N!ME"8B NOT N!"PDDJASTJID N!ME"8B NOT N!"PDDJP"ECIO N!ME"102B NOT N!"PDDJTOTA N!ME"102B NOT N!

BL

C"EATE TAE "PDID"PDIDJID N!ME"8B NOT N!"PDIDJPDDCJID N!ME"8B NOT N!"PDIDJINCIJID N!ME"8B NOT N!"PDIDJCANTIDAD NA"CA"210B NOT N!"PDIDJESTADO NA"CA"210B NOT N!

BL

C"EATE TAE "PD"D"PD"DJID N!ME"8B NOT N!"PD"DJPDDCJID N!ME"8B NOT N!"PD"DJ"EP!JID N!ME"8B NOT N!"PD"DJP"ECIO N!ME"102B NOT N!"PD"DJTOTA N!ME"102B NOT N!

BL

C"EATE TAE "PDDD"PDDDJID N!ME"8B NOT N!"PDDDJMATEJID N!ME"8B"PDDDJPDDCJID N!ME"8B NOT N!"PDDDJCANTIDAD NA"CA"218B NOT N!"PDDDJESTADO NA"CA"250B NOT N!

BL

C"EATE TAE "AND"ANDJID N!ME"8B NOT N!"ANDJMATEJID N!ME"8B NOT N!"ANDJANCJID N!ME"8B NOT N!

"ANDJCANTIDAD NA"CA"212B NOT N!BL

C"EATE TAE ACEI


62/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


ACEIJID N!ME"8B NOT N!ACEIJETJID N!ME"8B NOT N!ACEIJPACA NA"CA"26B NOT N!ACEIJMA"CA NA"CA"216B NOT N!ACEIJMODEO NA"CA"220B NOT N!ACEIJCOO" NA"CA"216B NOT N!

ACEIJMOTO" NA"CA"218B NOT N!ACEIJEQES NA"CA"23B NOT N!ACEIJCIIND"AQE NA"CA"212B NOT N!ACEIJEOCIDADMAHIMA NA"CA"212B NOT N!ACEIJPESONETO NA"CA"210B NOT N!ACEIJPESO"!TO NA"CA"212B NOT N!ACEIJPESO!TI NA"CA"212B NOT N!ACEIJONIT!D NA"CA"212B NOT N!ACEIJAT!"A NA"CA"212B NOT N!ACEIJCAPACIDADC!CA"A NA"CA"212B NOT N!ACEIJTIPOT"ANSMISION NA"CA"220B NOT N!

BL

C"EATE TAE ACCONDACCONDJID N!ME"8B NOT N!ACCONDJCONDJID N!ME"8B NOT N!ACCONDJEIJID N!ME"8B NOT N!ACCONDJRMJSAIDA N!ME"182B NOT N!ACCONDJRMJEADA N!ME"182B NOT N!ACCONDJCONS!MOJAS N!ME"182BACCONDJECAJSAIDA DATE NOT N!ACCONDJECAJEADA DATE

BL

C"EATE TAE DTA"IDTA"IJID N!ME"8B NOT N!DTA"IJMATEJID N!ME"8B NOT N!DTA"IJDESTJID N!ME"8B NOT N!DTA"IJP"ECIO N!ME"182B NOT N!

BL

C"EATE TAE PDDCPDDCJID N!ME"8B NOT N!PDDCJCIEJID N!ME"8B NOT N!

PDDCJP"OJID N!ME"82B NOT N!BL

C"EATE TAE ACDESTACDESTJID N!ME"8B NOT N!ACDESTJCIEJID N!ME"8B NOT N!ACDESTJP"OJID N!ME"8B NOT N!ACDESTJRIOMET"OS NA"CA"218B NOT N!ACDESTJDI"ECCION NA"CA"230B NOT N!ACDESTJP"OINCIA NA"CA"218B NOT N!ACDESTJOCAIDAD NA"CA"218B NOT N!ACDESTJOSE"ACIONES NA"CA"250B NOT N!

BL

C"EATE TAE DSE!DSE!JID N!ME"8B NOT N!


63/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


DSE!JSE!JID N!ME"8B NOT N!DSE!JEIJID N!ME"8B NOT N!DSE!JN!ME"OPOIA NA"CA"214B NOT N!DSE!JECAINICIO DATE NOT N!DSE!JECAIN DATE NOT N!DSE!JCOSTO N!ME"122B NOT N!

DSE!JESTADOSE!"O NA"CA"220B NOT N!BL

C"EATE TAE ANCANCJID N!ME"8B NOT N!ANCJCONDJID N!ME"8B NOT N!ANCJECAJ"ECOQO DATE NOT N!ANCJECAJENT"EA DATE NOT N!ANCJOSE"ACIONES A"CA"2255B

BL

C"EATE TAE DSINIDSINIJID N!ME"8B NOT N!DSINIJCONDJID N!ME"8B NOT N!DSINIJECA"EIST"O DATE NOT N!DSINIJECA"EPO"TADO DATE NOT N!DSINIJECAOC!""IDO DATE NOT N!DSINIJECACE""ADO DATE NOT N!DSINIJ!A"SINIEST"O NA"CA"230B NOT N!DSINIJOSE"ACIONES NA"CA"280B NOT N!DSINIJTIPOSINIEST"O NA"CA"220B NOT N!DSINIJESTADOSINIEST"O NA"CA"214B NOT N!DSINIJ"EIST"ADOPO" NA"CA"220B NOT N!

DSINIJPOIASINO!C"ADAS NA"CA"280B NOT N!DSINIJPE"SONASINO!C"ADAS NA"CA"280B NOT N!BL

C"EATE TAE DASTDASTJID N!ME"8B NOT N!DASTJTIPO NA"CA"212B NOT N!DASTJDESC"IPCION NA"CA"230B NOT N!DASTJECA DATE NOT N!

BL

C"EATE TAE DINCI

DINCIJID N!ME"8B NOT N!DINCIJCONDJID N!ME"8B NOT N!DINCIJEIJID N!ME"8B NOT N!DINCIJTIPO NA"CA"220B NOT N!


64/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


DINCIJECA DATE NOT N!DINCIJO"A DATE NOT N!DINCIJDESC"IPCION NA"CA"250B NOT N!DINCIJASTO N!ME"182B NOT N!

BL

C"EATE TAE AMATEAMATEJID N!ME"8B NOT N!AMATEJMATTJID N!ME"8B NOT N!AMATEJNOM"E NA"CA"220B NOT N!AMATEJDESC"IPCION NA"CA"250B NOT N!AMATEJTIPO NA"CA"230B NOT N!AMATEJDENSIDAD NA"CA"230B NOT N!AMATEJASO"CIONA!A NA"CA"220BAMATEJMASAO!MET"ICAS!ETA NA"CA"220B NOT N!

BL

C"EATE TAE A"EP!

A"EP!JID N!ME"8B NOT N!A"EP!J"EPTJID N!ME"8B NOT N!A"EP!JNOM"E NA"CA"250B NOT N!A"EP!JDESC"IPCON NA"CA"250B NOT N!A"EP!JCANTIDAD N!ME"182B NOT N!

BL

C"EATE TAE P"OP"OJID N!ME"8B NOT N!P"OJ"AONSOCIA NA"CA"250B NOT N!P"OJ"!C NA"CA"211B NOT N!P"OJDNI NA"CA"28B NOT N!P"OJDI"ECCION NA"CA"250B NOT N!P"OJTEEONO NA"CA"218B NOT N!

BL

C"EATE TAE DCONDDCONDJID N!ME"8B NOT N!DCONDJNOM"E NA"CA"220B NOT N!DCONDJAPEIDOS NA"CA"220B NOT N!DCONDJDNI NA"CA"28B NOT N!

DCONDJDI"ECCION NA"CA"220B NOT N!DCONDJN!MICENCIA NA"CA"250B NOT N!DCONDJCATEO"IA NA"CA"218B NOT N!DCONDJECANACIMIENTO DATE NOT N!DCONDJ!A"NACIMIENTO NA"CA"218B NOT N!DCONDJEDAD NA"CA"212B NOT N!

BL

C"EATE TAE CIECIEJID N!ME"8B NOT N!CIEJ"AONSOCIA NA"CA"250B NOT N!CIEJDNI NA"CA"28B NOT N!

CIEJ"!C NA"CA"211B NOT N!CIEJDI"ECCION NA"CA"250B NOT N!CIEJTEEONO NA"CA"218B NOT N!

BL


65/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'



66/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


ATE" TAE AACEI ADD CONST"AINT PRJAACEIP"IMA" RE AACEIJIDB

L

ATE" TAE A"!ED ADD CONST"AINT PRJA"!EDP"IMA" RE A"!EDJIDB

L

ATE" TAE ACET ADD CONST"AINT PRJACETP"IMA" RE ACETJIDB

L

ATE" TAE DASE! ADD CONST"AINT PRJDASE!P"IMA" RE DASE!JIDB

L

ATE" TAE A"EPT ADD CONST"AINT PRJA"EPTP"IMA" RE A"EPTJIDB

L

ATE" TAE AMATT ADD CONST"AINT PRJAMATTP"IMA" RE AMATTJIDB

L

ATE" TAE "PDD ADD CONST"AINT PRJ"PD"P"IMA" RE "PDDJIDB

L

ATE" TAE "PDID ADD CONST"AINT PRJ"PDIDP"IMA" RE "PDIDJIDB

L

ATE" TAE "PD"D ADD CONST"AINT PRJ"PD"DP"IMA" RE "PD"DJIDB

L

ATE" TAE "PDDD ADD CONST"AINT PRJ"PDDDP"IMA" RE "PDDDJIDB

L

ATE" TAE "AND ADD CONST"AINT PRJ"AND

P"IMA" RE "ANDJIDBL

ATE" TAE ACEI ADD CONST"AINT PRJACEIP"IMA" RE ACEIJIDB

L

ATE" TAE ACCOND ADD CONST"AINT PRJACCONDP"IMA" RE ACCONDJIDB

L

ATE" TAE DTA"I ADD CONST"AINT PRJDTA"I

P"IMA" RE DTA"IJIDBL

ATE" TAE PDDC ADD CONST"AINT PRJPDDC


67/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


P"IMA" RE PDDCJIDBL

ATE" TAE ACDEST ADD CONST"AINT PRJACDESTP"IMA" RE ACDESTJIDB

L

ATE" TAE DSE! ADD CONST"AINT PRJDSE!P"IMA" RE DSE!JIDB

L

ATE" TAE ANC ADD CONST"AINT PRJANCP"IMA" RE ANCJIDB

L

ATE" TAE DSINI ADD CONST"AINT PRJDSINIP"IMA" RE DSINIJIDB

L

ATE" TAE DAST ADD CONST"AINT PRJDASTP"IMA" RE DASTJIDB

L

ATE" TAE DINCI ADD CONST"AINT PRJDINCIP"IMA" RE DINCIJIDB

L

ATE" TAE AMATE ADD CONST"AINT PRJAMATEP"IMA" RE AMATEJIDB

L

ATE" TAE A"EP! ADD CONST"AINT PRJA"EP!P"IMA" RE A"EP!JIDB

L

ATE" TAE P"O ADD CONST"AINT PRJP"OP"IMA" RE P"OJIDB

L

ATE" TAE DCOND ADD CONST"AINT PRJDCONDP"IMA" RE DCONDJIDB

LATE" TAE CIE ADD CONST"AINT PRJCIE

P"IMA" RE CIEJIDBL

ATE" TAE AACEI ADD CONST"AINT RJAACEIJ"EP!JIDO"EIN RE AACEIJ"EP!JIDB "EE"ENCES A"EP!

A"EP!JIDBL

ATE" TAE A"!ED ADD CONST"AINT RJA"!EDJ"EP!JIDO"EIN RE A"!EDJ"EP!JIDB "EE"ENCES A"EP!A"EP!JIDBL


68/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


ATE" TAE "PDD ADD CONST"AINT RJ"PD"JASTJIDO"EIN RE "PDDJASTJIDB "EE"ENCES DAST

DASTJIDBL

ATE" TAE "PDD ADD CONST"AINT RJ"PD"JPDDCJIDO"EIN RE "PDDJPDDCJIDB "EE"ENCES PDDCPDDCJIDBL

ATE" TAE "PDID ADD CONST"AINT RJ"PDIDJINCIJIDO"EIN RE "PDIDJINCIJIDB "EE"ENCES DINCI DINCIJIDB

L

ATE" TAE "PDID ADD CONST"AINT RJ"PDIDJPDDCJIDO"EIN RE "PDIDJPDDCJIDB "EE"ENCES PDDC

PDDCJIDB

L

ATE" TAE "PD"D ADD CONST"AINT RJ"PD"DJPDDCJIDO"EIN RE "PD"DJPDDCJIDB "EE"ENCES PDDC

PDDCJIDBL

ATE" TAE "PD"D ADD CONST"AINT RJ"PD"DJ"EP!JIDO"EIN RE "PD"DJ"EP!JIDB "EE"ENCES A"EP!

A"EP!JIDBL

ATE" TAE "PDDD ADD CONST"AINT RJ"PDDDJMATEJIDO"EIN RE "PDDDJMATEJIDB "EE"ENCES AMATE

AMATEJIDBL

ATE" TAE "PDDD ADD CONST"AINT RJ"PDDDJPDDCJIDO"EIN RE "PDDDJPDDCJIDB "EE"ENCES PDDC

PDDCJIDBL

ATE" TAE "AND ADD CONST"AINT RJ"ANDJANCJID

O"EIN RE "ANDJANCJIDB "EE"ENCES ANCANCJIDBL

ATE" TAE "AND ADD CONST"AINT RJ"ANDJMATEJIDO"EIN RE "ANDJMATEJIDB "EE"ENCES AMATE

AMATEJIDBL

ATE" TAE ACEI ADD CONST"AINT RJACEIJETJIDO"EIN RE ACEIJETJIDB "EE"ENCES ACET

ACETJIDBL

ATE" TAE ACCOND ADD CONST"AINT RJACCONDJCONDJID


69/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


O"EIN RE ACCONDJCONDJIDB "EE"ENCES DCONDDCONDJIDBL

ATE" TAE ACCOND ADD CONST"AINT RJACCONDJEIJIDO"EIN RE ACCONDJEIJIDB "EE"ENCES ACEI

ACEIJIDBL

ATE" TAE DTA"I ADD CONST"AINT RJDTA"IJDESTJIDO"EIN RE DTA"IJDESTJIDB "EE"ENCES ACDEST

ACDESTJIDBL

ATE" TAE DTA"I ADD CONST"AINT RJDTA"IJMATEJIDO"EIN RE DTA"IJMATEJIDB "EE"ENCES AMATE

AMATEJIDBL

ATE" TAE PDDC ADD CONST"AINT RJPDDCJCIEJIDO"EIN RE PDDCJCIEJIDB "EE"ENCES CIE CIEJIDB

L

ATE" TAE PDDC ADD CONST"AINT RJPDDCJP"OJIDO"EIN RE PDDCJP"OJIDB "EE"ENCES P"O

P"OJIDBL

ATE" TAE ACDEST ADD CONST"AINT RJACDESTJCIEJIDO"EIN RE ACDESTJCIEJIDB "EE"ENCES CIE CIEJIDB

L

ATE" TAE ACDEST ADD CONST"AINT RJACDESTJP"OJIDO"EIN RE ACDESTJP"OJIDB "EE"ENCES P"O

P"OJIDBL

ATE" TAE DSE! ADD CONST"AINT RJDSE!JSE!JIDO"EIN RE DSE!JSE!JIDB "EE"ENCES DASE!

DASE!JIDBL

ATE" TAE DSE! ADD CONST"AINT RJDSE!JEIJIDO"EIN RE DSE!JEIJIDB "EE"ENCES ACEI

ACEIJIDBL

ATE" TAE ANC ADD CONST"AINT RJANCJCONDJIDO"EIN RE ANCJCONDJIDB "EE"ENCES ACCOND

ACCONDJIDBL

ATE" TAE DSINI ADD CONST"AINT RJDSINIJCONDJIDO"EIN RE DSINIJCONDJIDB "EE"ENCES ACCONDACCONDJIDBL


70/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


ATE" TAE AMATE ADD CONST"AINT RJAMATEJMATTJIDO"EIN RE AMATEJMATTJIDB "EE"ENCES AMATT

AMATTJIDBL

ATE" TAE A"EP! ADD CONST"AINT RJA"EP!J"EPTJIDO"EIN RE A"EP!J"EPTJIDB "EE"ENCES A"EPTA"EPTJIDBL


71/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Implementacin de la base de datos

Para iniciar &a i$%&e$entacin (e #na )ase (e (at's se (e)en (e c'n'cer &as

sentencias $*ni$as &as sentencias O"ACE se se%araran en &a creacin insercin /

se&eccin &as %ri$eras ('s est@n :ec:as %ara crear en si e& $'(e&' (e )ase (e (at'ssea &a creacin (e ta)&as ' enti(a(es c'n s#s res%ecti-'s atri)#t's &a se&eccin se

)asa s'&' en :acer c'ns#&tas s')re #na )ase (e (at's sin crear nin#na c&ase (e

$'(i+icacin s')re &a $is$a.


72/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Elaboracin de 3onsultas 5@,

SEECT "OM a-re%#

INNE" QOIN a-re%t ON a-re%t.A"EPTJID a-re%#.A"EP!J"EPTJIDL

SEECT A"EP!JID AS IDENTIICACO" A"EP!JNOM"E AS NOM"E

P"OD!CTO A"EP!JCANTIDAD AS CANTIDAD

"OM a-re%#L


73/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Elaboracin de 5entencias D-,

!PDATE a-re%# SET A"EP!JCANTIDAD 200 E"E A"EP!J"EPTJID 1L

SEECT "OM (e$'-1.a-re%#L


74/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Planificacin

A c'ntin#acin se $#estra #n (iara$a (e antt rea&ia(' ('n(e a%arece &a%&ani+icacin &&e-a(a a ca)' %'r n#estr' r#%' en &a c'nsec#cin (e& %r'/ect'%resenta(' a c'ntin#acin.

,emana 1

,emana

,emana '

,emana (

,emana )

,emana 6

,emana 7

3ap7tul

o I3ap7tulo II3ap7tulo III3ap7tulo I.3ap7tulo .3ap7tulo .I

Dentr' (e n#estras re#ni'nes / trasn'c:a(as / $ientras tra)a,@)a$'s en e#i%'t'('s t#-i$'s #e e$%a%arn's (e& te$a / (i-i(irn's res%'nsa)i&i(a(es %ara c'ncire& %resente tra)a,' a &a )re-e(a( %'si)&e / c'n &a e+icacia #e se a$erita.

Gallardo-Encara(' (e &a ('c#$entacin / Dicci'nari' (e Dat'sVilquiiche-Encara(' (e &a Enti(a( "e&acin / Diara$as Inicia&esLpez ; Garca-Encara('s (e &as N'r$a&iaci'nes

-L!N3#3*!*3BN


75/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Concl"siones

Conclusiones

a rea&iacin (e este %r'/ect' :a %reten(i(' (ar #na s'cin in+'r$@tica a& ne'ci'(e &a e$%resa (e trans%'rte (e @ri('s SET"AMI SAC. #e en &'s ;&ti$'s a


76/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Recomendaciones

Recomendaciones

Princi%a&$ente -e$'s &a necesi(a( (e c'n'cer ca(a (*a $@s e& ent'rn' (e &as)ases (e (at's. A%ren(er (e $anera (i(@ctica / a#t'(i(actica c'n $a/'r

(e(icacin.

Es necesari' c'n'cer #e &a i$%&e$entacin (e& c(i' (e)e estar )ienestr#ct#ra(' %ara e-itar anas re(#n(ancias innecesarias.

C'n'cer &as es%eci+icaci'nes #e n's %resenta c#an(' estr#ct#ra$'s &asta)&as (e ca(a )ase (e (at's rea&ian(' n#estr' tra)a,' $@s %r@ctic' /senci&&'.

a/ #na ran canti(a( (e (at's e in+'r$acin c'$%i&a(as e &a )ase (e (at's(esarr'&&a(a en e& tra)a,' a#* %resenta( #e es &a rec'%i&acin (e #na %arte

(e &'s est#(i's %re-i's (e &a e$%resa &a in+'r$acin re#ni(a tiene #n ran%'tencia& #e (e)i(' a &i$itaci'nes (e tie$%' n' :a si(' e9%&'tar serec'$ien(a c'nsi(erar este tra)a,' c'$' #n a%'rte / re+erencia enin-estiaci'nes en e& @rea

!na rec'$en(acin en &a #e se insiste es &a (e (iriir es+#er's $e,'r+'rta&ecer &'s #e /a se iniciar'n :acia #na siste$atiacin (e& $ane,' (e t'('e& siste$a inci(' &'s %r'/ect's / acti-i(a(es +#t#ras en &a e$%resa.

Esta siste$atiacin se rec'$ien(a #e en &a $e(i(a (e &' %'si)&e se e9tien(aa &a estan(ariacin (e $et'('&'*as (e $#estre' / (e an@&isis a +in (e +aci&itare& an@&isis / e-aacin (e &a in+'r$acin.

RE*=MEND!*3=


77/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


A(e$@s (e &a siste$atiacin (e &'s est#(i's #na $ateria (e i$%'rtancia+#n(a$enta& es &a ('c#$entacin (e%en(ien(' (e e&&a se (is%'n(r@n (e $@s' $en's e&e$ent's (e re+erencia en &a a($inistracin (e &a in+'r$acin %'r &'#e se rec'$ien(a esta)&ecer +'r$at's ' re#eri$ient's $*ni$'s (e res%a&('en &as +#t#ras in-estiaci'nes en e& @rea )asa('s e &a -aria)i&i(a( #e(eter$ina('s %ar@$etr's %resentan.

Esta)&ecer &a entra(a (e& $ateria& (e in-estiacin en +'r$at' (iita& %#es(e)i(' a &a nat#ra&ea (e ran %arte (e &'s %r'(#ct's (e &a %resentein-estiacin e& +'r$at' en %a%e& res#&ta &i$itante

En %ri$er ar (e)e$'s tener c&ara &a +ina&i(a( (e& %r'/ect' /a #e ser@(eter$inante %ara crear &as ta)&as necesarias / en (e+initi-a &a estr#ct#ra (e&a )ase (e (at's $@s a(ec#a(a.

En#$era &as ta)&as #e necesitas. P'r e,e$%&' si est@s (ise


78/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Diccionario de datos

Diagrama de Entidad Relacin Inicial

&ntidad C+$(#C*+RAlias- Conductor

AtributosID

NOM"E

APEIDOSDNI

C(i' '+icia& (e c'n(#ct'r

N'$)re c'$%&et' (e& c'n(#ct'r

A%e&&i(' c'$%&et' (e& c'n(#ct'rN;$er' (e DNI (e& c'n(#ct'r

DI"ECCION

N!ME"OJICENCIA

Direccin (e& c'n(#ct'r

N#$er' (e &icencia (e& c'n(#ct'rCATEO"IA Cate'r*a (e& c'n(#ct'r ECAJNACIMIENTO ec:a (e naci$ient' (e& c'n(#ct'r!A"JNACIMIENTO #ar (e naci$ient' (e& c'n(#ct'rEDAD E(a( (e& c'n(#ct'r

Cla/es candidatas

Restricciones interedias

&ntidad )R+V&&(+R&'Alias- )R+V&&(+R&'

Atributos

ID"AONJSOCIA

C(i' (e& %r'-ee('r"an s'cia& (e& %r'-ee('r

D3**3=N!R3=


79/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


"!C

DNI

"!C (e& %r'-ee('r

DNI (e& %r'-ee('rDI"ECCION Direccin (e& %r'-ee('r TEEONO N;$er' te&e+nic' (e& %r'-ee('r

Cla/es candidatas


&ntidad '&G#R+'Alias- 'eguros

Atributos

IDEICJ ID

NOM"EJASE!"ADO"

A

N!ME"OJPOIA

C(i' (e& se#r'C(i' (e& -e:*c#&'

N'$)re (e &a ase#ra('ra

N#$er' (e &a %&ia (e se#r'

ECAJINICIO

ECAJIN

ec:a (e inici' (e& se#r'

ec:a +ina& (e& se#r'COSTO C'st' (e& se#r'ESTADOJSE!"O Esta(' en #e se enc#entra e& se#r'

Cla/es candidatas- %(


&ntidad R&)#&'*+'Alias- R&)#&'*+'

Atributos

IDP"OEEDO"ESJID

NOM"E

TIPO

C(i' (e& re%#est'C(i' (e& %r'-ee('r

N'$)re (e& re%#est'

Ti%' (e& re%#est'DESC"IPCIN

CATEO"IA

ANCOJ"!EDA

INDICEJCA"A

P!NTOJE!ICIONISCOSIDADJCINEMATICA

Descri%cin (e& re%#est'

Cate'r*a (e& re%#est'

Anc:' (e &a r#e(a

Un(ice (e &a r#e(a

P#nt' (e e)#&&icin (e& aceiteisc'si(a( cine$@tica (e& aceite


80/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Cla/es candidatas


&ntidad 2A*&R%AL&'Alias- 2A*&R%AL&'

AtributosID

NOM"E

DESC"IPCIN

TIPO

C(i' (e& $ateria&

N'$)re (e& $ateria&

Descri%cin (e& $ateria&

Ti%'DENSIDAD Densi(a( (e& $ateria&ASO"CIONJA!A

MASAO!MET"ICAJS!ETA

A)s'rcin (e& a#a

Masa -'$=trica s#e&ta (e& $ateria&

Cla/es candidatas


&ntidad %$C%(&$C%A'Alias- %$C%(&$C%A'

AtributosID

COND!CTO"JID

EIC!OJID

TIPO

C(i' (e inci(encias

C(i' (e& c'n(#ct'r

C(i' (e& -e:*c#&'

Ti%' (e inci(enciasECA ec:a (e &a inci(enciaO"A

DESC"IPCION

ASTO

'ra (e &a inci(encia

Descri%cin (e &a inci(encia

ast's #e eneran &as inci(encias

Cla/es candidatas


&ntidad CL%&$*&Alias- CL%&$*&

AtributosID

"AONJSOCIA

DNI

C(i' (e& c&iente

"an s'cia& (e& c&iente

N;$er' (e DNI (e& c&iente


81/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


"!C N#$er' (e "!C (e& C&ienteDI"ECCION Direccin (e& c&ienteTEEONO N;$er' te&e+nic' (e& c&iente

Cla/es candidatas


&ntidad V&


82/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


&ntidad '%$%&'*R+'Alias- '%$%&'*R+'

AtributosID

EIC!OJID

COND!CTO"JID

ECAJ"EIST"O

C(i' (e& siniestr'

C(i' (e& -e:*c#&'

C(i' (e& c'n(#ct'r

ec:a (e reistr' (e& siniestr'ECAJ"EPO"TE ec:a (e& re%'rte (e& siniestr'ECAJOC!""IDO

ECAJJCE""ADO

!A"JSINIEST"O

OSE"ACIONES

TIPOJSINIEST"O

ESTADOJSINIEST"O

"EIST"ADO"

POIAJINO!C"ADAS

PE"SONASJINO!C"ADA

S

ec:e #e 'c#rri e& siniestr'

ec:a (e cierre (e& siniestr'

#ar (e& siniestr'

O)ser-aci'nes s')re e& siniestr'

Ti%' (e siniestr'

Esta(' en #e se enc#entra e& siniestr'

"eistra('r (e& siniestr'

P&ias in-'cra(as s')re e& siniestr'

Pers'nas in-'cra(as en e& siniestr'

Cla/es candidatas



83/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


&ntidad ALARA$Alias- ALARA$

AtributosID

PEDIDOJID

COND!CTO"JID

MATE"IAESJID

C(i' (e& a&)ar@n

C(i' (e& %e(i('

C(i' (e& c'n(#ct'r

C(i' (e& $ateria&TA"IAJID C(i' (e &a tari+aECAJ"ECOQO

ECAJENT"EA

OSE"ACIONES

ec:a (e rec',' (e& a&)ar@n

ec:a (e entrea (e& a&)ar@n

O)ser-aci'nes s')re e& a&)ar@n

Cla/es candidatas


&ntidad (&'*%$+Alias- (&'*%$+

AtributosID

CIENTEJIDP"OEEDO"JID

RIOMET"OS

C(i' (e& (estin'

C(i' (e& c&ienteC(i' (e& %r'-ee('r

Ri&'$etra,e s')re e& (estin'DI"ECCION Direccin (e& (estin'P"OINCIA

OCAIDAD

OSE"ACIONES

Pr'-incia (e& (estin'

'ca&i(a( (e& (estin'

O)ser-aci'nes s')re &as (estin's

Cla/es candidatas


&ntidad )&(%(+'Alias- )&(%(+'

AtributosID

DESTINOJID

MATE"IAJID

COND!CTO"JID

C(i' (e& %e(i('

C(i' (e& (estin'

C(i' (e& $ateria&

C(i' (e& c'n(#ct'rTA"IAJID C(i' (e tari+aEIC!OJID C(i' (e& -e:*c#&'


84/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


CANTIDAD

ESTADO

Canti(a( (e %e(i('s

Esta(' (e& %e(i('

Cla/es candidatas


&ntidad *AR%0AAlias- *AR%0A

AtributosID

EIC!OJID

DESTINOJID

CIENTEJID

C(i' (e &a tari+a

C(i' (e& -e:*c#&'

C(i' (e& (estin'

C(i' (e& c&ienteP"ECIO Preci' (e &a tari+a

Cla/es candidatas


&ntidad GA'*+'Alias- GA'*+'

AtributosID

TIPO

DESC"IPCION

ECA

C(i' (e ast's

Ti%' (e ast's

Descri%cin (e &'s ast's

ec:a (e &'s ast's

Cla/es candidatas



85/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


Diagrama Afnado

*ALA *%)+ (& 2A*&R%AL&'

*abla- GAV2A**

(escripcin- *%)+ (& 2A*&R%AL&'GA = Gestin de Alac"n

V = *abla de /alidacin

2A* = *abla 2ateriales

* = tabla de tipologa

Atributos *%)+ +'&RVAC%5$AMATTJID

AMATTJNOM"E

N!ME"8B

A"CA"2 18B

C&a-e Pri$aria (e &a ta)&a ti%' (e

$ateria&es

N'$)re c'$%&et' (e& ti%' (e $ateria&

Cla/es candidatas

AMATTJID PRB



86/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


*ALA 2A*&R%AL&'

*abla- GAV2A*&(escripcin- 2A*&R%AL&'

GA = Gestin de Alac"n


2A*& = *abla 2ateriales

AtributosAMATEJID

AMATEJMATTJID

AMATEJNOM"E

AMATEJDESC"IPCION

AMATEJTIPO

AMATEJDENSIDADAMATEJASO"CIONA!A

AMATEJMASAO!MET"ICA

N!ME" 8B

N!ME" 8B

NACA"220B

NACA"250B

NACA"230B

NACA"230NACA"220B

NACA"220

C&a-e Pri$aria (e &a ta)&a

Materia&es

ID R (e &a ta)&a Ti%' (e

Materia&es

N'$)re c'$%&et' (e& Materia&

Descri%cin (e& $ateria&Ti%' (e& $ateria&

Densi(a( (e& $ateria&

A)s'rcin (e a#a (e& $ateria&

Masa -'$=trica (e& $ateria&

Cla/es candidatas

AMATEJID PRB

AMATEJMATTJID RB

Restricciones interediasRJAMATEJMATTJID

*ALA *AR%0A'*abla- G(V*AR%(escripcin- *AR%0A


87/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


G( = Gestin de (atos


*AR% = *abla *ari.as

Atributos

DTA"IJID

DTA"IJMATEJID

DTA"IJDESTINOJID

DTA"IJP"ECIO

N!ME" 8BN!ME" 8B

N!ME" 8B

N!ME"182

B

C&a-e Pri$aria (e &a ta)&a tari+a

ID R (e &a ta)&a ti%' tari+a

ID R (e &a ta)&a (estin'

Preci' (e tari+a

Cla/es candidatas

DTA"IJID PRB

DTA"IJMATEJID RB

DTA"IJDESTINOJID RBRestricciones interedias

RJDTA"IJMATEJID

RJDTA"IJDESTINOJID


88/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


*ALA (&'*%$+'

*abla- ACV(&'*(escripcin- (&'*%$+'

AC = A'%G$AC%5$ (& CARGA


(&'* = *abla (estinos

AtributosACDESTJID

ACDESTJCIEJID

ACDESTJP"OJID

ACDESTJRIOMET"OS

ACDESTJDI"ECCIONACDESTJP"OINCIA

ACDESTJOCAIDAD

ACDEST

JOSE"ACIONES

N!ME" 8B

N!ME" 8B

NACA"250B

NACA"218B

NACA"230BNACA"218

NACA"218B

NACA"250B

C&a-e Pri$aria (e &a ta)&a (estin's

ID R (e &a ta)&a c&iente OrienB

ID R (e &a ta)&a %r'-ee('res

Destin'B

Ri&$etr's (e& (estin'sDireccin (e& (estin's

Pr'-incia (e& (estin's

'ca&i(a( (e& (estin's

O)ser-aci'nes (e& (estin'

Cla/es candidatas

ACDESTJID PRB

ACDESTJCIEJID RB

ACDESTJP"OJID RBRestricciones interedias

RJACDESTJP"OJID

RJACDESTJCIEJID

*ALA (& CL%&$*&'


89/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


*abla- G0VCL%&(escripcin- CL%&$*&

G0 = G&'*%+$ (& 0AC*#RAC%+$


CL%& = *abla de cliente

AtributosCIEJID

CIEJ"AONSOCIA

CIEJDNI

CIEJDI"ECCION

CIEJTEEONO

N!ME" 8B

NACA" 50B

NACA" 8B

NACA"11B

NACA"18B

C&a-e Pri$aria (e &a ta)&a c&iente

"an s'cia& (e& c&iente

DNI (e& c&iente

Direccin (e& c&iente

Te&=+'n' (e& c&iente

Cla/es candidatas

CIEJID PRBRestricciones interedias


90/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


*ALA (& ALARA$

*abla- G0RA$((escripcin- ALARA$

G0 = G&'*%+$ (& 0AC*#RAC%+$

R = *abla de repetiti/a

A$( = *abla de Albaran

Atributos"ANDJID

"ANDJMATEJID

"ANDJANCJID

"ANDJECA "ECOQO

"ANDJECAENT"E

A"ANDJCANTIDAD

"ANDJOS"ACIONES

N!ME" 8B

N!ME"8B

N!ME" 8B

DATE

DATE

NACA"212B

NACA" V0B

C&a-e Pri$aria (e &a ta)&a a&)ar@n

C&a-e +'r@nea (e &a ta)&a

$ateria&es

C&a-e +'r@nea (e &a ta)&a a&)ar@n

c&iente

ec:a (e rec',' (e& a&)ar@nec:a (e entrea (e& a&)ar@n

Canti(a( s')re &'s $ateria&es

O)ser-aci'nes in(ica(as en e&

a&)ar@n

Cla/es candidatas

"ANDJID PRB

"ANDJMATEJID RB

"ANDJANCJID RBRestricciones interedias

RJ"ANDJMATEJID

RJ"ANDJANCJID


91/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


*ALA (& ALARA$ CL%&$*&

*abla- G0RA$C(escripcin- ALARA$ CL%&$*&

G0 = G&'*%+$ (& 0AC*#RAC%+$

R = *abla repetiti/a

A$C = *abla de albaran cliente

Atributos"ANCJID

"ANCJCONDJID

N!ME" 8B

N!ME"8B

C&a-e Pri$aria (e &a ta)&a a&)ar@n CIENTE

C&a-e +'r@nea (e &a ta)&a COND!CTO"

Cla/es candidatas

"ANCJID RRB

"ANCJCONDJID RB

Restricciones interediasRJ"ANCJCONDJID


92/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


*ALA (& C+$(#CC%+$&'

*abla- ACVC+$((escripcin- C+$(#CC%+$&'- *ALA G&$&RA(A )+R LA #$%+$ (& LA *ALA

C+$(#C*+R > V&


93/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


*ALA (& V&


94/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


*ALA (& C+$(#C*+R

*abla- G(VC+$((escripcin- C+$(#C*+R

G( = G&'*%+$ (& (A*+'


C+$( = *abla de conductor

AtributosDCONDJID

DCONDJNOM"E

DCONDJAPEIDOS

DCONDJDNIDCONDJDI"ECCION

DCONDJN!ME"OICENCIA

DCONDJCATEO"IA

DCONDJECANACIMIENTO

DCONDJ!A"NACIMIENT

O

DCONDJEDAD

N!ME" 8B

NACA"220B

NACA"2

20BNACA"2 8B

NACA"2

20B

NACA"2

50B

NACA"2

18B

DATENACA" 18B

NACA"212B

C&a-e Pri$aria (e&

COND!CTO"

N'$)re (e& c'n(#ct'r

A%e&&i(' (e& c'n(#ct'rN;$er' (e DNI (e& c'n(#ct'r

Direccin (e& c'n(#ct'r

N#$er' (e &icencia (e&

c'n(#ct'r

Cate'r*a (e& c'n(#ct'r

ec:a (e naci$ient' (e&

c'n(#ct'r

#ar (e naci$ient' (e&c'n(#ct'r

E(a( (e& c'n(#ct'r

Cla/es candidatas

DCONDJIDPRBRestricciones interedias


95/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


TAA DE SINIEST"OS

*abla- G(V'%$%(escripcin- '%$%&'*R+

G( = G&'*%+$ (& (A*+'


'%$% = *abla de siniestro

AtributosDSINIJID

DSINIJCONDJID

DSINIJECA"EIST"O

DSINIJECA"EPO"TE

DSINIJECAOC!""IDO

DSINIJECACE""ADODSINIJ!A"SINIEST"O

DSINIJOSE"ACIONES

DSINIJTIPOSINIEST"O

DSINIJESTADOSINIEST"O

DSINIJ"EIST"ADOPO"

DSINIJPOIASINO!C"ADAS

DSINIJPE"SONASINO!C"ADA

S

N!ME" 8B

N!ME"8B

DATE

DATE

DATE

DATENCACA"2 30B

NACA"280B

NCACA"2 20B

NACA"214B

NCACA"2 20B

NACA"280B

NCACA"2 80B

C&a-e Pri$aria (e &a ta)&a

SINIEST"O

C&a-e +'r@nea (e c'n(#ct'r

ec:a (e reistr' (e& siniestr'

ec:a (e re%'rte (e& siniestr'

ec:a (e 'c#rri(' (e&siniestr'

ec:a (e cerra(' (e& siniestr'

#ar (e& siniestr'

O)ser-aci'nes (e& siniestr'

Ti%' (e siniestr'

Esta(' (e& siniestr'

"eistra(' %'r e& siniestr'

P&ia in-'cra(a (e&

siniestr'

Pers'nas in-'cra(as en e&

siniestr'

Cla/es candidatas

DSINIJID PRB

DSINIJCONDJID RBRestricciones interedias

RJDSINIJCONDJID


96/113

#$#%#$%V&R'%(A( )R%VA(A A$*&$+R +RR&G+


&'&(&)&)******

##'


A'& (& (A*+'

##'


*ALA (& '&G#R+'

*abla- G(V'&G#(escripcin- '&G#R+'

G( = G&'*%+$ (& (A*+'


'&G# = *abla de seguros

AtributosDSE!JID

DSE!JEIJID

DSE!JNOM"EASE!"ADO"A

DSE!JN!ME"OPOIA

DSE!JECAINICIO

DSE!JECAINDSE!JCOSTO

DSE!JESTADO

final base datos (2)

Documents