Scribd
Upload
28 views62 pages

DBMS & SQL

Uploaded by

Neha Mehndiratta
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
28 views62 pages

DBMS & SQL

Uploaded by

Neha Mehndiratta
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
[Bat |] Perey farms] Qale bare (> eee Ts i ne a oer Fool aurchacacpresdsheel—as-theey _ toould E —— f |_auat Sed chy mt _ eo eo td) Acctrcny te —— i re oS a cicdan la _poelly accusali-os Ft Sosa too anos ! 2 (cn onl a bea Sr 3: Nj esa date bare tt $+ 20a > Uplate dab uatg wataus—saka Mark Y Language (Atal) — Walle « Ly” Sar i. we _ ga NS ee 6 ER pce. be uastoud eneiied —o_onsuseAcenily of dalecthore : loging dalabare and © | oy tating vers Lomebatl Ios dat. a J ‘t Dt eneure thrale ‘inte aceurdl&, 4 at Conesctent aoe wz <5 Bia te dew dob (2 oo 2 | DE As voy easy tr_accom and ; ze Buch dale % datatares thy fe doe Uy vty OAL i. é Gd : L : “He dak daa me si E ov aa ines Dali bane Decors larglaaye — ___ (A) ACER a LS Dali [Component f- database. —_ (2 Po databaye yrana fn By tivn ts Ouse aly ] Wnt _ more than —a_Com i i oy ne puleaiged — snp OR! bela Boy p-DBNs by a Sop pill “Tatts des ' ged te_marnage—aed_oAganiy eg Aland reltens oe ne Gente a sng tay) and aceasta dor dada we) Che) 4 ee PEED ; SNGEPD A [-Coreapt of, Dems] ) i) ote, cugealaatinin’ alacant ies | —~Ond_xtoie dala {in _a_shructuced mancey, rocks, 1 Goaded | a DBMS provides merhauions fox ey dati toe g ty teh up o “G0 Dali eon to och Poa ota gs bo canage ot) pate ts ; eee chastegtainkatng asd : } CL Corn lea Syst ine Ci) Cory tty (2) te —“ poms Gan_he_Coco}pleoe fo Sok lp nd pnatnlain and regia jal, hnowlddge and shi” ‘eh Ce rferenannce gueshead (>). — he bg by lersel_ Corr OUR tured thets—pea, Wace. lof pEns a uy odelhend : P from ts i (iy Lemiléel_ we Crests A rng trae 20d hetyle— eae 1 Consislency A Geourity and may be holt >’. Aowed by! lly bibeot dal, Sto PRT aaa | Leal sal o oan fo [geet ty fer of 06H pelaenel pars (2d ——_ gat ee Fao -omd Columns asad use| (Sei) Sheucchine —B d Pape Alans jy fa cr tter land fi Herr dati As neganged Wee @ tree. Poo ex: re oe * iu (o_Nefroorle pans. A_nedinoAk -OBM Co : oho He dal _tkmonti_raaliebalin. <— : UH) oem pfo_noay La) yee oped tie gece Ee Ep for ore Chl ee _ On. Aeadrer—Lorn—fonch Sia —roultiple- defor are ; Mat, § shoo Iselaor = College) ) re G C ra a t = € 1 F { Nledtonsls Nadel 7 (fi). Gctznal lene & eee -axlenat — —— ES vied Mien - = “the. Snfen Snfernal_| i thas_an ele fo ~~tahdeh dosent bes Hoe physfead tlovspe pdeuchires. | | dota bare: Ylernnd Chorna we a physleot we - Boheme 2 - “ Giijsect betineols pans a fomges ants | ADeMS py RdlaMonsht fa bo tne dablen |) Rela Hands p bio elem e a i | Ahi c_rovsf toe —GL2 AML, Pexpso naxx | ¢x- Muysar, Post gre. cL } > oS | Rohit “_ Aihhbubel> in abiatbute tsa piece off dale. that< 7 _Beseribe_o1n_enfity Pore. = Bn cbooue,.rchatiota _1p,SAliet Ned of, Abb bule £2 wy ; mse delis_abele falling — typeof —obtalhules (2 zc : : ; - ——- 4 bale 2 Aes of SS = le Mids Fas ienple_atttyfbules Que there thal ~stannok be anti dulled 4on-40_gub~ afut bes» Por en. - A student Rell-ro -, Age, char —_ —e£ aS Pit "RO — Gamat 6a anemone — ip phe plete ‘4 A tpl epics a Slagle Gatlaieet — j "Bach Fife Canlatina 2 Selr of, ualue, ot ot Shukla l= Conneapotnd ic _ mefertntion Ba) ey cee le | rafal shoed_hefet_be tonithery fo dik — or dlaleg gauss plat : ———Domatn fe deft initon ons ae Sagi al 8 pnt pec anetton — } [Link].t ae Byala di tine teareirelegy 0. domain | Nefne. ae Uke range of vabua dor a octet a be, Con San} Mie dnerntin 48a agate Ree values ean fee-an-abtilbalee Gago. sabl ! en os oe -_aom sin of ankle gd 7 tan —accebe— Fama. Pebanaiy ome 2h, Deguee 62 Bk ne ta at Fao eet attarbutis Gy 4 Aol ation detévmincs| Hao —degror..of: Q Adlets. , “A Relalien havi Sottlul $. “die dé 2 Relalions de eine, an20,-bobd. of eg Ace. Be nay, ralobon af _degace a — Talat ds iar Aclabion off epee fos. necay hasdrnyaltdey Ghia es Joy _a-datrkaser perc SyslBeao»—$§ —sharolinelity La tre —auunber afte Pie Fin : fy peo of Gotten Gn _kelnoee table arseet- * one _+p_one- amen many — ‘ tt «en fo mony. entity tus 2 fe} i aaa aE] led L Sea] ABI f Ny Saez Ww Te A \ Sm "| Smalayess [> —Iut sb i in \e [projet a ; ( : ee ci 4 ae” ~ pans. Ay 4k te BT an aba > tahgiely fdas © Saas dn -Q pelation- used _to_extablih = fn, aloud: a ae Ley cag) ae foie Ce Gi) Carndbalate key t= The offidimal Sel- ofc att orelz, ea sua | Ndenfii ebgee Ja_kKinocnas Qa TEE Icey: ee Pore» Cp Min student relabion. — = 2.49 .5-Phonesne-} $s 4 Combpulle. Qudidal®, bey ° oes fs ~Aatlifirnal_ up| key ee 2 PE Gn Coakahynittvaluee Tk rusk Gntatn e unigue value + bey —dedate mus b_ Panta atends Single Gost tp he, Con Faw, eruthafte, Candie, Key A Gandia, key Gr be. Simple 04 lempnticcos fel. lig ae te Ce toy kee vice wrsa ( — € <— 4 i 7 Super Relation DID Pxveary iGrdidole, A an Sxpe [eey J ail a, Jt 4 Allenals. i ee - Se we Ma ge i i 4 : eee ee ea ae eee Lote te ty ty tet Cot la gly a — und tin dat, poe desig, 4 eD PrserKon Alo Votlatien f - ie 40 ON Delekoy ¢= try 2 2 ontdelele, No action > Nok allan ; . (D_on Celle Canecade > Parent del N_oelelé Sek Alutl > Gek-nutt $n child Relatt Hy \ ' mn iO Onan Yotlatian —d Dele Hoy, No Problena i ——_updation > —Giaiclly Restete of [ Strswstured Quest langus4d J Dale Deffnition language (O01) 63 ei Bibs tired to define heuer t watab of dala. a fal Te dat, validation Gusbeink. — mob ppr_tommand_aretss ORB ATE DATABASE — Casale, a nea dalebare — RATE _TROE_= Creal @ Korn table : *_ALTER dhe — Madifat tab + PRop_aale — Delote b dass freab- : art of rites ty a Sie on ol ed Completed ard tf Depuined qua Care WW — Che made Undo the “|e SET ARaNsation) oa ul. jews Aallback tao Hay bolat fr Aeuaen 2” dl co felipe rn — | hak ea, ee [tank Senet bee tee fo, Decmn. ke A [Gch detn| - oe Ainae_| Stores the Hime - HH: mame. “ lee “tn audigit ot 4 digit fonmb Seen te Gn be feos (pose) ee i; ara eo i i f bral _vngytined but toe debaut ose ie aati and You nual efneS Dong, her Crealih A WReeta fd ~ oo om a * —Oiwhak § ora FIs! Se oe hag se a Conn eee Sete ae - Saye a —_______ Cheer [ename., Sal, fob ile Gene 9 eee ee (fF Sat atopy. Whose Lal. sZon¥/ —fRoM_erap di ~~ FOHERE_ orp de debating Helden it ——____Anip. os =n this Hina $5 lealivg Hat Cal avo orth Drm key Conshoinls / a hefaattConsirsints # Check Constrainlg F Pore key Graben’ « (erode: %w agen NUL UINLQUE, 1 2nane __Chane(2.0), No luis i Sem + Chants) 5 i Calane, | I Vaneh M i ich M “at Y fe ONSeAT PATS eee s at = hey deena ——folurain ast pfirnany ley of fale —__° =e i — oe dette Polls Ghalemneinl G2 “t } iin aa a ‘f: | Stade — le sons fore ey, & a 4 Sex Charl): 4 “at es a tate ke < elienaeeatlion $s Ynsertad onthe Held. x honncides_ tine Potssing _Set_Clatlenntsalf. __- @ __ React ef aia 4 __teli 1 “loa (__etode 4 atigeA ‘Not Nowe, painiady leey, —ename—clnar(ge)_aleT uu, —_— ee 1 Sex____clnarel4)__Nog-NLL, ip theele Lonshaiuks —Pheale Censhainks $2 7 Satie a) otis onstrate Ln b value that h ae Rnseted fntoa_Colunn ofa table } Hanes, Conshder the 4 felling 9 Male See — i ee eee bination, ORY kay ee nil af i i Jetetedetodedel ae et ee ithe ft th fn) anata ep een tas Chan RefeR 2nns (ana), x 4 —-- a eee ee et eer ek : ed ctabte, [Link] _-Ig_used_to_crealta_noa 2001 dali base. ____* [Link] a onesie _paraonsedalabuenames _____Gtaenple 2) CR are _pavaBise. festoas. ~: .— USE paktdoure 6 ————____“fo_toera_ratth a_dotinhare. toa SQL, to mam the use Stalencent— {ce eee. gqu ts wad +o ——Sfeetly the anne of the dotabare,. se tout- —t6__“Seleot Af Selcbing the. dali, bare —-fan_ Lawious “operation en tt gud, ay _ a allen aries ornate fe LideRe chart Can be fiver Ae -feleet_oo vrling, more general Cord tion -_ ~ 2 — prop varmanse testoas CReaTE Toes ts able are diffinacl sh Ha tre Crear Tass ——hematind.: ohenatale % Crealiol 95 Cowra arer el cola pedi Afoer are supplied [1 oath _ [Soa te Social Etone athena one Coburn. Syalaxte la ——________CReAre tane LF Yay work to See otic debe « EX Breet a Pao t ane date Gude table bs : = “Valls ane. placed 4 : | homnored. From ath ibuté, of 4 Arloteon sith Horee _-Gmeard. “INSERT, Derere and_uppere. “ther. allan _ dakood to 4in Sata Update, Conomard In genorte. ¢ i "Angee tal Conarnand 83 je s lation kg DASE Gromand Gn sah gntax ca 0 =e INSERT tuto | | LH \_o| eels (9 __. !) Hae = | ii —=p—__Sévecr bende, en Pde —gnets Pom ee _ ouege (giade en] ("grade "e')! j-—_____} ple Condittesa Cig Sel Sheilermnen toy WHERE claunes Por ony ss ee spaderag sreys_| e (grade =" £4) pnp _ "A.000) ; Spl) Na Wed. o pene eperstor. Nea enalit fo je-NoT operator revere. the mn a, Le legicel o apencton wilh which ls used. Oe. Alor exists, S| NOT Beriteeal , Not Tal pe. this 13.4 gegate cfpeactay Pee HK > __Sbibor orade, eee ateden gaat Sy eee (nor Getta — _ SU" MO] Ave peed ” toed an NOT Teeter See 4 hired bor sth ota A (tu) PetHsee0l ee Sy fe. eens tale dge Qa donge tf Vale Hale Hae me ads. o Hee ood 4 “ow haseag Grtlude Lobe LO1S ang 1 — hh lols i ade deep eat “Wd . GH BETHEL 20 fain 5, op. ofan and, Aon bath o1e-—I Prelusive. on aust) Ile ee 4 tL ones i BeTOeen: “aera thal ply Hoe Asa thes. " oe not! satisfying He Between Gndttion ax oo Aelaoved: "Pod _escan ple. erin ple S29 " Cececr pales “dese fPRotl. fly ; __ WHERE, Rol... Not. BETWEEN [eo AAD [0004 — (ARs. query cal lit ha $n tohere Rote fs tole [oe dk. ABoure.. I Condition Bantd. [Link] ra b e —aa_opeatec td ——_ = ~— the DN eperator fs _usd— “fo Comptes ovale. daa fink of Lifaelil Hyak hates been Shecitied: fo} 0K yp — “te “dish. alist el-_membeas fama ‘pert, ‘sll yen mI} ake. 2 a | ot Bh thal ae Hs = D+) the chanel. mmaloh_a , — Note. Palteun_a Hak C “EE pl toe zs ° DA_Ox <3 : ; ae Mae ting fet tere V2 a 3h te member_tohish nae _aneas 144th plana. — Slant waht 1a, the Cametond bln Seeger aria ty _ —P— E —PRonl__empl { ptvate i here i i 2 eg [Bubby fp rE <7 lis tre anaes_of-ermpleyeetdlae%e. Name. coding or loft “Pir output | oh Select Name ________ inane | =i Pitoe!_enileee. ——_—_I jyrg] ISHERE lame! Lice "Yo s 22 hewlie o_query to_dislay the neme_ofe pets hag Caarctly, fous lette1_narheye (sé table pet 5] we Gb. ELECT ™* ROM pelt _ TL WHERE. name. LUCE Ma" 5 zs Remhisg 4 fo Nowe. 69 (Ls Nu)? : ee the NOLL Value tag ~. elu Gye Searched 4 fod y_a- i ~- Uline Ts ule iq (HERE Clastic.. Pet et!=) - | eer —ernfene, &mb name, fob - Pore 7 ee ainEnT ce i ania aad - _ _£s Nor. NULL - ee ies ae NDLL_Ualine tr giabl. 7 G (s.Nor_stuLL = ly_exde— ge + [Link] rame arr rye LoHeke deal, LS NetNULL, + a — ‘ te. Cage oe ([Link] nf Sort —ke_don: odes > tthe dota the result _Ahe OR DEA aaa an aay ELECT PROM ayn] 2) distinct te ais ly_diddiaet values of; tne argunnerst | a0) ASG) 2 Anis PurctnGrafuke fhe avergytof: ae Ds wo _doka Por @e- — 4 ” Sevecr Ava (Cet) “average! . PRM emp, 8. Coors l- aie hy 4 no opt fr a a | u Serber COUNT (Fob) Gumk” pa. erapp-dg > a Sateer_Cente (brsanergah) PROM _emp4 ca 3 : = foora_a given Column : | ~ Cerect ax (gat) {tt tp £ MIN Athi —fusne-tian Ackuse cojnitaum Walt : Bt Steer na) roraog RON aap} al § Cumio 1 i his es Fiver Column er Serecr Com (Cat) PROM _emnp>4 5 ea, me than S Cason. ~~ ereer count (custemer 20) Co I pRom—_Custunness a | Yavin Count ( Castoraaven > S} i ees “par nero 45a do-deenouc_~ duplicate valine. 4 petiole Cuma. * © fev eee_ Seveel eis Aer class — PRom Students = re tence glug dle re ton Shidege Alsen z she. use. of aliases fs te addon. aS fable 01 a Column 4a SQL _tolth oul: thai] i eee Hae tdatiioay. Ff Pe a ie le AS -kepeod. | —Dk_fs rebut usher woorbiiay whi} 9 Conapley | pol vig coup 6x2. ad al tela Seale weaenehs hy ansiguing | names _-to there babe aoe, ONS RE: fonsfaety — | Your Sau query tmneme.._r2addle._and coisa do crated __ Perén: _Poren9 Serger cure 20. 2 feo Customes, — p—Set_the Columa nome_( ho. “eb fen eee Tein i_agu thal Combines — _ feo 04 mete dable. ya. fotin [Link]— one _table arg Usted SinfeRon Clause, Pe gcc ofp -Gonbhring-. data. fron noultrifole __tables_fs_Calted oi rig. st sat pei dake. eon errs aahatid atolea, Fac d cateel adel eee Kote - rns +Join “= Gooss forodiieky Condlition)— Fanatic §s_mres_olgtein Lured cte_Deslserag. the —foira_flunclion tahere, toe ener node tablet have. Conniagoia_Coluunnr) i ——FFvr_enanapte 62. pct ory fe SEL CT patienl_no, description. Change — ory bill fern a WHERE bile. ‘i die athe, Stem Lede 5— he above- -quey- Sis folvi tables billed — pn Hees beget Sen foes. (cabepa Bamba 5 \CdaMostaan Produ’ eo 7 $e Bale tai, | produbt=. —4_o_ppoduet 0} 100 tables whose result =table ——Goasist_of atl Porsibteond_ondored <2 Sete. DE Jy usefull toherq _you_woanl fo Combine. —Aow Pron one_-talle sith. einen Ae fibl _—_ Another able. = fo ala, mple bem Sitter tt exp dept " Cl >} A @guicteleng N iat aan ake ane oa ate fs cegutabily fs Calo gut <4 cin. HO4_ OK» > Sévecr * a zat : Se recep - “abort. tab nek a ee Bape ogl Genes a cytes == CR UC on cong ten it Caters __— skp ace es lena ie il 1 a aad, Cena i — toa —Myfal dabbase ig, —Cmeck_() _Pavection 0b — eee ee \/ . veg» 6 lenneatot “pak 2 Boe mt =the =e function of mysg):< Connetter___| ___ establishes. Gonneebion too Nyse. datebare asd —| r page four _poramclixystahich ase __ Bh _—Lonnection -object> = mysp/- Connecter. Connect (host ___| Nos.-iname.>_,_User =< Username. 2 Passio] _—< Pourssaord >, [ debi Pe ses_Wisen_ 4s the usehname on Mycap~ => Pamisord | Parsicord _t> the areisod of | Hoe turer. _ I iciteal seacflene the -Addahons "estan Weta | GA Tp ~ addnom K aa —P 22x00 oho tos Sec pou coro ae “lacalest* Urey “root | —paasied = “by pura”, daliabare =" Co eg _tunsor dentin po incite pl : = _MYCone Cursos L — Gy zVovialler =< Curser? + how. . Rado bobo tot tet to bo bo bo the Envidoment. Si ie opin a hf fo fi hotly an) te self it 7 Yat one used ochaeldalafrom e_febdrall_t) metfrad i 7 oh |_____—_ } jl_aukuaa all the eros for tee basulle = Lunsor+ fet chats i) “ole Efe ce teh att the 1ecora fn Wetegt| Coun t= WCir9804 + rovocount ; aie ey no neben ta by Cet Qyaups byte Atgule cot “Tro Tne bjt [aye [Grae] 7 [ to) |. toca, cht aT gs lime 1 Jo. [Rant _| Demy | 21 >the outpul: produced paboue. [Link] *__z Result -af Cursors doo Court | etal 0:0} sows rebieved Gn noaullcel sg. Li, "karan' e420, (45 Perini | pe fat oan. 0S IS Cun feet (231 "Vin! ‘python! 20 ‘A ) |g, Lc He ——Ulet, "Aman! On) 21 tae) [Link] sahteh § brinted — ~ Tt) pee i (ro, ‘Karan }( 201A) syle : : t ’ L282) | Peketerany eo) + iD y = @ Peter pone [)(Methed 62) the, Pebehane (na Hoel — ee indy anand a i 6 llega ft. fo a Psat rates of the —Aesutfsel: as soon ai — Te atime iin Ha ect ie 2 by tia poll. 10hem you Pelehoe ame Deter the polis. moves fo _‘Nestk” Ae tarr|_of tae — __pererd tek. next fyme, i the coy ta te keh 2 ‘Alter foited by the Pillar an affes feta r “eN 7 the pei maae dm the neat Ae ok te ) Edw ail babhe ees emi “| Postale Udall = Cuts felchone ) 0 Cont Curses roi . Lu. ' 2 Prom sober {2 Gem (lol, Kanan’, Tete yat2o.) AL) 4 Import rysgl- Ganectox | al Connection = my Sel-GnneeTor. Conneed: (nostic a “Peathdb’) “____my_ditabare= db Gnneckion. Cusco) . % "Apa He Comets ox ead define eS ye que trad y i [- Le fe | —— fas 2? | _ 3 Pet 2xaenpl _ es apie seat_ anes Accord Gls ——4labde_snamned feeer inqnl_twe Can wate Ge DIE Lag — ——panpiotacd) sates wALues f+ 4s yd t Vales = C*Catiy a) >» a \ \ \ [ipo tneneed_to_ateerly the query tig Tage rote tall py a _——y_dattabare.evecult (691 query values} update, the evicting netord 6) By pdote. tho pusind =D = “upphile Tenet Lotual CET Parstosd =f le = AdCIAMe = fos : WH ge Yyolne =" yao" ig") — 6 delete Aer rceord_ to_delela a used, — ith ugermame" Cofa" ede ee Spl quay. =" DELETE _QROM TEACHLOGIN LIHERE Useuname= wc” vali. = Casta’) - ——tay-daliabane, ~owewle (plague), Values) —Note=> Afi eteeutiog the query, Ge need ao SS _Grentite_ on dole doba | —— Commi) m of He _Gnneck -cbfert- anil yay 04. db Gnnection. Comma} iE). —_—— ae \

You might also like