Banco de dados ii (exercicio anhanguera)

Disponível somente no TrabalhosFeitos
  • Páginas : 5 (1053 palavras )
  • Download(s) : 0
  • Publicado : 10 de abril de 2013
Ler documento completo
Amostra do texto
10/04/13

https://bd2- 2013- 1- unipli.g oog leg r oups.com/attach/fa0f37993141402f/cor r ecao de hoje.txt?g da= r tFM bEYAAACGAy4Hl0Iy3Suv0w67dy- zs- LaXvxeot_B…

- CNIUÃÃOD CRE‡ƒ D LSASBESLC
- OTNA‡ƒ A ORÃÃO A IT OR EET
- Epeao
- mrgd:
mtiua(ner 5psÃÃe)â“caepiÃra
arcl itio
oi§µs € hv rm¡i
nm(aca 3 psÃÃe)
oevrhr 0 oi§µs
nmdpoitio4psÃÃe)â“caeetagiapr tbl Dpraet
u_et(ner
oi§µs € hvsrner aa aea eatmno
dt_di(aa
aaamndt)
slrofot1, psÃÃe)
aai(la 02 oi§µs
crovrhr2 psÃÃe)
ag(aca 0 oi§µs
- Dpraet:
- eatmno
nmdpoitio4psÃÃe)â“caepiÃra
u_et(ner
oi§µs € hv rm¡i
nm_e(aca 2 psÃÃe)
oedpvrhr 0 oi§µs
lclvrhr2 psÃÃe)
oa(aca 0 oi§µs
ocmnofot1, psÃÃe)
raet(la 22 oi§µs
-5 Arsnetdso sl¡iseitne n epea pr© oiaeetas
-) peet oo s aÃro xsets a mrs, oÃm mt vnui
dpiiae.
ulcddsslc dsic slrofo epeao
eet itnt aai rm mrgd;
-6 Arsnetdso ddsdsepeao.
-) peet oo s ao o mrgds
slc *fo epeao
eet
rm mrgd;
-7 Arsneo nmsefn§µsd cd fnin¡i cnio n tbl
-) peet s oe
uÃÃe a aa ucoÃro otds a aea
epeao pr© casfcdsafbtcmne(.Z.
mrgd, oÃm lsiiao laeiaet A.)
slc nm,cro
eet oe ag
fo epeao
rm mrgd
ODRB nm AC
RE Y oe S;
-8 Slcoeo NmsdsDpraets
-) eein s oe o eatmno.
slc nm_e fodpraet;
eet oedp rm eatmno
-9 Slcoeo Epeao cjssl¡issjmmnrsqe10 o mirsqe
-) eein s mrgds uo aÃro ea eoe u 00 u aoe u
30.
50
slc nm
eet oe
fo epeao
rm mrgd
weeslro30;
R aai
50
-1)Arsnetdso fnin¡iscmsl¡isete20e70o qesjm
-0 peet oo s ucoÃro o aÃro nr 0
0 u u ea
Vneoe.
eddrs
slc nm
eet oe
fo epeao
rm mrgd
weeslroBTEN20AD70
hr aai EWE 0 N 0
O cro='eddr;
R ag
Vneo'
-o
-u
slc nmeet oe
fo epeao
rm mrgd
wee(aai > 20ADslro< 70
hr slro = 0 N aai = 0)
O cro='eddr;
R ag
Vneo'
-1)Arsnetdso fnin¡iscmsl¡isete20e70eqesjm
-1 peet oo s ucoÃro o aÃro nr 0
0
u ea
Vneoe o Bloits
eddrs u acnsa.
- Itrrtco1
- nepeaa
slc nm
eet oe
fo epeao
rm mrgd
wee(aai > 20ADslro< 70)
hr slro = 0 N aai = 0
https://bd2- 2013- 1- unipli.g oog leg roups.com/attach/fa0f37993141402f/cor r ecao de hoje.txt?g da= r tFM bEYAAACGAy4Hl0Iy3Suv0w67dy- zs- LaXvxeot_BwBaN…

1/3

10/04/13

https://bd2- 2013- 1- unipli.g oog leg r oups.com/attach/fa0f37993141402f/cor r ecao de hoje.txt?g da= r tFM bEYAAACGAy4Hl0Iy3Suv0w67dy- zs- LaXvxeot_B…

AD(ag ='acnsa O cro='eddr)
N cro
Bloit' R ag
Vneo';
- Itrrtco2
- nepeaa
slc nm
eet oe
fo epeao
rm mrgd
wee(aai > 20ADslro<70ADcro='eddr)
hr slro = 0 N aai = 0 N ag
Vneo'
O cro='acnsa;
R ag
Bloit'
-1)Arsnetdso fnin¡isqesjmVneoe,Bloits o
-2 peet oo s ucoÃro u ea eddrs acnsa, u
Fxnio.
aiers
slc nm
eet oe
fo epeao
rm mrgd
weecroI (Vneo''acnsa,Fxnio)
hr ag N 'eddr,Bloit''aier';
-1)Arsneonm d tdso epeao e lta mnºcls
-3 peet
oe e oo s mrgds m ers iÃsua.
slc LWRnm)
eet OE(oe
fo epeao
rm mrgd;
- prmisua:UPR)
- aa aucls PE(
-1)Arsneonm d tdso epeao amtdsaà 2/321.Cniee
-4 peet
oe e oo s mrgds diio t© 00/03 osdr
dt n frao'YYM-D
aa o omt YY-MD'
slc nm
eet oe
fo epeao
rm mrgd
weedt_di < '030-0
hr aaamn = 21-32'
-1)ArsneaM©i,oMir oMnretmÃmoSmt³i dssl¡is
-5 peet
Ãda
ao,
eo
ab©
oaÃro o aÃro
pgsasepeao.
ao o mrgds
AGslro,MXslro,MNslro,SMslro
V(aai) A(aai) I(aai) U(aai)
-1)Arsneam©i dsl¡i pgsprdpraet.
-6 peet
Ãda e aÃro ao o eatmno
slc nmdpo AGslro 'Ãda
eet u_et, V(aai) M©i'
fo epeao
rm mrgd
gopb nmdpo
ru y u_et;
-1)ArlÃÃod tdso sl¡iscmaqatdd d fnin¡isqe
-7
ea§£ e oo s aÃro o
uniae e ucoÃro u
gna cd vlr
ahm aa ao.
slc slro CUT* 'uniae
eet aai, ON() Qatdd'
fo epeao
rm mrgd
gopb slro
ru y aai;

- CRE‡ƒ D LSAD EEC​O PR APIER POA
- ORÃÃO A IT E XRÃIS AA
CRMIA RV
- a FÃauacnut qearsneadsrÃÃo oc³io auiaeeo
- ) a§ m osla u peet
eci§£,
Ãdg,
ndd
vlruiÃrod tdso pouo qecse apri R 100.Arsnee
ao nt¡i e oo s rdts u utm
atr $ 0,0 peet m
odmdcecned vlr einr o pouo qen£ psumdsrÃÃo
re erset e ao,
goe s rdts u Ão ose eci§£.
slc dsrco pouocd uiae vlruiai
eet ecia, rdt_o, ndd, ao_ntro
fo pouo
rm rdt
weevlruiai > 10
hr ao_ntro = 0
ADdsrcoi ntnl...
tracking img