0% found this document useful (0 votes)
103 views15 pagesDbms Assignment3
fdxd
Uploaded by
San DipCopyright
© © 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
0% found this document useful (0 votes)
103 views15 pagesDbms Assignment3
fdxd
Uploaded by
San DipCopyright
© © 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
yeeeres
hts
An toh Cn be a Sa). tonid bie that fan he.
[tally ec fof examples dn 2 gobs) daobaye
| divdenkt, eather’ » Caste » ard Covdial offered can ve
ge AS enhhy- Ghee eptiiey have tome aie
| 9 poopesr ey Anat Provide theig entity.
“foity pes
he “Eohiy type YB dpleeron pF the ontty
having dimilas” attn'outes + Prample. atydent Aaule
We “hove eth pow Bt JO entity ang dney are
hoving domo Girshute ve eduh toy Uynbaint ie
tayo valve bs altybute Loon, Age Studesk_ name
one
Dd Mobileoo. co, We ca) define She \PUDENT “avle
| DE an entity Type beawe jy 1 A Apllestion of
Rntthey oving ame —_Didrsfouted Gn ¢0_dvaAsam
enity Fy ge oy defined bu _g name (Aquoena) and 2
: det * op" Abs uted (Qn) 10 Yupert- Name Age Mohile_no) Lokty ded
Or Se a get of eoky an of whith here
Sore 8k oF any hytes Al) enh won on
diginey Ventitied in an entity bd Vat i
a) 4 eelses entition hoe X dibleoent vet of
Valve fod Some e+ of anrvibuia. Gn a dolabaye
LAD entiy der i tepitdented by the apie - Below
we (aif lee are vers Y Game whith has
Multiple ents enhjy. he duo dudents have re
Sayre name _dyman bY, 4H tty axe._Unigvely
Menhibred by Rel) no. U
Qo No. Name Cousse
2 We donp pres
2 Suman Mn)
5 Oe tage Hopsluote
4 ¢yman Eledtroni'es
Gudent Table. Ci J
Gret_are tus tau off Entity de
2. dymna Bokty deh
2. Went Eat det: I A Cs VE Do opesing
[fone Ave sept sented by “mean, oF tretl pemraie
(ied beibvles . AN anaibtis have values. 4’
=] a dhident enhty may have name slay and ase! ay
anole: hel’ els a vane of vaner anor
a tan toe Auianed dy_obwbura-"A Gygenkt name
“| tonm? be 2 Puen waive + Gt hod 40 be aloha beh.
EL Gdent fge AMO (Aannor —_loe regakw.
Gyped of tywtbutds-
-dinple _obbiute:
GiMple__ Orsi buts AVL Alymye ales
whith dang? be divided Pogthey. eg A cttuepte
Drone _oymbey kt an Atom yalue en Tse
tompogite Barn buhe:
: Commpoline _aHslouiel Ae mace of more
4 than one _gimpe _arisibute - eas dindene Complete
=fure roy hove rath_ename and lad?_name -
LMesived Abn bute: ;
Derived ule ae te atpibules thor _
LOO wt end) tne pla databae but thei valves
erie) _(tyorn —_janay ~2vinbyies predent in are dolabaie: ff
il ay Page tan be ceived om date Of-birth.
v2) eiogle Votve atau:
é ine waive Gliibule-_dontain ding
yay - Ey 0th) — Jeu Nombed:
W
Milby Valve_attybute
Ppt vole avsibvte _omay_tontain
moe fhap one values » eg: 4 penlon dain have.
Mowe than one phone op ¢_umar) aadyest +
@
Gate 4the _tontepr oF Weare enn
An _ entity ype chould have a bey Dérvibdle _Cohih
uniquely gers h_enhity rahe ently Sct
bor Shee _enee dome wiih type fo _whith
Key aii canlt be dekh ede ape Called
tex Enbly type:
A ‘are Wwtok enhitied donst have any
ie Hey they. damot be idenhied on shed
own Fen fey Gepend on dome ole enkty (ourer eit )-
Zhe tne ety aypet have partray Mac. pa
¢ aye deb of! abtnbute! “Inith_4he help of
t
a Mh — Hee Ayples oF thre weak enkhes an {Wear enhy iM depended po
7 Ke dhe Cnidtente YP Wegye ony Lie gt apy ts
[wo 04 not hyve Any pomom Hey Or nrg ©
a] pio _atleximinas_ Hy slic When” iC pepsented
— 1 “by doule Seo} ongfe stlation ha one Seong
1 Od 6re ear cob a Kepludenked by dnide — 7
— | diamond, a |
ag |
se
Be
Ls a\ -, Me ae :
pid @ i (Trond L-da)
—
[dane Boston! = hn
find Endity
ud
|| fe Ae :
4) Detine an Kelatinn Ship, a_flabnp iy Bln
ek
=
ey
>I Selabon chipt
Al_telahindhiy in the lontewt of databater
Lit & gHahon that Crit’ betueen tyv0_delakianar datyiay
calles then tne dae hal a Awan Hey Anat Selene
pomay Hey oF tre pies fase Y [latin chips
Allous’_eldvionst dovabauel tp dplit and alnae_data
In dierent da yien Any Akinavation between wo onl)
Type ied 8 Wiatondip » Cokie dave pay
In the Selainchio +k iy teplenked by diamond hap
Gs A bathe _deathes —dhaenis . veal," vecabei” sen
selbtion Qhip 2nd AhM iq dhe selahnnship eked a
Rathey nk and a divdent oat.
bi
|
Aes aye Kelahiodhn Aygo:
ine ~40-pne:
Roth dghes ¢
AN have pnly ane Yeon
ON Clhes ide op. the
Selohonghiol. Baah pyimany
Key value Aelakes to apy one Seed in ty I
SHored dave v
=
a ana
I Noe one, oy ma
“| in the Belated ave. Ghiy Felahindip
[do Are one between yoy
20 sore
\¢ Tintay
! Te and point You have
OO one. Motes but your pryrhoy! MOY hove fevesat
Gildan - - oe
1
3
Be |
pw Many- dp. many
Lath deld jn bah dgblet dan
— | elate {0A furfeeas oF veootd in tre ody
dable + fox ante , SF voy hove seveval sbi
lo your si ¥ling« Unave_many aiilingg )- many-lo-ma ran
yewmrindrips sedvred a thad dave , “enon ot an
Asowae tae, beeawe — yeladunal sypierns war
dio?) atiomnn date the _welaton Ghip:
—_|Relotinn Ship det.
2A lelatonghip 4 an att anvaaion Syrony deveras a
=] Ctivied « a
I Brornpie: sa i
: Haye 4 depagtoy ~ 102 ea
CUttomess ony xelarndhaip set Account eohy entities looh taven a enaii
Ve to, -to)lts
(obese [84 en --:-+€n) 1. a “‘regosnp-
a
(Hayes pA-tor) E depattoa-
ER Draasame
|
database howling ome
| D640 an PR Augpan fa
oth Bann can ‘hare
ve emule sandhee_» 2nd cath
osanth (an have
acto! and loans:
moltiple a
|
—T _
— | 1 2
— | — *
aT . ‘ / | = . —
“pael_(eoar Bag (Bion 16 Ware
— ] _ s —
TE Bank has T Branch |
L
ms ; a
< Ofek
(Misanid a Latin 5
roa Loan Account | .
Lan ‘Type.’ [: : —
t-—— _ | Account —TVPe
Grout Galante
~fitoike by
Hold by ;
cudtomes
( oom Cif bymet Nome. u tuddomer Asdzes }
‘ | AL Oigasam of a fanr . i
la Dian an CR disasam oy a dakabase
dhowina Hospital en + he_Yospiba) aan bane)
a
dab4 “about Abtilr Hodpitalt oye of Tbe aArng
Aaai tities Aiven_at tauh haipitay , and parents,
atid Abstied ———— Falpial
ital rn / |
TX
—came|) fC Aas Aasness (Nome )
Poaititote > q tadtaut 00
/ a4
|
Roatrtenis ~ Parsenits
— | : » am \ w
ype a (Ratane _ Ale_oo akrent 0
— > . Name
DAK ab, A database is being dandifusked An ep _dvate oF
“| the Stamt and pome OF a Sport leamue + A team
hat numbes of “playeas Mot al of whom opthiergate
in_eath dame » SPY GC defined +9 Peep foark oP-he,
—_|_ players Parte lgahing iN eath Aare Poy eauh HeAm, te
| poditions Hoey pigud” in ahah game, and are Seblt of
—_|_ dhe game Sesion” an @2 “Sraaram tox thi
— | pobiiaion. —~ “ _—
(Ret 7
are Db of-ployeus > playes! }
tam t— yoparesapane i Gane |
1 <
!
7
d
, ; 7 ~ K :
| TLAVER SPY
pres
=
/ : a
Name’) (playerteam_) « olyer number fort pare
ie =
Page No.
Civen on (2 diggtam Ay a databave hol wing
Game Gath Bann! dan hove mubiple Bianrhed
And eath bbanth Can have snp ile. Atlounte
and \pans-
AWK = PRawenee “& ‘tie BRarien |
Coit NY my Oe Anoess Bian
Acts /
ay OK _ Loans Amayat?
Chett® gloat
; - (fran 0 Dype.
[Ate oun Type \ ‘
i Loan
Act ft
etn 2 7 {oe
= - dolar ah
fend! “Hares gst yh)
FY] Conttwutt an G20 do _yecord the _mapkt that
GtudertS det on _Aitterent eras of diPtesent
Covsde olfeags.
ah) chame (dime) deeno) Coo
gid) ame =~
NL J Nye : a
TStudent ——7 tare poue eC counter
/ \ / Nana
—
\y [opreayys | —
psynarn _/ a
oe mans CREDIT Cees)
cid __ tvam =< Hire
pane place?
a Condivd and CQD dy decond
dhe. Sool
i
Prangae rent — dydiem-
Vv Sane)
Vat su
eee
ag
as pm
Care) Se
7
| Te
on chap bgt
x aa
Les. Guare - 4 G
‘ae ; EE Wea y wa
TS wi — Sted nee ae
daasess_) ams iW ) : Styantze. Cane
N
Gimme Cae Zoe'—T ats |
CED
—_]
wos) ce - NO
OB
Conuisvet an PQ-dranram tox a cay ¢niuranee
tornp any whe —efhmens dre dun ‘pane ox
moe Gant eth Bach Cay ‘nas attotrated
with zero ov any Dumb wf yedorded gartdentt .
~ =
Pores =
pom Cie fg reat)
| Derdon | un eas | <<
= MS =; 7 - epee -
f = < - ]
-
