Scribd
Upload
61 views67 pages

DBMS Record - 1

VTU 5th sem DBMS record

Uploaded by

D.Sameer
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
61 views67 pages

DBMS Record - 1

VTU 5th sem DBMS record

Uploaded by

D.Sameer
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
You are on page 1/ 67
a INDEX : Hales Mbstasuy Database aly t} 2 4bislo, OAs Daflabane _is-a | 2 \3. alisle Mouse Databane _a4-u AGE: | 2 1 4 lls, College Dakaloare a= | | | 1 fa Company Dalabane 2 FAO PATIADURY.MARABALESHIVARAPPA ENGINEERING COLLEGE ScHEMA DIAGRAM oe pee Books i ook fd | TAL Padolinnere —Rame | Pill Year | iF - Yeas, io | {Book aa wi ssy Boat 16 - mMae-i7 8ay 13 Sse 2300 08 -Janwi7 das wt Sot aga 65 -aps-t7 226 2 o48s 20-Jan-11 aay NG RAO BAHADUR Y, MATABALESHWARAPPA ENGINEERING COLLEGE } | Tite : INSERTION INTO ‘TABLES Pago No, 2° {experiment No’ ; | Tract tate Galen psret —lef'emame, heivay' Vf Commission) i ; — | Enke —__yoluy fox . std Ss | Erle vectury (oY — A&name + Datel Ente Valu fov (cunt Entiy_ — Vober fov Commis or Tings Pirlo custome Vater C ficcet, ‘fename’) "Gebty' , Fgrade, f yids. ntre Values -fov céd__s 9 QL Ente Vatuy tow Crome 2 pata Ente Vatuy for Clty 3 Bete | Ent _§ Valu for Jecaclei loo | | enter_ Valery fo” wt tN Tract into prdury vats Choo. —|'dodate’, fetd _, ¢ Stet) ‘ |} Ente Valu for for fox. fox | Ghee rat fro ‘RADUSADUY MALLU ARESERWEARUP ENGIN ERIN G COLLEGE Query OOTPETS § eo ———. pimeace ot | Seo | geo . RAO BAHADUR Y. MAHABALESHWARAPPA ENGINEERING COL )LLEGE Pane Neo ae Date__| | Title: ————_____ : lem — | | | | —_ “ | l @—Count thie __Customesey —- durite gecade leet —_—~_barng Lotet. __ouuestenp.¢ = Pee oagunaen | “Cott O) ay _No-oF- COsTedpers Farm Customers _ wee {C Hust pg ib 7 Grace : : Hettag grace CSelet aug C9 rade) - ~ Customese shee city = | btere')| @) fond ite name number Of att { Aaliamen usha had move | oe “ene Customese | Select nome, Af Fuusm. Sates —Ushiste And jo CActect or 1 erat From oo volary r 7 = Geese by Setch — —~ ~hatiing Cound Coed) >1) TAODANADURY. MAMABALESIWARAPPA ENGINEERING COLLEGE Mysore 295 (Ruyove}) “Raut Qab ove! ALL & Musove RSet aay No wet 4 in_city| | Select -fetem HIGHEST ORDERS; | szp sName | OpaTe PAMOONT wa Dauiad 0a-Jan~!7 6574 ne Bob 05 —Feb-ly¥ 43251 we ©, nh Paci Ps — Malt 3626 Wa S at ba ! am | es-epv-is | Baa “Bile Posy, BLore aaa Baby deer ae Rote a3 RAote Masuy Aloe aay RLore Rey | RAO BAHADUR Y, MAHABALESHWARAPPA ENGINEERING COLLEGE i Date_| | Title: | bee CSetut 6. pid, tne Si Achy , C2 old, Gl Cereate og View drat Péncly Aakiuman 2 ° a | ee : J | Ciziaks \ugeur UrGu EST _ ORDERS a \ I Geter hd A. Anome, Ol, pdal el Lams L ee O~ diy O61 : eats Rd dad 8 pani | she Ol, Oats = 02, odate )* | Co cdey : Ce Cnameg Fiicmy Sates ‘i Urstomen C Cohan 4S gid = Cid and Catkteys A 4ebbey) Coelut Lisid 4. Sram 2 bcity 0, ced | C: Gty uo Custemers IN eyry! d |__ Fiepy _ Calin & —_urstoen Cc 5 lishiar 4. ids G-pid and C-cfty 12. seta): . | —__(CAtleart nat C02. pamount) _frem OFdiny 02 | ‘RAOBAIIADURY. MANABALESHWARAPPAENGINEERING COLLEGE | ® selet * from s g pie MMISSION [sid SNAME SeiTY ee Tit Daud Biere | nS N3 Mumbew ao ao a a . RAO BAHADUR Y, MAHABALESHWARAPPA ENGINEERING COLLEGE oo =| | (Date _ | Title : = "| | | @_o« «1 L weation—loy | £ Sint io ALL | py ox dicy moet Dito be oleliled) Delete Fiexm ales er 40 Ath =11 9° és —— ‘BAO BATADURY. MANABALESTIWARAPPA ENGINEERING COLLEGE SCHEMA DIAGRAM: Act. Name fick. Crenichus | Dau — Mame Din Phone, | Moy —Tith. mov Yean| Mov_lareldix; acs | LE a (pao BAHADUR Y, MAHABALESHWARAPPA ENGINEERING COLLEGE om (a a me experiment | itle Movie. pata@AsSeE |= it No} LL | Conse fotloustag A thenoa—faaf [| meu YL actoR CAct id Act name, Act —Grendin) | prRecTo Cpe it toe lene, Onis Poe i Movie $C Moyv—fa Mov— Trt, Mov Ytan | SF | Movie CAST C Act. a Moy fd Rete) | Moy Lang Dic 14) T Rating: (Moy ia Rey — Stas ) |TAGLE CREATION Moy = Yea Numbey (uy? re) Moy Lo “4 Nasithasy (1a) C. z 2, ° ° ee : Artie cascade) 5 ‘RAO BAIIADURY, MAHABALESIIWARAPPA ENGINEERING CORLERE 6-R DIAUuen Act Name > (Rao BAHADUR Y. MAHABALESHWARAPPA ENGINEERING COLLEGE oe eee Cotto Calate Mote — cast Cack tat | Pago No. = " | Rey Stars, Vaouthoalas), fqn Key (Mou fa) Ste hescences Morrcy_| (usu a 1003" et eed pe ember (3) £ + 02)__paatennstig — heyy | —j-Moywid + nemo peaaie eb rnaric| —Kety perce ae Lo) seria tat H—|ferefon key C Act fd) stthesrencin Actor — |__| “Cac t fon tty ney (Moy — Pol) Jer fperen ces Mouiry CMov. ?d)) a CHent ante Rating Cio I Sout * fren ———_—_—— Fr”... oT lact-z0 | ACT wame | A [ 2ol ANUSHEA G Boz PRa®Has er | 303 PUNITH 13 ,M Wp ee Termy | M Sunk ¥ fstern Piocator 5 \prR_iD | DIR _ NAME [DIR-PHone | | 60 RaTMoOULT StS ioo] | IgGl HITCHCOCK 47 6613 79)1 | | 6g FARAN | 499677653) | | 63 | Steven srewters, 84 $4 T1bS20 Selut * furs Moukey 7 Mov-1D | Movritte | Mov- YEAR Moy-CAanG (DIRT j loo! | Batutoalé-2 Joy Telus | Go | $002 | Bathubeté = 1 aS | Telus | ép 1c? | Aah | aceg | Kannada /él 1004 | wan Howe | eager —_ (82 | sea: pa RAO BAHADUR Y, MAHABALESHWARAPPA ENGINEERING COLLEGE 2 Date _} { Title : 3?) = | ie tNo| |_| nxseatucnt TNTO TABLE: Le Subo' zcfot vatuy Cfact— ft! fact_nd “f ock 9 ence | enlie _Yaotiny fh of __oltfe__ phone if 1 616 ilo0, eI: Traut —_stusto _Mouiy vata Cg.onoy td _| | Entre VoULLLLy fos ol name: Rey moul? | omo Eee! fmoy yeas! £ mov Lang! | €ntro Va fox _meov id +t too] ~Cntig__Voliing__fof ____mey- bit 5 Bobubale- 2 | I Ente Vedi — fet __meov- Year i adoly | |enbig —Valuoy —fot___moy_ lang 2 Telugu | E nti Voluy Pot Abs id tbe po RAOBAHADURY. MANADALESHWARAPPA ENGINEERING COLLEGE gerect ¥ [som Metue - Com Ack _ tp Mov=TD ROLE. Bol loo2 Flestoina. 3ol lool Heseotre 303° too beso ee 1002 Gut Boy 1ooy Heoco Sunt € frm Rating ; Mov-iD.- Rev— Staes sept x 1002 g loos 5 looy 4 Qa = 7) (-qa0 BAHADUR V, MAHABALESHWARAPPA ENGINEERING COLLEGE | Pogo We, i Fe aa ul) (| ite eae ce [oe — | | amas LS peewee J i [| Tnset ctelo _ morte cant vet C facts fd LPrmoy ict | Ff teote |)» 1 Lentis va fox ack wd 2 Sot | | Ente Vatu -fov movi; ]002 - ean Besta’ Enki. —__Valury___Pos___arote_:_Heeto iae| iF Q i = . a Se | —Taseat—_surte__Rating C&movfa_'f seoy_| lc )- | Gatien Vatu for roy Pol ¢ Lme | | Cater Volts fox ty Stasis 4 4 Sea= - |

You might also like