» Unit OY an” $0u + DoL [bata defination Aanguoge ] CREATE = Jo eneotes uly in DA «aller ALTER Duco Of the DB fodboling ep calaier “4 DROP '- Aebety why “pure DR fob Ce deloctosp TRUNCATE Remowe Ol oUcotects Bitom 0 table, Uneluolin Comm ent: dole comment tb thy olote woliete, : 9h student ( fl, addin, name) pera SORANT = ye Unter Us ae roe ines of olf — REVOKE '- uicthobseouy socces pruseliogrcl Aten Ltn ¥* DML [data Manipulation danquoge] INSERT 2- Imat volote umte Joble — UPDATE polo Lausbing voloite within vo Yoble > DEAETE 3 Meliter oll sucorols prov Yobls, the 2pace fo Dt sured surnoine * > CALA Lolth oe PL/ S04 wy oa Aub pgrr expan pLan:- explain occur poth of lala L> ,oul- sto Lonbist Lerewocry % pct [eata Contyol danguage ] e5commiT t- Lone vis plone - > save Pom7 t- eofn Lote voll ark - 7 L the Lost como > Rodd BACK I Restore DB WO -Orpnol Aimee PR eh eu 9 SET TRANSACTION 3- Lhampe Tromoacten eftien cr oor Arqmuanct ce Wet (9 Gi RDN T/ REVOKE E= Govan f Yolen ork -purrmittion Lo ov Jer Tht woreclu, ULE" oe pow (bata Overy Language] BS sesecT2~ Rbdine lola fuwm ths cLotobore ‘Scanned with CamSeannerpos $04 S- xcote wlotobare Syotap o- CREATE DATABASE volotobote more } Exit- CREATE DATABASE employee 5 | x Dkor DATABASE Syatax- DROP DATABASE volatobase mame 5 EX! DROP DATABASE employee ; y% CREATE TABLE mptagi- CREATE TARLE toble-nane ( ¥ DROP TABLE ex pRor Thee A ty Column 4 costitype » pouons 4 ~ Colin q» datatype y ae 4 ; ¥% TRONCATE 4 Ex: CREATE TABLE Pexsomt ( TRUNCATE TABLE Penson Id unt, toble-name 5 tname vssehor (45), ex!- TRUNCATE TABLE 4 Fomame vauchor (225), heres : AL sUUAL Udo (225)5 wot " avosurhox (22 5))3 : 3 — Usifosns sgl PRMARY KEY Umabroun® pRIDARY uae ‘ \ vale 4 CREATE TABLE Power C WoT woul 3D unt NoT NULL pRImARY KEY, ‘ Lost Nome vouthoX (25) NoT NOLL) i EIRST Name voxchor (255)5 pge int } ‘ , ' ‘Scanned with CamSeannerbabes -X AATER TARA E » FYMOMI= ALTER TABLE dabumame ADD Colurmm-nome aotalys, AATER TARAE Toblename DROP colored cloluret ndrnes, SD ALTER TABLE -ALTER {MODIFY CogumN ALTER TABLE tabl name Sal Server/ ALTER COLUMN talumm-name datoly pe , MS ACCES RATER TABLE tobls nome My SL J oracle MODIFY COLUMN Column. nome dotolyps LTER TABLE tobls mame . econ oracle ‘lolr @ fate MoDIFY celumn- Name datatype 3 Pe SOL FOREIGN KEY on CREATE TABLE CREATE TABLE table mame ( CREATE TABLE orders ( Qxcdix ITD Int NOT ANYLL, Okclix No- nt NOT voll, Person Ip int, PRITOARY KEY Corde JD), FOREIGN KEY Cfheut)en 1D) REFERENCES - Pexsends (Pexson /D) 3 Scanned with ComScannerYm thet an valu wo a Une combimolion wp met mut £ unique: Mniguy 1 the toch Vodblu: “= POREION Key i mi, L lembif uw Kau, Sucwrd: un vamsthin toble - 4 CHECK a tmuvw that vill wolue Un va column aotity a Abretpce vonoldion (> DEFAULI Sti A plifeutt volun foro Kaliunn when cre > INDEX : ud te cxoots $ vubuive obate from clotaber Efi- CREATE TARAE Persea ( ID int MoT NOLL ost Nome voxthax (50) NoT NULL , first Name Naschar (25) 5 Age Int, P ity voxchox(S0) DEFAULT ‘DELHI )5 ) ROL AIL whee ~ a * Constraints In SMa ww, TAty ru urteal Le. tpocihy rutit fot She plata “ ctocble . Momibuounts Ase wittal ote Limit thy Lypt of stat, Crap Anat com Yo Tntotable- nis pantivund ar aecunacy 4 seelabelity wef vlote um te wn tobh- Ua following veontbcoimt: ot Lorwenon la ss tn 5 La Not Null mame thet the aliummn velar mot Rowe va rtd Ome acolut om > ongue ome cael Scanned with CamScannerwh velo eoribruoumls worn volie sey dusrol So wrssxt © Blea Juke GiET DATEC ) * CREATE TABLE Orel, ¢ > SOL DELAULT on f Be int Not NULL, ALTER TABLE Por » Ovo Numbex Int Notnukh, MATER chy ser ovoux hate data DEFAULT GET DATE ()); DeppulT hn eLHl ); i ¥ Inne ye They ad une dup Quit to pinot bate drone dh ly » CREATE INDEX Emp- S ON TAB, Asc ~ p~ Sotory 48 Emp (Salary Asc) we Emp SALARY 4Yooo » 5000 ap 3 c 300d NM ROH CHECK mR CREATE TARLE Persone ( = ID fmt NOT NOAA y LNOme Vaychax (24) , Nome voxchar (95), = Age int check Cage >=16))3 x Sesect Query Lulct ¥ from Tobh name ; D eye lect * fusm Beoplaye 2 5 ALL Doble uit Be ropAsored - Diy Seteet 105 Name prom —ererplapte a nly IDX Mame sealisrnm uit be oppeorsed a tim) Cabrct * Employee ushue IDs 1 , ? » > re owame | Solay [oenner | [oie A LTT 5 —SE— 7 ‘Scanned with CamScanner—> ANd, oR EP NoT Conolition Sulit * tinplope wshve Gremelse = MAND Gy = “bexHT : ; Srbict ® open veuttemec whut to BOD uty = ORANPUR’ : J = SKANPOR DR Sulit * fuer urtomede who ‘ > oly = “UKNow?; AAA 8 ow. Sd lit * prem vuuitomve wihow NOT Cy GER Ang M% SELECT ORDER | BY oo e oe Pe F INSERT INTO STATEMENT 44 Ga posible do wwoitr the drevet uinte ttoliment um moms $ the wolus te be wut - ) SNSERT WTO TABLE (conurn 1, Conomna--- ) VALves (Volusi, Values - ) F « Ui) INSERT INTO TABsE-name volu Cvalrt, Woluus N Ye NOLL OPERATOR ° PERSONS SELECT LastName, First Name, Adobeers From , WHERE ADDRESS is NULLS 2 Eme ADDRESS pec [199%| XV2 prok |e 98 ABC pavoht 126 Nivel rr ‘Scanned with CamScanner~ SEELELE A NOT Nove OrerAToR SELECT LAST NAME és ; % Urpate Qvery UPDATE Curtemerg FIRSTNAME , ADDRESS FRom PERS on WHERE ADDRESS 18 NoT NOLL ¢ . « > 24° SET Contort = 999, City > COQ uwwHERE Customex ID~ 14, DELETE Query BECETE FRom Aobename WHERE CNDITION 3 Eq DELETE Rom Customers WHERE Customex name = ‘AnuT’:? % AGGREGATION FuNeTion C3 MIN MAX p > CoonT U+> AVERAGE & 4 Sum €9°-. sevect MIN (Salary) AS Mivimom SALARY FRom Emp = SELECT may (Salosiy) AS Marxinvm SALARY FRom Emp; «SELECT Ave (Salosyy ) As AVERAGE SALARY FROM emp 5 e SELECT SUM (Salary) AS Sum SALARY FRom Emp ; i FROM Emp; © SELECT ,COUNT(Emp-cal) AS ToTol. Emp. a Ps Scanned with ComScanner ,K QWA JOIN ( The SOL Tom lou is util te combine Jucoroly porn H table . J, eas oF more, Ubasral Lon some Srnmen bel i Co tam deers otliveng Sau aurhem thurs ci a moleh Lun Eb fale octaves all sus fume Left abl. ¢ malehes 7 Bight Joint :— 4b suctunms wll seas prom Dre i Sable & cmatteher suit from othe ber Ga ilall EDAATOINT: - Rabent ot sear When Ube de a mat = ak tin ONE of the tables - 4 emp Prior [ob mane : 100 4 4 4 SELECT * Rom SELECT & 4 FRom cept 5 4 % INNER Jon : 4 SELECT ¥ FROM emb Jorn dept on emp dept no = deft: dlefno 5 4 oR " SELECT % FROM Emp Inne join debt on tmp: dep mo = dapt depro s 4 | fersbne Teonb name] Seay depo’ dep no | asp name] lo cation 4 yop | AJAY 1oo00| afr a cs DEAN! 4 loy ANUJ | 20000] d2 d2 me AURA cumit |asooo] 92 a3 €e tmoMB Al ! 102 | pgu) [30000] AY dy EN PontdAag ‘Scanned with CamSeannerwy & AEPT JOINT — SELECT X FROM emp Left join debian emp: debt mo= dept depno, 102 ABHI MBA | mADRAS % Fur, OvTeR JON dep no [olepro-alep-nome | tocation di ar] es DEAN) da aa ME AURA 33 3 €€ momBn | ay au EN PONTAB emp dept * Right Jom SELECT ¥ FROM EMP RIGHT Jon atept on emp olebmo = dept+ Cpa [embmo: [emp naave [caloxy] depres] elepno sep name [to cation 100 AJAY [10000] ai a es DELHI! ie anvy |2ec00 | 2 | d2 | me AGRA summit [25000 | a3 a3 ce momBA} goo00] oly oy [ en PONTAB emp dept SELECT % FROM emp FULL dUtEr join dept on emp -olep 0 = clept dep no 5 lermp n0-]eenp name Salawy | oepno- hei no: lolep name [location es DEN) mE AGRA ee MUMBA) EN PONTAR Men } MAPRAS Scanned with ComScanner emp oltpt© Z-TABAE Ton very SELECT # FRom table 4 INNER TON ON Table 14D = Table t91d tObL Y INNER JOIN Toble 3 ON Tob e105 Table 3° 1d 5 * Cross JOIN Cat ca called eosidiaiam Joim | costiaion -prvodkuct pum wrt Hoble wex0sat dt sutwuns SELECT ¥ FROM EM p Ross Toi) dept 5 fh Lusith SELECT Alame, Hepname {Rom Employee CROSS TOU pets SELECT ¥ FRom Emp» dept 5 Name Dep name ‘Scanned with CamSeanner —e- em ean nn ee aon em @ & 4Se ke MavinG Cadavse 7 TP UAL WAVING CLAUSE ULornd or a filter on top of Qraupecd dow seluentol ry the CROOP AY vehouse > Wiis celoute Lanmet be vuploctel ay a witre hou 4 vuee- wwe a SELECT & FRom <~ table mome > Cesrow v #lter veomolition SJ 5 Cenanp by ] CH AVING, < File OM aggregate column >] SALES , PRODOCT |SME WaT) (a) tolerate telat toler Be) qforxateest L45 SELECT Product ,sum (SALE AMT) AS iphone | S00 q doptoP goo Total Salez FRom SALE S iphone eC Gro ur by Produ ck PRODLCT | ToTAL SALES 1500 ‘i Speakers} 400 tapes Sober arnt (b) Lime only Htheer -preduds ph th. DeloL us Pho $1000 9 SELECT Product , Som (sales AMT) AS Total ales From SALES GiRoup by product PRODUCT BP gnviNG som (salesAmt ) Zloco ~~ HERE clouae umnstLool HAVING Bee? 4 yaa EN at a Syntax ea ua_becox dhe onere ues placa t vu J% uth oqyugale J” Wee “SUM, mins MAXI AVA et ” y Scanned with ComScannerflee Co WHere clos firtuee sours detore ouqy?eqal Palate Osun pugorumect UthoLy 24 i > HAVING velour filter vious AfLA dnpugals pale Lolisr Axe -ptrfpormud 7 j Pupaumane stamapount ,Howmng is shou Aha Lohse 2 ghoulel be aveiolid hun posechle - P@e2 ev. SELECT Product Sum (Salta AMT) AS TOTAL SALES FRom Sales Ae ; LoHERE Prooluct tn(ttphone 5 Speak ) NOTE .— Ls WHERE Ef HAVING com be wdtel teqethor vin a SELECT 2 : . ° . . Sy Oe re ercrctctaii Applica ste foal ee UA grolivictol vist Vhe Sus ose then Qioupsret poppet oletotions vas a ism he paving Clauses filtir dhs SELECT Proouct » Sum (sales AMT) As Total Solsx trom PaeERe product INC ‘fphone’, ts peakercs’) Cecoup Jy proonct Sowing sum (Sole Amount) >! 660 pla! Fei eal . 5 3 E OPAPP ARITT AA Pg aw aee oo? ‘Scanned with CamSeanner1 » * i SQL LIKE OPERATOK ‘ | @ Vho Bhualor Ur arch im a WHERE elosis LP Adil .«” a apie ~patttven uin 0 veal SELECT % FROM CuLstomou wHERE Cuslomue Name dike °0'/. 75 » ot - SELECT & FROM Customer Whey & s Customee Name ike © 7/0” y » K SELECT % FROM Cutout whee qustomex Nome not aike 07.’ 5 = — ~ L LIKE OPERATOR eee ] > LH ERE Custom oc Name ~ ue ‘AZ’ eae pi lta > WHERE Luttemor UKE ‘Y.a" oak hinds omy wolure thot sek te umd uth a? ts wHere utters Nome umels omy wolute thot hove UKE % ov Sones a eS nee crea teal is Ma tote LIKE © sy, om on te eee a Re dosch 4 a q_h-7. way “Von” 2 ou at best 8 vchaxcoctre un L> wHERE curteme Nome Riirenony, On aoe on rola that atart uuith 0”? 2 enrol suth “oO 3 ‘Scanned with CamSeanner| SOL IN OPERATOR, 1 Ue IN Bpveator Ablawus you te specify omsttiple values | dm Oo WHERE cleurre L4 the IN opuwtor i a short Amol foe multiple of hendition SELECT Column-name (s) FRom tablamame WHERE Column. Name IW Cvolue Lt, Valued... ) Ex- SELECT ® FROM Customeu WHERE Country In (GERMANY, “FRAN E’, (UK); SELECT ¥ FROM Curtomee 3 WHERE County NOTIN ( GERMANY’, FRANCE’, 'UK'); SELECT ¥ FROM WStomed WHERE CoONTRY IN (Select Country from Suppl) j t [ subqueypo Hirst excot - gs Employee Cemp- nome steeety city ) orks Cemb—name, Company name , salary ) Company (csmpany nome , erty) Manage Cemp-mame , managex—name) (©) tund mame Bf Employse ushe w0rxk fox SBT ° (15) Bind more f veties ef JSuaolunce #4 oll smpleyee cuy wher wipe for SB1° (1) Fumol all umployu dthe lars mat urs for SOI os Wo > Er pio VEE B01 o DEL) @ mumbal KOLKATA 4 ehh! 2 ll ‘Scanned with CamSeanner i oe aoe P PARP Panes aaBO SeeCT wmpemame from worns WHERE Company —name = sal’; Re a pany Yon ales GO serect tmp-name, city from dm ployee WHERE Combany Mame In ( SELECT Company-Nome Company where company Mame § gals OO) SELECT tmp-rome « hy from employee WHERE Company. name NOT In (SELECT tore pany jar trom Commhony where com pan y— Mame =' Ai’); oR SELECT emp-name from WoRKS WHERE COMPANY Nome |= ‘98)" 5 CEELEEE *K SQL BETWEEN OPERATOR Lahey BETIOEEN -epviotor aelicts wali unithin a yovin roma UAE wold eam be muvmnbu, tot puta ter Pe suhe BETWEEN wALiotoa usr umoluulue ¢ begin amd bp mk VOL, AMY Umeliroleol - | SYNTAX :- SELECT Coluumm.name CS) FROM toble mam e WHERE Column- name BETWEEN Value 1 AWD volun E9'- SELECT % FROM PRODUCTS WHERE (Pru BETWEEN, 10 AND 20);, SELECT % FROM PRODUCTS UNERE (Price NOT BETWEEN 10 AND 20) SELECT ¥ FRom PRODUCTS WHERE (Paice BETWEEN Io ANP 20) AND NOT Cotepory 10 IN (499%, 3) 3 SUCTTTT ww ‘Scanned with CamSeannerr M SQL ALIASES « Ly con oliarea Mu usec to Bye & tobly, wr 0 Aliren g dim Oo Hable , OQ Tmnporury mare * . a > alas Oe often wistol We mmoke coburn mores amare viLooloble j a C4 vin plies only entice pow Ure olnualvon af TAs qusny ” e@ ALAS Column SYNTAX a | SELECT column mame AS aliarmame from toblename, © ALIAS TABLE SYNTAX ¢ SELECT Colurmm-name CS) FROM toble.nome As alfas_name ; e e y GROvPING ReEsvAT al LL» GiRooP BY ‘clowns is ward un Sulect atobemsnt Je RRO en ealuumnm Mame - U1 Gi Ca ep” lea Example — 2 o Qi timed Total manks of aluolurte Am toch wily a SELECT sum (mosis) , EY Gubesyy From students a Group by Sty e CondITIONS ON GRovPS r HAVING veloute Us uteot de place ronoitiona Groupes Ext- SELECT Sum (moss), ally from STODENT GRooP AY cry | HAVING TY IN CThEeLHI’, SoA); ‘ ees MARKS FROM STUDENT SHOUDS ‘ Grove BY city 5 7 ERROR 1 ‘Scanned with CamScanner~ SeSECECCLCEUELEbEebeueuvwevweweve~ . rahi ett Te a PAM NESW) © ete ae yw daa LUbetLLal ob, Create ueeys 7 OD veut 6x Hapla cy tibealing A Wide As pre S$ Choe Ausluimm. mamas 10-Warus10 2, vituy 29 From boule Name ¢ t hee condition MULHt 10 pumfiston WIE 20 = Buh OY wephore CURE 2 oe user | 0 v SELECT ¥& FROM Em paroyee SELECT % FROM Vier WHERE oped <0, a s x CRE i | usex 20 OU UD Viow a6, gor i SELECT & Crom Emp wn eae SELECT. FROm Aeptid = 20; View 205 L_-4DROP View DROP view witWwNAme BRop Wiew 204 Scanned with CemScanner% SUBQUER ¥ Emp det oly ea ‘ : than Benet tly wp olitarle pranumg falar pootir = 30,000 - C+ sevect ¥ FROM Emp details — outer @erf WHERE a > 30,001 Zp in (SELECT TD FROM Emp Sal whore Saloruy tone quent X Co-Recaten () very SELECT Emb mame from Empsal ef outer quert WHERE A = Second Ni ghert satay (SELECT COUNT (eY~- Salory ) dmvoear salary FROm Empsabl e2 WHERE ba: SALARY >= C1 Salasu) | | | QUERY 2. Anoth ex guow te find nt 0. a Alghest Solos pe SELECT max (salon ) trov finoh emp Sab oa means, NOT IN (SeLeet max Coat empsal) ) Prom Scanned with ComScannerQY- FARE ’ EmPcoY GE BEPARTM erst tmb-td Jalame [posttfon]atept ta] Salasg ] [expe i [ dept name TESTER 45000 CUCEEEECEE 2 (1) Rekwen wembbayet prcerol vurith may Aohosuy t> SELECT ¥ From employee WHERE Si = (Sececr MAX (Solaxy ) FRom Empiovee) Wewuet Aight solory cm tmplaytt Loble > cenect max (solos ) Employee 5 tity qunet aM! Rigas oles im wmplayie Table. om Se REGtt max (saftey) FROM) EMPAOY EC mI HERE Salary NoT IN (SEECT mar Csafosy) ernpaove) 5 Uv) Rebret suamge Of rmployrt roared on dol t > SerecT * FROM EMPLOYEE ~~ WHERE EmPALYEC_Id between 4 anol B- Dy) Rolin wmplayee mame, Arghrt aotary oy cl portant wep SELECT e- First name, + lastname, es 5 Ldleposetment — mame FRom EMADVEE ¢ INNER Ton Deptwtment sow ~ (ex deptortment id = ds dep asctment ) a) WHERE Salary m (serecT mar Csalor4y) From employee) ' » ; ¥ Scanned with ComScanner(VD & yeitustem highat Aolorty, smpboyle mame, alipartimint 4 mome pox tach olupoxtment - > gerect e+ First-mome y eslart-name , ¢-Salasuy , oft deft narf | FROM EMPAOVEE elnmer Jon Hepastment ol ow 4 | Cerdepoxtment td = a+ olepooctment 10) ‘ ; HERE In (Sec€cT mA ( Sotosy) FROM EroPLovee ! GROUP BY depoxtment Id) - 4 | Reaationan Ang cara 4 | tls wolltdlion af cperati om ve sulotion (vob) 4 | tb ds Olee veodlrel frreecoluscal” . True cou 9 type of ppvvotion Ct * ' FAbprotlt vem emt uxtleililen/ Bee fe Sais) } A Srtyoction Aulvet + prustuct dumm , G) SEAETT OPERATION vue te suibuene slate prom Wupl dt ir elenotrol C=) Aigma Sa ey Ur Linton ef alietion shnuotion a = Retolien Yoble Coated tana ry CR» ibtes tilt enol” com we Mamposiron bili. S1F<15,>,>2 S Loronsstissity wuss & Au (A) oR(V) & MoT (7) Allows emposuion bhur 9 voctheibutor [eid Team 8 Fi nS p ‘Scanned with CamScannerS select commuitatiom -propwy [ rtlour ey! \ ~~ one axb=bxa : cass Ae [acai % ier) | dh pote wf employ doum aun 4 solosy > (em y= is (&mp) ee city = DELHI P Tetly =0 eum Salary > 2k 3 DELHI c 3k 9 DELHI @ oh Ch) Lerctontct Lomnectinuly poration TetasiM ects» (Emb) 1 Dew) A ak 2 AURA & ak 3 Prosect Operation 5 Ural ip Subuire vote pier veotumn ( HD olemotiol Lye HpuuR utter (7) AL satuluti) fuplcot tub wu not allound £ vumeucd dts - 4 synlox of epreotion Sis [Fras so) CR). vptbibubs op the violation (2) STOOENT O Display more vop the Atirolent Aowmg MS oliprer (student) ] Name /DeyRee Loz [es Name L Tree = ms Scanned with ComScanner> CREATE TABLE CUSTOMER ( Customer ~ ia int MOT MULL PRIMARY KEY, customex mame vorreho (995) > FOREIGN KEY ( Order Pad) REFERENCE Ordex (orglen al) ) INSERT JNTO WsTOMER (customer ‘cd, Customer nome, orden col) vaves (1, ATAY” 9 O! Yo (2 "Aten 022) F ae « (3, ‘ATUOL’» 033) 5 rl CREATE TARKE ORDER ( ordentd ft NoTNULe PRIMARY KEY, Product-Name vor thax (925) 5 \. amos vt" Poice INT i \ ee ya E 5 gad, 2! ? INSERT INTO ORDER Me 5% (orderid, Producten ame y Povce) yacues (oily * a>, 40k), or2,'Bs 1k)» (033, Cy eek )s ‘Scanned with CamSeannermap % JOIN In Reaationns DB . tt is uusecl to combine lotic tuplir prom & vulat Limte A aimgle Doble - s “ Bi at dy olimetil Oy ‘DQ! aumuliar. we‘ wkett corte . ss . . combination fp Wuplet thot eolitpy othe pitting / bn emrctiniom products all posishle wombunation of y Lupe pram cthe vutaTien ' > trample '- Emp yoy DE * Trees Of Tons : | W mre Wi) Buber fon on dept outs, faim (apa) | Ey pin faght mutt fein (a0) Nacbral Join Balt autix Join (IPIC) | Feder foun = 2 cantons only motor Jullotien Theta fin (0)! PA 5 comprrative oprreation ce ee y's fakes aD) eR = XNotuscol Jour 2 Lt howd an sormen olbirbuty Sm path Subottien * Aub Join '- vuletion tuple ui be In F Fu wantin faim i Uuples prove Leth Julation Scanned with ComScanner“* JHETA Jom (6) ba, “comparative operation oa Mobile dobtep toate! | Price Nokia | tok pelt | sok Samsung 20k pater | 201s iphone | sok Asus | 10K [3 unchast bot amsobile 4 Laktap pact email shaulel te Huss thon Laptop price - ep tmobile € Loptop price Ci) Webi, & Loptap pie theuld be Lome 5 mobile fate a Mobile pre = Laptop pre af ion moout [Pace lol cex | 20K Fornsung aok | A ¥ Naturad Jorn ; Ls ohe eduuation: forums a costivan psduct of ue ven these obtibull thal oppens un Leth sulortien Aches 4 pimolly sumevit vluplreate octbei bite + Erp Dept eNome [erp id | D-name Dname| Nanager A ) Fin an Mi 6 5 Soles utes rn c 3 Sale ‘Scanned with CamScanner Lam ee ee ooeTOTAMAANAARRaAeeerSY Ooter Join Re Os aad Uhm aus Want te Rup oll ths tuples vin ee ree es ee ee et daue motemng Wupl um wethur vulotion $ g RIpAs rule fom [IDC] RIBICS Scanned with CemScanner| si mel 2 e¢s i y sooo ro PP PITIIIZITTLI Ie see * SET Operation Ow Redanons | TAU vow applicable JY uthe Vulotions vos umion | ‘ > Union Lempotibility © The ulation 'R:) 4 Ra? must Le wap the aus prdy mo: of cobrrnns (dagyat) e A ry [atte huts CH) Dhe volemaun asf 0 ottrbuitis 0h RL & i ttc boubys eR, mut be aorme for all st * % Union Operation (U) > woluplicate Wuples ore wmovitol TRU ‘turmion) Uplur pom uithue RFS vo both Ss 1D ]Name| Ade 1p | Name | Age Pecan eee Uy Dd 24 Eq umal the mone of poem whe we R OWS Tian) CRI U Tome ©) Name ¥ Ser Dieeerence Operation Ae f4y213545 } A-B= volt putent dn A, B~ $245} But Nat um & {1,3} Scanned with ComScanner% Suimal Guplun pusent uin wnt vulotion but mot um vombth, Krtotion STuotumt Foul atuolomt vi 1D_| Nome 1D ome Tam a in a 2| 6 3 |o Q+ umd te noms of Absolmt whe ose mot fowl? Lt Catusent)- 1 Cfath atuclint ) Nome Tome Cc A oe : ° c ¥ INSERTION OptRaTION A={152534, 5} 8=1204,6,07 nne=f4,4} dmchicly voll Wupls that we in bath the Saat prusunt vin An& = {9,4} R Ciol | emname i A 4} 8 pee ORO OS) A A 8 a aA c 5 8 ¥ Caoss ‘ProoveT _peedtian pet bl, combination Af Wype+f Uuplas — Lenobd Ly “X? Siprmbol S==6) Scanned with ComScanner