fut Ne Soy > Ra] Cay-oe Ss w SCHEMA - DIAGRAM: Book wk td [THe [ fub_Yeon | tbihortlome ——T Tock. cas LBsedetd [Autonome bien A Name | Phone ns [ Alden Bech Cotes TLBeekatd | ferorene id | naeh copies Beck. lending Gxd.09 | Dole. oat Proquanne name_ TE VARCHAR 2 (20) NUMBER (38) VARCHARE (20) ee an NEE eae eee UE NOT NULL NUMBER (32) TITLE VARCHAR® (20) PUB_ YEAR VARCHARE (20) PUBLISHER -NAME VARCHAR2 (20) SQL> DESC BODK_AUIHORS; — Nowe fyULL? AUTHOR -NAINE NOT nweL VARCHRAeAy BOOK ID NOT ree, UuMBER (38) | Foble _Lfnesiions —_ maitre cu>| CREAR TABLE TuBlisueR |_ (AME VARCHAR2 (20) PRIMARY Rey, | _ PHONE TNTEGER, 2 (20))$ “WABLE_CRSMIED CREATE TABLE _BODK Tage CREATED “TABLE CREATED EwSQL> DESC LIBRARY PROGRAMME 5 NOT MULL FROSERAIME NAME ADDRESS. SQL> DESC BOOK. COPTES ; B0r-I0 Nor nme BRANCE-ID NT NOLL SQL> DESC CARD; _ Nome CARD-ND 7 oo 7 NOT NULL SSL > DESC Peok LENDING 5 DE - OnTE BeOK.TD feo opm 1p ORDO _ TYPE NUMBER (38) VARCHAR (20) VARCHAR2 (60) _ _ WE “NUMBER (38) VARCHAR (20) NUMBER (38) (NUBIBER (38) CREATE TABLE LIBRARY CROGEA MME | C_ PROGRAMME. 1D INTEGER _fAIMERY PROGRAMME. riqtie VARCHAR? (50) __ADDRESS _varceap2 (50). TELE CREATED squ>| cReATR TABLE CARD |___a. | ( canon tnreGeR PRIMARY KEY D3 _____ TABLE CREATED. |_sqr> | CREATE TABLE BOOK LENDING | C pats.ouT DATE DUE. PATE DATES. 4_| ook 1D REFERENCES Book (BOCK.ID) oN DELETE | __Progaamme. 10 REFEREL ( poo LTE CASCADE, || canDinn REFERENCES cARD_(chRD.NO) on DELEIE CASCADE, —_ | 7 | prrmary KEY (@0K.r0, PROGRAMME TD CARDO); __ “TABLE CREATED.SELECT & FROM PUBLISHERS Name one ADORESS MCeRAN- BILL qrsto36ss?—=SS*S*CRANGLORE PEARSON 4899076505 NEW DELHI RANDOM HOUSE PERSE PISA HYDERABAD HACHETTE AIVRE s77O86a 349 CHENNAT GRUPO PLANETA 775610238 BANGALORE SQL> SELECT + FROM BOOKS CUBLTSHER_ NAN 1 Dans TAN= 202 (MCE RAW HILL 2 ADBRS WN-2016 MCGRMI- HELL 3 cn (SEP- 2016 PEARSON 4 & ef 2015 enuro PLANET 5 os MAY - 2016 PEARSON SQL> SELECT & FROM Bett AUTHORS NAVATHE 1 RAVATHE 2 TANEBAUIN 3 FOWRRD ANGEL + GALVIN 5 Il I © | owoiton of vous, to Tale: — ae eee “INSERT _JnTo_NUBLISHER_vaLuRS Ccgenu-HTLL, 1287026583, “nangAlote’), __| twseaT Into Bank VALVES. a | Insert Into Book waves (2, ADEMs’ “pun- gos’, * pac. fabl= WILL); Towser meme Be (3 ten? "agP- 20m, “PEARSON TnsERT INT) Bo0K values (5, ‘0s’, ‘may-20”, “peARsatl” | INSERT INTO Ba ‘InsERT_TnTo Boo AVTHAR: TnseaT_ F (EDWARD ANSEL". 4); INSERT roi) PHOK AUTHORS varues (‘gervin’ 5);“sql > SELECT % ThOM LIBRARY. CROGRAMME eRIGAMPIMNE-ID CROGRAMMENAWME —___ADPRESS Oe RR NAGAR BANGALORE n EWIT BANGALORE 1 RADATI NAGAR BANGALORE 3 NITE MANGALORE th MANTPAL, vourr SAL> SELECT * FROM BOK COPTES; SQL> SELECT & FROM CARD; CARD-NO DO MM yy yy 1© [sear ruta —7eenkY.tenspanne_ymues an atin an‘sanstuHt ___LINSRRT_INTO__LTBRARY. PROGRARME VALUES (11,"EW1T, *BANIALORE”): | INSERT_INTO _LTBRARYPRogRaMONe VALUES (We, SRATALLNAAR’," Banlse.068"); -INSERT INTO _LTBRARY PROGRAMME VALVES (13, ‘NTTTE”, "MANSALORE’); INSERT INTO _/TRRARY. FROSRAMIVE VALUES (Kt, "mANTPAL’,"UDUPT”); [anise _anro__ann cones values Cn, 2,48)5 ——[nsenr avr —pookconres vauurs (22,0) JINSERT INTO Book. cofres vawes (52,13); | TusEAT INTO Bonk. corres values (2,3,2e); | seer _mnTo__pookcopres vues (1,5, 19): | mmiskar INTO gonX cOPTES vanyes (2,4 Jt); | INSERT xno cago values (400); [INSERT INTO CARD VALUES (1n1), INSERT _INTD_caRD VALUES (102) INSERT __INID CARD VALVES (103)}. ‘SERT [NTO _cARP__vALUES (204) 5 Ew11+ MPR 3 Ie FEB12 IAPR AF 2 15-mpR-19—IS-TUL-17 4 12 AR 12 R= MY-1F i L DBMS MCGRFR HILL 1 perms, MCRL - HILL 2 DBS (CRRA) ~ WELL 2 aves, MegeAY- TLL 3 cn PEARSON 5 05 PEARSON 4 cs enor PLATETA EARD-NO_ _ 401, 10 tk 13 11 i _AUTHORLIAME NOLO. NAV ATHE NAVATHE NAVAIHE, NAVATIE Tene enuvin EDAMD ANGEL CRD Jor 401 404 108 Joh —jINSERT INTO Pook penpong Values (‘o-ten-t?" “ol-wu-1#, 1,10, 400)5 {INSERT INTO Book venom venues ("y-Deni-19” “nt- mart? 3h ns)s U LINSERT NTO genx. betiprnig vavues (*21-FER-13" ‘2)- APR IP? 21311); ____LINSERT INTO book venprnig venues ("x5 mef-12” "y5-Tw- re’ et tons | IseAT 170 pony Jenomie_vees (iz-are= 12° “i2-mayere”, 1m) 1 Quenfes, |Aebsiove dels, of, oll teaks in the hum td_ fle name " ‘ ROM Z00K B, BODK. AUTHORS f |__| Book. coPiEs C, JTRRARY PROGRAMME f | WHERE B.BoOK TO = As BoQK Tp | AND B. BOOK TD = (.BOOK.Tp LECT _CARD.NO FROM Book. LENDING: —__ | WHERE _paTR.our_BEIWEEN ‘91-TAN= 20/7” AND to1-Tus- 20” _ | GROUP BY CARD NQ | Havima_counr_C*) > 3.5oo e—”—O”..._ gqu> SELECT * FROM BOOK Book.ty_ _ TEE, _ _ PUBYEAR_ _ ~, Bms “yan = 2017 oi 2 a0ams Fun 20% MACGRBA ATL 4 c& ep-205 ——GAUFO TLaNeTA 5 os aay 2016 PEARSON Jan - 2OrF ‘TN- 2016 SEP ~ 2016 SEP 2015 MAY -Z016 SGL> SELECT * FROM VLBOOKS 5 CREATE VIER V.PUBITCATION A: | SELECT UB YEAR FROM BOOK +ER- DIAGRAM: @p Salesrean_|/-—— DESC SALESMAN} —Nome satesman-ID NAME VARCHAR (20) cay VARCHAR (20) commIssTON VARCHAR2 (20) SQL> DESC CUSTOMERL; Nome cone Stas cor Nall? <= gov “Tyre customer 1D Net NOLL “NUMBER CUST. NAME VARCHAR (20) cqTy VARCHAR (20) GRADE NUMBER (3) ‘SALESIAN_ID NUMBER (+) SQL> DESC ORDERS ; Nome ‘Nall Type oRD..NO hor nee” WwniBeR PORHASE_ AMT NUMBER (10,2) ORD. DATE DATE CUSTOMER. TD NUMBER (4) SALESMOAN_ID NUMBER (4) | Toble_Snention CITY _vARCHAR2 (20) | __cotntT ss Ton _vi Te PRIMARY KEY (SALESMAN TD)) 5 CREATE TABLE Customer? (customer. TD nwmBen (4, |__cysT NAME VARCHAR2 (20), CTTY_vaRCuaR2 (20) GRADE numper (2), PRIMARY REY (cuSTOMER. ID), CREAIE TABLE ORDER: RD_NO NUMBER (5) PURCHASE-AMT _AIUMBER (10,2), ORD. DATE DATE pRrmaRy KEY (oRD_nO [salesman TD REFERENCES sALeSMAN (SALESMANLID) an DELETE CascAoe);SQL> SELECT * FROM SALESTOAN 3 ESMAN-ID_ _ NAME aryl oe 4000 Tour BANGALORE 2000 RAVE BANGALORE 3000 UMAR MYSORE 4000 staqTH OELHT 5000 HARSHA HYDERABAD SQL> SELECT * FROM CUSTOMERL; GRADE Spies PREETHT BANGALORE 100 VIVER PIAN@RLORE. 300 BAS KAR CHENNAT 400 CHETHAN BANGALORE 200 MamATHR BANGALORE 400 SQL> SELECT * FROM ORDERS 3 WT _ORD.DATE _ cusromeR.TD. Ot maAY-39 Jo st +50 20- TAn-13 10 st 1000 PA FEB-1? 13 53 3500 B- ARIF ub Sh 550 01 MAR we DOMMYyyy | tinsedfon_of_Valnes te Tables: ___LINSERT _TNTO_SALESMAN VALVES (1090, "TouN’, ‘manensoRE "25%? 93 Anse 17D SAL stan —vAlues (eta “enn “nona nie na! — a sen, Hu | INSERT INTO _SALEStmaAt VALUES (4000, “smT TH", “DetuT?, ‘307% ); _ ____|_InskrT_InTD salesman _vanveS (5000, “Hansun”, “HYDERABAD’ “1547; ——[ainseer ito —cusmment _vawes (10, ‘eReemar", “eanéAone” 10100) | INSERT INTO CUSTOMER1 VALVES (11, “IVER”, “ MenIEALORE”, 300, 100035. | INSERT INTO CUSTOMER? VALUES (12, “BaASUAR’ “CHENINAT’, 40,2000); |__| INSERT INTO customeR1 VALvES (13, ‘CHETHAN”, “BANGALORE” 20, en90)} INSERT INTO CUSTOMER. venues (1%, "tan Aria”, “sania ALORE?, 400, 300093 _ SALESMAN TD. “20-3AtL=13°. 10, 2t00); 1000 a ae 3 2000 500, ‘ 5 2000 INSERT INTO ORDERS VALUE: 4, 550, *09-MAK-12’, 12 2000. 3000 2000SNLESIOAN. ID RAUI kar RAVI Kumar Town Torn ToHn) ARSHA CUST.NAME No MATCH CHETHEN SANTA PREETHE No mac CHETHAN MAranTHA PREETHE No mateH commassior 20x ROX 20% 15% RK 25% Box 15% DDOMMyyyy uenten | fount she —cuslomons sth jindts above Bangalore ovwnge. | SELECT GRADE, COUNT (DistincT custome RTD) ____ | FROM _cUSTOMERL Royp By GRADE __| wavinly grape > (sesecT Ave(qRape) Faom cusTomeRt —__ HHERE crTy2 ‘BaniGavare’ >; | __2.| tnd the nome ond numbers ef oll salesman tthe had wnere thon _one_.outeenen |__| SELECT saLesmANATD, WAM | FROM savesman A FROM SALESMAN. MNERE NOT CITY= Anly SELECT CTY FROM CUSTOMER2 ORDER RY 2 DESC $2O- SAN -1t PA-FEB-I? 13> APR=13 Ot MARI s S000 HARSHER SOL > SELECT » TROM ELITSALESMAN 5 SQL> SELECT # FROM SALESMAN); CREATE VIEW ELITSALESMAN 6S. | SELECT B.ORD.DATE, A-SALESMAN.ID AstiAMe FROM SALESMAN) A, ORDERS B [haere A. SAgsnan Tp B.SALESTORN TD [AND B.funcuase. snr » (select mex (fueenAse Amor) FROM ORDERS C [wwgRe C.0RD_OATE = BDRD DATED; _ corimrssion | Dumeniacte the DELETE epeanifen by vemeing salesman ith || id sono. AN bis erdens rout glee be delefed DELETE FROM SAresmant WHERE SALESMAN. TD = 10005ER- DIAGRAM: movre cast CAct-id Mer id Rede) RATING ( Mov.id, Pew. Shots) Ader p— adr Adtame [Ad Gender Diredon Dist | Distame | Dix.thone Unite. SQ) queries ta, it jes dit by "Hite 4 mote meuies | tos vitlost one wating. ont Zod the Haba of stots hat nite sneefued. Sort the, seault hy. mocute title Mes-Tite | Mov teon | Moutang | DWfd 5 wh aa ETSQL> DESC ACTOR; AcT-1D ACT MAME, ACT- GENDER SQL> DESC DIRECTOR: DIR NAME DER -PHONE Sou > DESC MevzES; mov-ID Moy. TITLE Mov. YEAR may LANG DIR-1D null ? © Noy HLL ROT uLe NoT nuee hee HUMBER) VARCHNRE (20) CHAR (1) NUMBER (3) VARCHARE(20) NUMBER (10) ~ NUMBER) vancnnta(es) NUMBER (4) VARCHARZ (12) huraper (2) DOMM YY yy | enenie Tapie actog | C__peterp number(s), ACT..NAME VARCHAR (20), | pet-egnioea coar (2), |__pesmapny Key (Acr.rD225. _ CREATE TABLE DISECTOR. _DIR-ID__nuta BER DIR-NAME VARCHAR (20) DIR-PAOE NUMBER (10), prrmary KEY (PIR.1D)); CREATE TABLE [ofvre’ (mov. Tp num BER(A), MOVATITLE VARCHAR (25), fu Nn YEAR NuMBER (A: MOV. Lang VARCHAR (12), pra. Td _uaBer (3) peImary KEY (Pov.10), TORETEN key (DIR.T9) REFERENCES pikECIOR (DIR 7D)2,GOL > DESC MOVIE CASTS Nome We yet ~ Ni NOMBER(3) mov-TD NOT NOLL NUMBER (4) ROLE ‘VAR CHAR (10) SQL > DESC RATING 5 wot PE se td NUPBERCH) VAR CHARA (25) PREBHRS ” ung TH ” venmy ” 30h SOL > SELECT * FROM DIRECTOR; : ENE _ PIR fHONE ATA MOULT ool 8751611 a HITCHCOCK recs 62 an & FA a 195677653) STEVEN SPINBIRG = s40939(520 DOM MY Y YY I) | CREATE TMELE movte cesT | C_Act.10__numpends),— | mov. Tp rueamen (+), | Rove _wagcnaR (202, ____ _pertonmy key Cact.romoy.tp), FOREIGN _¥EY (Act) PEF ERENCES ACTOR CAct-rP), | Foreron vey (moy_tb) REFERENCES mnyrs (mo¥-20)); ___ | CREATE TABLE RATING __ Coy. r0_MumBER (H) REV. STARS VARCHAR (25) permegy vey (wov.rp), FOREIGN KEY (1oy-ED) EEERENCE movie: (rqv.1pD; Tnsentfon_e}-_voluts te Table + INSERT rnp _AcroR _-vagues (301, ‘enwsuxe”, "E”D, ‘TnseRT INTO actor valves (202, *pRasuas’, “10'), [-amsent into _acToR —_vawues (3, ‘funzTH? ‘0°; Tsar INTO ACTOR VALUES (20s, “YeRMY’ ‘MD; = [GnseRT _1v10__prrecroR vanes (eo, "RATA mausT” 2251611001); “[ansear auto oreecioe_vavues (él, ‘HITCH Cock". 2264 158219 Y TnserT Ino __DIeecrOR_vanves_(62, ‘Famer’, 4736226531); TASERL_INTO DIRECTOR _vnlves C63, "steven streLBen”, s1sI7Ass, ———sen> SELECT * FROM MITES 5 ‘TELUGU BRHUBALI-2 tooz = BRPBALI-1 TELVED 60 es (1003. ¢ . ty > EDs Eonar ce eS (inp ‘tee uous’, Patt, 2, 100s ARASH BFR POUSE ENGLISH MSERT INTO ovine. cast vases (201, 1007 "ue fore’); [ onsceet myo mote cast values (2011001 ‘peor? _—_—|_ini | anseer _zmuro_wouse. (6st _ueueS_(3r2, tags, “seh, HEFOINE TniseeT INTO _ravre cast valves (312, 1002, Guest”); _|-aniseet Two moure cost values (3, took, “weno? >: BEFOINE |_| sansa tro natant vatves Csobt, #5 _____ | qsk@l INTO ReTrng values C202, 2); IpserT INTO fATID WeLUES (1003, 5); WWD GATING yALyeS (ote b)5_ Mov TITLE BARVBALI- 2 BRBUBALT -2 ARASH ACTNAME ANUSARA BAMUBALT-2 DOMMyyyvy fog or _mene monies ELECT pISTINeT Mv TITLE FROM MOVIES NATURAL JOIN) wnvtE. CAST WAERE ACT-TD IN CsELECT ACTAID FROM movie. Cast WT eroue sy acterp AAVING Count (#) >= 2) [Tit oll_ackows dh —oced_in_.o_watale lore 2000 owl abo | tao mente olten 2015 [use JotN_epeutten ]____ ELECT pISTIW¢T ACT-NAME, MOV-TITLE , Mov. YEAR Rom (actok YOIN movTe.casT _usttlg Cac. 7)). JOIN movies vsti (mov rp). WHERE mov year NOT BETWEEN anon AND 2015DMM yyyy BAHBALT- 1 2 BAHU BALI-2 ie WAR HOUSE 4 ls = 5 rove By Mov. TITLE ORDER RY moVv-TITLE $ SAL> SELECT * FROM RATING; REV. STARS peDATE —RATIN ET REV. STARS 2 5 WHERE moy.TD In (SELECT Moy TD FROM movies NATURAL orl _OTRECTOR WHERE DIR NAME = ‘STEVEN SPTEIRER:TAMPRS wn) io 2? eieaee Tet) c= oo ean) ScHEIOR = DIAGRAMS {usw [stiome | fadmen | Plone ” gunesion ond in_each sucion DT som [See 19 | S00 | cua | Lte_a)_then CAT + ‘Outstondli i= 12 tp 16 then _caT = “Avenage Todt [Tode [Tats 12 then _CaT = ‘herK’ mestn A,B and C zechinDDMMYYyYyY SQL> DESC STUDENT Woe = a2 Type Table Kreoffon; vst WoT NULL VARCHAR G0) BLE_STDeNT NAME VARCHAR2 (25) | CREAIE TAI a (_vsn_VARCHAR (io) PRIMARY KEY, ——————_________— ‘ADDRESS VARCHAR 2 (25) ? 25 4 SNAME eee ene NNurBER (20) ia maz GENDER cuar() }——-4 _ SQL> DESC SEMSEC; 77 CREATE._TABLE_SEMSC__—————_________— TS we Tye ~ | (-ssrp__vaRcHak (5) PRIMARY KEY, ———_______— aa Se Voncimnnets) | sena_nwm BER, eer ce aes Oo ste NUMBER _sEC_cma (1); — cneR(2) _| CREATE TABLE CLASS —_— a: | C_usn _vagcuar (20) - Nan in ro var car (5) WN 7 ry ___|__paataney_xey_(usny 88102, sib mie Varenn Gy | oer 11). REFERENCES STUDENT -Cusn; NOT ee vancunn2(s) FOETEn KEY (ssrp) REFERENCES SEMSEC (S510);sgL> Dest SvBTECT; SQL> DES TAMERS; Nore Holl? ushs NOT NULL SUBCODE eT nee S510 NOT NULL Test1 TEST2 TESTE FINALTA Nore _ Mi S1BQ0E Not WL TIME sen CREDITS VARCHARE(e#) nuraBer (2) surager (2) Tye AFCHARE (20) vARCHERe (2) vaRcHArels) nuraBen(e) NUMBER (2) nurapen (2) NumBeR (2) pL creme tape soprece ___| ¢ _suzcops _vancupe (2), TIE vert vee (20 ITS _wiMBER (2 Pelmpsy eey (svecape )); CREATE TABLE TAMAR. (__Wsn_varcufk (20,“aRNI3¢8080 ARNIS¢5062 ARN CSOFL ARN 13 ¢8 066 IRN 4 €8 010 IRN 1eC5 032 LRNIACSORS IAN ISCSOLL IRNI5C5071 RULE CSORS LAN 1e.CSC88 IAN 1E C5182 SQL> SELECT * FROM AKSHAY. SANDRA TEESHA SUTRTYA ABHRY BHAS KAR PST ATAY CPATTRR TEEVE sanlTose ISMAIL SAEERE VINRYERE STUDENT 5 BELAGAVT BENGALURU. BENISALURY MAM gALURD BENGALURU BENGALURU BENGALURD TUMRUR DAVANGERE BELLARY MANgALuEy KALASURST. SHIMOSA CHIKAMAGRLOR S977931122 FFeRa2IWE PHO BSP PSBLLLE 9700211201 eset? TATSTBIF 4BA5on134] 76962 72121 sas sore 93 12332201 ‘00232201 1105 S4 Ree 3800330011 sa | xnsert_ Tiid_stupgnT_vaLyes ("sen zacso2n' ‘Aesuay” "BELAGANT |} —__———_____ 1879331122 tm’); | INSERT Into _STupgriT _vecues (‘tantzesnée”, “SANDAYA" BEN ALUR, — zaepe2tue FE”); = Seas tiscali gnsert gro Stupewt THES Cann tacsee “soem mma so23ganz2, ‘e’); [assent ava sininy ves (omzecsosn’‘nsany ‘senstvue, grooztien, * mM’), | LuseRT__1uto_STuperit vette Cee 24cS05z “SHASUAA™. "SENIGALIAL 2814732392, “F"): anseaT Iwi) stupenr _vacves (ratliscsorn”, “arar’, “Tar”, __ 985091341 ‘n>; Renee eas + 2616 222721 fF”): |_TnseRT ITO STupENT varuES (*4eNss¢S045",* TEEVA’, “BEALARY” qqeegsoses SM); INSERT _INTD__STubenT _valUES C‘zeniscso2t’, “sANTOsA”"mansalore 212332201, ¢m’); | aise nosnumenr iva Cnsecsous, “retary” “varminsr” pease, SP | anseeT Tym STUDENT VALUES (‘tRnitécsosR” ‘sameeRA” ‘sizing’ Sf tg 5 dad SED ‘[anseet into _STupent —vnwes Canwuccesze", ‘viwayava’, ‘cena foo ppt con tt feSOQ SRLECT TR — SEMSECS - user TnIb_seMsec values C‘cszan? 2 ’a°); ——______— sWsEAT_INTO_SEMSEC__vatues (" B)_8,"B)2; waLue, ‘InsERT Into semsee ‘AseRT INTO msec _yauues sesh 5 8 Ot LER RWW RE RUUD ADH HHO OH PaO ayowBnasnwnnwnnneone Et ves “Tszey Ii _semsrc—vayues jer 5). csEa5 ore INSERT Tio _semsec_vaves (Seszaa’ +A) CSERA INSERT INTO _sEmsic_ vanes (‘cse4B) 4, 'R”): a | cseEB i ef aeant 5 tO De CSE ae | ausERT _tnto_semsec_vawe s ('se4A_£, “¢°)s—_ SER TnsexT Inno _semssc wees (Ccszse’ os ‘A), peoer { snwseeT mura semste_vyarues_(csh.38°_S_‘8°2,__ CSERC cseIN CSEIB cse1¢TAN I3C8020 IRN 13. 68062 IRN I3CSOEE RN 1365011 ARNIACSOIO IRN IACSOBS SANE SORE, JANIS O11 ARWI5¢S029 LnNI5 C5065 N15 5093 ARNG (5045 LkW 1ecsose ARN IECS 122 4308032 10¢821 Jen33C011 Loc eg INCH tocses JINCII oC Annis3c5011 eOL> SELECT * FROM CLASS _sniseAT Into cans vasues C'renisesnge”, ‘ese an? 2: eit L111 TWSERT_INTO_censsyruves ("ipnzzcsoee’ ‘Copze”); _INSEAT INTO _chass valves (*1pnu13cso6s" "CsEa5°); | aniskAT Into cons vawyes ('Lentscsom”, *cseac’); aes 2 est ADs TNSES wes ("ienitecsor” *CSk 3A), ANSERT. m0 CLS VBLUES Cras 01 “cse4e) | TusenT nro czass ues CU1pntecsose?, ©cse3a"): ERT INT CLAS VANES (“tanitersosa’, 'CSE3B"); er a 5120, * CSE 30°): | snseeT muro qamanns Cusn, siBcope, $SxD_ TEST, TEST? TEsT3) _a) SOLD SELECT * FROM SUBUECT; Jocshy meme SBOE ___ TONE ____ SEN _ CeTTS _ “AnskRT_1n70__suB3ecT_vavves Ctocs@1?, Aca”, 8,43 ——— ee fa a 4 ~__| ausert—Into__sustecT _veuvesC'Jocsa2”, ‘ssm?,2, 4) —__— J0ce 8h ssw a 4 | qnseet_into__suegect vawes ("socs23), ‘nin? 8, 493 ___ 100583 4” § 4 | syserTtnmo__‘SueskcT _unaues (‘incsae?, *cc?.2,.4°), ____ yocse4 ce 4 4 |_INMERT_1uIO_SuBUECT__vauveS ('sncsas), "pal? @, 3 __ J0cs95 Ph a 4 | INSERT INTO__SuBTECT_vaLues (‘10¢s#1°, ‘onan’, 2,4); —__ 30054 ond ? 4 __|_anserT INTO subst _yasues ('100522° ‘ES’, 3,4); __ tots7e Fes 7 4 SUByECT__vALUES (‘Jocs?3’ ‘PTW, 2, 43__ 100593 mm 7 4 Ird__supmecT valves C‘incs34” ‘pupw? Jocs?4 HOM 7 4 SuBTET _anves (“tocs28), "Tava?, 3,4); Jocs7s Tava ? 4 INSERT INTO SUBJECT _‘Varues _(*ncs36” ‘SAN 2,6); 100596 sav 7 4 | INSERT INTO _suesecT VANES (‘15(551°, “ME”, 5,4); JOCS51 me 5 4 | INSERT INTO _suBIECT ALES ("1S(S52", "CN? 5,495; socs 52 cn) 5 4 {INSERT INTO _suevecr Anes ("ISCS53) ‘pgms) 54), SOEs BE BMS 5 4 [these ann SUB —URLMESC*LSCSS4—‘AL?, 5); —_ 100s54 ame 5 4 3s rave J0CS5S TAWA 5 3 J0cs56 AL 5 3 Jocs4i 4 4 Jocsa2 4 4 10543 4 4 i 4 tocs4i one ’ 3 ets ne 4 3 100831 3 3 + tocs3e ADE. 3 4 100833 DSR 3 4 10CS3f co 3 4 J0(835 vst 3 3 100836 pms 3 3SANTOSH — MANGALORE SEIN SRE sats SENDER 3 3 A y 3 B F 5 c 4 & A F 4 A m 4 8 ™ 4 G " ? A F a A 4 8 A F 8 A ™ a B F 8 c F eee a Ss SUBCOOE -_s 18 JO CseL 2 J0¢S82 " J0¢ss3 2 10¢884 10885, 9312332001 COUNT 2 1 eee eee ee SGL> SELGET + FROM STULTEST2_ MARKS VIEW; “Lid oll the sled dla ahlying touch semester ©. | seLecT_S.*, sS.sem sssee3R113¢5011 IRNYLBESONT IRN 13CS081 Je13C5011 Jeu 13 C5041 sBdes SOL e BEGIN END; / IANASCSON IRNS3CS01L IANLIUSON sens 2esu4t 1mit705091 10¢881 Ines92 J0(5£3 0¢sts 100585 AVG MARYS soceee 005 83 $0024 10525 SHLD SELECT & FROM TAMARKS; SSID SOL > SELECT # FROM IRIMEKKS; yest1 EST opayTesTsT eee 6 1B n ue 15 20 6 4 15 2B Teste _TEST3 he fe Trorke the FL/SaL dered prrdire fom orrmord bre: | ‘te Snkealle the FoalZA_ (or = = moldy Sih. eae _| CREATE OR_REGLACE FrOCE DURE _AYgenRYS TS CURSOR _C-TAMBRES T5_ ELECT GUEATEST (1esT1, Teste) AS a GAEAIEST (1EsTL, TEST ASB, | -aestest_Ciest2,zes2) fst oa | __¢.s!9_numBeR + _ . Cf) UMMRER j | seems i TAsMARHS + - - | pa ‘ieminks I000 CA, 02,0005 ____ BATT _sWEN_C Tames 4_NOT Foun pets .ourtun sro 2rue (op CBI e6D5 Ie (c.Al= CBD THEN. Copy te cosines Saas => Dpms_ourtvl, UT LINE va ‘sume Wcsm; = ppmns .ovnfuTs fuT Line CAVLBAGE"=" II Cf); LDME eniees SET S2NALIA + Co AY JALRE CUREETLT. CF CoTAMERKS £ND_ Loot; Close... -TAMAFHS LUD; 71Rmiz(so71TEESHA = -Bengatury 7712312512 1RNi3cs02«TEESHA «= BENGALURY «7712312512 FOUTSTRNING ARWIZGSO71 — TEESHA —-BENSALURY «7702312312 F = _OMTSTIRELN, 1RWI3C5091 TEES BEnigrLuny 7712812312 F OUI TAD ARN 339092 TEESHA = Bendganugd — 77/2312312 AVERAGE | LSE ‘WERK? Enip)) AS CAT sense $5, TAMERKS as WHERE S.von 2 TA. ust) AND. ‘ 5. SSID 2 TA. SSID AND SuB + SEM 2&5 ok str]Eg osngtim: oy ca | Fopsoide " sco sqata SHB) SCHRIOA DT AGRAIMS Emyinyee son [ Ftvome Lowe | Adve | Sex | Slay tarsst | MgxStwitfde | Disc | Ng Tat Dlecatfon Die L—T Pisco fen ssu [pe T Heurs]VARCHAR 2 (20) on AReHAk 2 (20) (DNo_vakcate? (20) feumeny yer, SRSTPATORTE DATE wAgcHeRe (20) VARCHARE (e0) is VARCHBR2 (20) PDORES “VARCHAR? (20) _ANAME VARCUBR2 (20), ADDIESS VARCHAR? (20), | SEX CHAR (1). sex CHAR CD |__Saengy INLEGER, stray notapen G8) SUPERS VARCHAR (ee) SGL > SESE DEFARTIMENT ; Name hoT NULL VARCHARE (20) Dneee, VARcunke (ee) MSRSTRRTDATE DATE mgnssn VARCHARE (20)Sau > DESL DLOCATICH; SGL> DESC PROTECT; Hone rh eueme fuocaT ION ono SGL> DESC weRKs on; Hours ssn rio. nah for tu, OT DLL, VARCHAR? (20) varcupke (20) ryyereer (32) VARCHAR (C0) ‘WARCHAR 2 (20) varcwene 0) numBeR(2) VARCHRE (20) nomBeR (38) _CORAIE TABLE Dioceti | ( DLOC ARCHER? (20), PmAMe varcuee> (29), PLOCATION vARCHeR® (2 Did REFERENCES peeRTIenT Coun))s CREATE TABIE UORRS oN jC Hows na ER 2, SSN REFERENCES Emfucyer (S50). -—Phid_RE PEREWCES EROECE (eng),ENECEOL ENCSOL FNCSEOR ENCSEOS EWCEOE EnesEO5 ENGKOG EWACeoL HWACcOe EWISEOL EWITOL ‘SgL> SELECT * FROM TAMES HEA EDWARD AVERY aunts NEHA pete sat VEEN NAGE OH SOL > SeLECT # heconns, IT ECE 196, Ose Sort HEGOE mauve Nv k KUMAR, HR EMPLOYEE } BANGALORE BRUGALORE nignlont ySoRE IMAN§RLORE mysone BeNGRLORE oANgncone, angndont MYSORE, BANGALORE. From DECRRIEHENT o1- Ol. ote on A616 TON) -03, Ave“ 1S Tun-op _nnness & _snipay_ m 456000 hn 500000 M 700000 re) 650000 450000 00000 350000 500000 600000 500000 SB2n34s _MeRssiy Eunecoe EWTTOL FH ECEOL EN ISKOD BW CSEO5 ect qyskART INTO EMPLOYER (9st, FAME, JHBIE pnpeEss sex sunny) [ynues C*EMECEOL” ‘San? * scar eeuenionk” or dateds | sist tnTo_Keerucc (ssn TUM BM DRESS) Suk) |_vALUES CENCSEOI” “Tees”, Ssmrin', Spanien sore >, tr 500000); [nseAt TOO _EMonteR (sean suse sos, sn. sna) | venues CEN CSEO? |*HEARW? “BRYER” "sanemoRe ? ‘mn, 290000): | SWVSERT ZnTO_AMPLOYER (ssni, FLAME, JnAME, ADDRESS sex, SALARY) ge “mankenione’, *e” 350000); pALUES CEWRCOL “qua”, [Fase core enmaiee (ssu" mene. name, anos six 308) puurs (‘EM nccoe? , ‘sanruosh’, ‘wumae’, ‘Peni fore’. "m', 300000), | anseer tur _srmenover (Sn, MAME, LNAME, ADDRESS, &4,-SALAKY) | vazues Cewsseo.” * vcenn’,"", sone 'm”canna0) ————___— [sear or_ceme (ob name 2000S Se SA) —— WALES (tewrror’, “magest * fa, see,“ Seco )3 $$ }—_| }———|AnserT_1nto_DEtARTMEAT VA a eee 8 (4 counts ole Tio, “eAccoe,. | tnseer romo_pecnstmentvawues O°, (37, ot-but 16 e192 tnvseat tomo _peonenienurvnuses.'3. ‘ee ot EAE | anseer_rnmo_pefartment—vawes Cie wr_vauues ('5' easn RNLCEOL ENCSKO ERGEOS ENCSECE ENARO) ENAcOR, ERISECD EWTTOL sas nme tne, _ ANDRESS vom ois, nese) nn rave oust Ene ed serra VEEN WAGES SELLE TRON IMLOPEE 5 stort sh Bake scot EGE reek sm k ere ” HR Bannon yng PUORE ato ysoR, Pong ySCRE BANG LOE oa uke meni LOkE MYSORE BANGALORE S__SwARY Mm Asttto Hn siete fe Hee mH setteo Mm ¢s0teo a) F so0een F 350i ft Botta m 60000 sono ENCsEOR, BICsEO3, EUCstOe EMCSEOS EMGEOS EMAC? Ta om ee tn ee DoMMYYY “pppnte emir sep _SuPrRSoML2 MULL DNDe's? AER ssue ‘ryece oy; [pare emmomee sep | enpe ssn = “WSEC2”, Dun>'s’ ERE sovbe ‘EHcSeal’ > > euesEnA’s PERSS> ‘ENeseOR pune's? wecRe | pepare ertuayre sep vreRsshis'zieseoe? piipe'S” wiere sens "Epeseos't [uepate gmooyer cep UPERSSN="HML, Duo 2s” were sale "ENCSEDE”SSQL> BANE NLORE Ban neone: BANGnLone. MANGALORE. NAWEPLORE Hours Phoe ssh ENCSEOL ENCSEOL ENCSEOL ENcsE oe ERCSEO) FWCSEOS EWCSE OC ENCSEOS, EWECEOL EWACCOL WAC Oe EWTSEOL ENTTOL SQL> SELECT * TRem WORKS-oN } ceftrttthe aplennee’ 2Ds qwsgkT—In10_DLOCATION aww, | nse Into _peeeerton vases Capnigeuter? ¢27), —T gnsget NRO DACLBTION vacuts Ceangauope™ Sy, | snseet topes pgs 1), —___ [aniseaT INTO _DécueTronl _vauues (*Mnerigueps’*s'), —————————————— JwaceT ITO _HORYS.on amuizs Ce, “eueszor, 1009; | anseRT INTO _woeuS.on)_vavues (6, “eueseor oon); ‘InseRT INTO _tuets.on)_yatues (3. “eucseor”, 392)5 __|_-tnsenr —tiyro_yneiS.on wanes Cio, *eneseo2” 200) i nes C3. “euesco® 100): . ups (4 eyrse0s? ton): |_sniseat_to__wonus.on vanes (5. ‘eestor, 102),SQL> SELECT # FROM PRODEC ~| eeouks ToT Beng nlane: 5 usteT IND OMUNECT waves Cunt ‘unis “meicarone » 652: cLouD BANGALORE 5 _qnishhT INO PROTECT vAUES (ite "Brepere” ‘panesesone” ‘5D. BIGDATA BANGALORE 5 | -pniseRT INO CROIECT vanes C103 ‘sensops” *epncnunpe 3" SENSORS BANSALORE 3 ss ORE att Pact —“BLE Jom BANK MANAGEMENT BANGALORE i 105 SALARY mptingenteneT BANGALORE 1 406 OFENSTRCK BANGALORE + 107 SMART CITY BANEALORE 2 (sepecT DrsTincT _f.PNO. FRON0 PROJECT P, DEPARTMENT D, EMPOVER 5 WHERE EDN) = _D. DNO. ANID _D. M@RSSN = ESSA) DE. 2300000 BEC000 TaMes 550000 BEARN 770000 FAVANY #15000 __ Summ (E.SRLRRY) __mAX(E-SALARY) __MIN(E.SALARY) __ INCRSPL Aa CE.SA Ew esmpin) tn [e.shseey), Avs (2. 50080) | ceuect som (Eeseeny) Mp | reo empuovee | nepeeimsnr p WHERE fem = DeDNo Ap _Depuamk = * Accounts” elHaving count (*)>5) Grove BY D-DNO 5