- Dr. freett ay
Soe
rocedu rot Non-P.
RelotionaL Mice Relation cobeuts
(wshot £ Apes) supe Re latiowol
cas eal
+ Account (ane »
O Select Speroction * (>
S. ew Branch (bran,
elecE Euptes (ows) pay, SP eaten Customer (crane
bnew bot)
city assets)
caret, ccity)
BH Sciect aM Loon tuples Seles ad)
+ Lown ( tng, bras cd
hyanch name Is “Hyclerob od”
“pepesitor (cnom, ane, ame, >
» (loan ) bovrowet (Crone , Lae)
Crane > Hyderakad
Q Selec all Loom tuples me brows nome is“ Hyelrebad”
k lean mount punk frou S000 ed:
Vie ok
( loan) [
Shame 2" Hydveb as!” A amewst 7 S000
fname 2” ; . (hem)
fonome = “Hyderabad” Aanat >so0 ) oR — A gut ¥300)
relation 9
QD Propet peion = (Ty a
X epioutt>) & Duplicate eli _ clinton.
» Lie at Loonno k amount Of lowe Mp eae ta OD
Thane jart (Loan) | foreta
ta in’ Pune”
Find trose wustomayy ne
Trenome ( Secity? spune” (customer) ) :
seméaning 21K frome laveatoy NY.
Q Find product vane k i
(iniviod Heck = gyocp consumed )° Tre gue ston is
investor ( prod-id , prem init stork, Orso)
© Th werent (init stele” @n-ecP) ag vemouning SPC Cindnioy,
i
. . ‘ad
asmare ( ’) votive 3 P -Awet berpe within
c net (voor) Long line
> fe) lg a
Ternome ov
eld ome ott -
et is used wun a reloilion howe Long wore oF 5
waka “pos wuetcainn posuere Mae
Aumr weet *
a Loom
ss iar a) ze At Ln he, oo)
Krony ut bute?
o [ (reson , Ord nduare )
“A fc Custemernowt , TVeust name (stoner)
- Find ou mie, amount bot io De
1 pacgat account: bat (Soeumer ra < a-bal he fe (occowrt)))
" alccounh (account )
accoum relate or acu ae qane \a- eae aa
Ane |onomt | batouret 10° 2 *
° ye i =
4, by en a & js
Or . .
ay| bs | 4°? °° : yee
ar = see
Os ba yoo
a, by 129)
OL br | 50?
Ay bo 4o*
£192,502) 433 - Unter cbercotion ine@eean (UV)
* A\lows *° twombine
YUS is vate
\) v.38 have Some arity
2) attrabyte cowmesies mnust be vom
( seme ue a] amibutes
act (bE
acon
TV cnome (borrower) e EK. “e, +>
Teese 9) mi ey Ds ea
a Pay [ borrower) U Racine S 2 A, Bio, DS
Lewy atti bute inv Evohin §
y hs
2) atmbute dlowrasine musk bt Comportilade
(A Br B
fe Ligh all Crome Lary ale but ver (oo reer
= 18%
[Link] (oleposte > ~ Tears ( boron’)
that v in both relatos
+ both
: ta, &¢
J consume Chorrower) Tene (Hepes) © nibs 8
= fai
>» ros
3) Se [ntersectiow
drome a ar A acwoon
Find all Curtorntrs whe
4) Comtestaw froduct_operaction = (Crs product) (x)
Tt is used to pwr int each ww iw vr with each rows in
xs
r( Aas -- An) X S811 —-8m)
rxs( mth) curable
Toad pages « (A. Ay
nem . Total athibuies < tm | Find Uatomer name whe has taken loan frome puri’ 5
sei
borrower relation Loom detective Accovst (ane, bam bot)
Branch (brary, bei ty, ansere
custome ( Cree, cShreet , cai)
“Loan Cine; bom, amt)
“Deposit ( enawe, ano )
+ Borrower ( creme » ee)
2
Lean. tno A brews 2 fuse” ( bowowrr toon)
ot
T\ename.( [Link] =
(Cgpaars £” Pura" |1°4*)) x borers)
am Opgeowe Lno = Lown Une
Maep
loty sfeuntton (pa)
Sequene 4 % prooluct followesh by select
(avrse bate oO
>
Sroduct Leta
cute suo (Stuluat woar)),
eas
Avsatanik bq count dike TT... (ésidaase?
att wwmbinations io
ch is va
© oan yon 5 AU”
e| cnome ath none
Natrot
Jove inner ouky
ws 308 ic
ann . Full oO
ce) sts) _
ick Snams
yMse (Feayesrs 0 Tema > (9) predun , Woe —_
Wahu gtodud. Sno > Wit «Se
b0S2 fay dr—- 493 wy '
4 Whe tect Snamt pom
= TT sno, snamne ( Shu Md a ) Siident Natural Join (ove
Be) nome dlould by Aame Ia heb reletion,
seat aad 2 / "Out Foun js
Ge MS Used fo . a:
yf Wt: outer Join deol witle wadssing Value
secs |
All Stuctat + 4
: Stuclent DQ cone
4
7 Sy cert) pees
n - Cy oo!
See \oe | wut Wl)
33 as 23 | es. | soe
sy \any \ry laa [tt
yt honed Sele
se | Me |2™ wath | rat
ss|us | |
su | my ey \ wt th,
Ss | wut wull| cs ser?
gtudud Upp erre
E [loner gen = iis based om watched olata.
2 weil Cpolity Comelition’ Ht woes (=) operator
Situdaut XL Counk
Stvedud sno 2 Courer’ MD =:
‘
- ee
Soin [ fine! a vesutt +4 combining anit: Aico
L table
y— Cress Lod,
> Natura pon
\— Corotitti oral
Qu Ape Wapioy Enome worry la HR olupt
*
Uwe wrt he OQ Common . ee vie
© omy is cose Prout + Adect Atotemmt|( Condition )
rae
‘wt
— TY
O Notwrel_Jotn (Pind Dae tap roumes wala is in a obph)
¥ .
Make cwmow athibute epyor
(ses naune, FO" Emp, Dept Une
wt § on =
why debe
+ Sind Abicunk id rhe 1
Q wu
Auect is
pabee Ty Sied= Teeid AND rd
pea vle- jor
$ emailed in athearre
tel frm ghdy eT, Atay aT
Emp bn = Dept: Eno]
7 >
Aro Sv Cr
gio 5) —er*
pr
AGN
Paes
[1 Joi AA pcoin7 Bevol| (8)
Inner em theta! Goin “con ati ging tondlsTione
he ins ‘Eapi foin : when only Corcition
Crittrio
Noduol : then hath relations
a AE
aya for tT tmp (| E-fame addon ep (DYs wutinn)
addr
ay . &
Hind gram. who worfasl in lpi buy loc Aomee ae
Dept”
sc pep Loaaticn )
Tename C Exrf> Ptemp- ewe = Dept: Ervo A ermp. Meldres
Exaeup dons ~
Y end nome Bu) tvoumulaus vita cnattrmers wlan howe,
an ale iN bank k Luks in Hariser Coan josie is avsvcats)
TY reanth toon (Ceccity =" nayrvon’ (Customer bE Accor De olapositer )
2) Find al cuntomert wea AY both lwand ale
TN creme BOOWeY ky depositer
ot
Nera (b> 1 Aenam kp ) Fer these quer ing yous for al) | Ot ath
Q Find all custornes miho hy ale ah all branches locoled eh Vey
4 AZB oe A/B Can bt applied when
“Ro Attibutes of Box pwper subset of A
7 AN atmbuto of A — al of B \
Th givel those tuples of A wauaich ausociatal 19 every BS tuple
Hy Monae ( Seen: tyderabos” [bsanch) ) Ce
+2 + Nenome, brome ( olepositor bf account )
cram | baer
nated fon sal Xx
Ae we ai de teeny emmy EES
*K AN tuples ef vg cusoctamd with) L a | ~aly
Tuple tis in res if ve, goa tlastivns
D) tis in Ags Bis -3 thie k>
2) fos every pup “Ls 19, there is a tuple te 19 + Batis typ
~ Oe
ens.
+ Btech
rtech
a) tts}: 40s]
6) te[ hs) =4
AssiGntent operon z _
use to keep tem peroory relation IN 4 variable
Q Grad ath cudtorntes puho have a/c bub no (aan
1 <= Thename (daporiter )
Anam ( borrower )
raw - n-Ae oF
. £ retums a
ond O redsutt +
oomig,
max
° Kowa
° Count 1 No of woes
umn +
Q
Sed Summiag amets of att bromcut
ort © Gisumascets) Branch
tovm ! — =
2 Count distinct cnam towty ale
& count -clistinct Ccnome ) (clepositer )
unction : Joky a tien of walues
Aingle value ad
Man -
Grw ¢ d C2 .
~ i ™~ Dep
Fx Grave cso) © ) nome | uPt cohany
x cse si
ia Y |cse | -
lount mo 4 emp in (SE apt a ie a
1 olp- (out
Foust (name ) T( sept ese? (enr))
= y
Baus (satan) cemp)
Genae (Salant ) Cemp)
Q Find branch cty wise mar amels
Fs
>
yn (sola YS (depress oy
a Not dept in culation
count -clistirct (dept) ep)
@ find fotod salary eum of at
part-Time emp at each bronchi kon
A inthe we hameto enon
“| Sale &- Student (id, nowre, Cocle-emnaliio , lecturer )
Qi whet oun, woune of wOludutlr emro [eal
) (racket )
jo (830209
Meare (Seodke_envain “cg3or?
% which Auhiects is Hector takeing 2
») (srucbet )
D coat enriin (Grecturee 2“ Hector
ay Who feachts CS1S00 of €$3020
ye)
WN uctaree ( Ccode-envatt = Nesisoo" VY Cockerill = cso”
= shat au nome sf Stiobuds in beth Cs Isp0 wd (8122?
[Sond
Nome ( Srodr-ernattin =*csisoo"” * Coole. enyoll in = CS120® i! d
Qs. Wher ou mame k tl of alt Studkuils
Trana a ( Svdvt)
ey: Poxkarurn u, 0 * = operations ow bilow velo q
Wurst
Bison
Cid \s-nom4 sie)
Clo) K cy]
cloy| A [Se
Cio6\ Y $3: _
ctoy | Z Sy
Cus\ mA | as
1) Unio: [Link]
- x
Fg name (O22) Us pour (student) f
raid (ome) Ug ra Catuded) 7 EE
Se
83
34
2) jutoucectron = :
game (course) Ne. pours (At4otat) of PAB
3) bet dajvne Tx neon (Sructint) — Mg name (00M) 5 wt — & — Srudkert (RAINS Maus, Grane)
Sooh (isbn Ti
Issue ( tatieio, Fy cua Pubiidur,)
a) oy
) Rs Hallack Naw oy ay cee die
aX
Raine, Nowe ( Sreunch sreser))C stucluxt ))
*) A etuceZle whe hy issued fovak of 67" publshe
J swe ( cratighorerend) ( Sudint Pd Issue of ark)
c) Liss she ttle A ducthor Of oll bodks wich sc iss usel by
t ,
Q Alucled wor "ABC
se Meaipenos of dS
' eLetie
18 ne poe RA MG
pc ae
relator
4 pele okt of Swrith
clepositer <- depositor - Cyst name =" smith
“= pew OU alc at Needham brandy
» (account De branch)
*s acedunh records
* (depositor )
Vi Spheardecity =: * Needhowe
Ye TMororchenamt , an@ » bot (T+)
Occovar <— Account — Tp
J
yn ale A473 at Temi Bronch.
2 \ngertion * yen tue
ae
graith waota to rv 4 pio
eanenre acecsnt VACA ATS, Pemngrid ge”, 2094
depositor <— dager U £ (isnt, A -a7s)5
\
4- 4 .
Update sv Te pe ()
4. intrenae ott bolomen by 5 7
Accout < Nano, tna, hal» as (account )
- ale with bal over $[oo0d Yecewe 6 7. intrt ,
Wik Other rusive sy.
ac
wt <— Thee tonamt, bat + 106 (
Fenny wooo (Accord )v
Tone pnam, at a ros (Coat < 1000 (account >)
View using R.A
View Is a cope or pernasiuy, With bath oj utr o
frcliow 4 DB be acceminte to Q particular urver
© Con Ae pot oF PB
Angrtari Creo, wieud Baa < uury -tubre vim >
FY - Crea, view Ou Watomer as | wew au amin
7\ \enosne, cnome (ce poritor Dt Accovet )
Y Asem core (boner (000)
— Menecsa pune” (att customer)
G. Creaty wew sane Custorner oA
TN customer ame ( Gppame 2 “Punt” Colle Uaatome )
7 Creote vtew ean- branch ob
T\ Lyo,,ronome (Loan)
wan-branch < bean-branch U Irv" "Nod eelora’”) }
L
TE MN) inert runt in amt col.
iw Won elation Dp Gate : / ae |
Cree oF
customers = ¢ (cam)
Stops = S( Sam)
Buys = & ( cram, sNom)
customers ot oll
| owe voew of dhveps wot Laue "eo
Ze —
ZS _Mavenul§) = ot
adh ket hw
A) Teves (8) Oy) 6-8 9 §- Tenor (8 )
D) S- Wenem (CCxS) -&)
a Lborory Aulational dRE
Users (Ysere, usorwan, Heme Tow™ )
Books (books, GvojeTitle, Aathorwom )
ISSUED (BookaT, Usex#r, Dette)
Cxplaian in enyee 1
. Cyaares { Tloseesr » Bootie (Coes saissven) 4 Bas) .
oo Celecl the unertek bootie stroke bof
igsued by aut 6
yp (users borswver) )
( Rooks WM Tone Towns DUA
tra booles tesued +o USES whase
TNouthersoxrt
Select cushy nore ay
Howslown is dele
6 faangn (as fares Peter, WY)
(aid, anoume , cir J
flies’ (fia, fate» Bem, bus ded )
book-4 (pa, aid, Fid, ">
I: gukad of att fights 40 bly Fat: * na» SG?
a come ra e pall Geib a
s 6]
Fig no. OL ferrewaer vith oid > gov {i gu £0 Gunna bert Tyg (Fia-rea (bookme) be Foust chennai" A folate Seen bie
Qu. fine Poume vito hora heopy in ptteaad (fant
J prame ( Parsengen de boo cing )
as- find Agency rune Located in Aoum city or Prd 123
Naname ( RY DS ao, oy. 5( 2k ag
AG OS cin ping ( Fiaces (Parmegnn) )
Fink prame yrs dm't hou book i “ag bgp
Tyrame (( Tia (onsengen) - Thi (Bookiry)) x pamenger )
Q7 Cet rt details 4 {ipo Arreluted On both sles
\] Por tay, foore at Ibo hours
| Gfetase = 1/bjeoz0 4” dime -100 Light] N[ Cpe = 2fujroro
Tims 2 (6209) (figet ’)
Q smd (81D, rams, Lat , Aye)
Courses (cid, Crome, Inshucter)
Enniments ( S10, cir)
Ql List full nome of vorudutle oueng with nowt Of courses thig
Cmalled 19 ba Enoll meds) Dey covrsesJ
T griouue,riowne,crtaune ( (tuderda
Q2- Find Nowe Of jnstnchys & Gounoes fhty teoth~
Qo.
eA
7 yatactr, crane (00s) envoileok
nvoments ) Dr Pret Gus Tele ows tured deta, niolel (Shuck
— ‘4 Sar drow fred detor moll (Shructeuredt
7 SQL is dewaww fi arguoge L coote!
7 is cll et ( tanershonie
€, cr
7 pot, pre, Det, Tcl 7 ushot $9 ole (Het low te ole)
(Pre ceolrak
“ opeatrs ( LIKE , BETWEEN , Im, WoT IN, Coritrerey OH Cokat fhow
a= Kep 4 Cons atn Ease net GxtsT AND Qe wr “
= Clause ( oder by » Grouphy , fps, ishioct
on fm
+e, Joi & Ae pad Quits
a PeSQe ( TAI, function, Cuneor, pruclures )
Sau Lorman
Dpe SCS pel TL Corchocurt
crags select Growl torent [- fe
A\in —\nob Reve Ral)bock ack
Dp updo —seamsprit Loar
Jrunada [— pul
Ronourt — not Au
om (once uve)
a Cres 4
esate
crete table emp (int (19> nome vardar2(is) , Salary ie)
- dec amp,
Altu-
Alter table Student APO addreryy varchadss\; <— To add cl.
To Kemoe
ote ” » dap column adders 5 a oelite Col,
quber fob. snout modify Id wach 2 (19), << Hetty datahye,
; . sire
alumna id to villa; < fename col.
“ “ »
; 2 pana 10 Srdent|) <— faname table
i 1 gfadanay adel | foram key (allem), psay
nt ” obac *,
" noua , Sol 12 queso fem ep vol by rent,
cat
” e pot ool by dapild sot AC:
fiat hy Th
> — Arleck distinc Name fom em
Some Lupe wrthout all
? Aut Qu Nome fom ump +
tern borrower, oar
horover loon-no
? detect Crom >
Wor? =
Whe bowover
fpan-Loan_n? Relatlomed Algebra —
Tr Select | Veogick , Rerowe
T Union, On, =
+) z
QD Select — eld Fetoti vr Aelect a tuple
“ep loe
cHtitys 4 ai (CUSTOMCK)
Ws MER
F(Pids) AWD Sal ¥=3o,000) OR (D-Id=2 AMD Sal >°90,008 ) ( )
@ Proqeer - TQ Column
e |tis Ufe Select io sQu-
We rt cleuts omy Ucote pups
ave cottedd Gutiegte etinsinotions
tmonee (0)
° £ (new, orc ) (st) sm 0s,
we ole ne nt Patek
Q ENF EW, Foam, Dpt, Project, Addren, Gerder, Ph)
find ow Male employs 4 ther IPs Wofe7~ ™m
Pooject = | Lor k then department! = Adesin?
Select EFM, ELD fier EM? where Project =! Ani oF
Rucject = 2 tae” dyt= ‘Admin?
& find Erp, nam whe woe at Odd 120 pelt arol
Mund & Hain pt is AR
Select Et, EF Nanu frow cup whe Adres = peti
ase Addros = Mevust ANP det= HR
3 Fin Dpt with peje wu ED BS J
Select Ppt 7 Project prow exp whe Elo= |
4 find nor 6 emp wy haw-p nouw
geled EFRom from ampleyus Whe Ernory
S.- fos penned Salary 7} grt?
ene
glatt with “A |
une SAY.”
Select wg ( Aalary x2) bo
G. Seleck name of emp ples em mot than 30009
geet Genome from Ere ne Sal 7 30 02°
41> select att ep Who in chrom logical ode
Select x am EMP ordeaBy EPivam+
