Banco de dados ii (exercicio anhanguera)

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 € hv srner 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. ulcdds slc 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 fo dpraet; 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 nm eet 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 r