Data Mo dels
Entity-Relation s i p m o d e l E R Mwdlis a modl e d tor desin
Ltw data
omd Jhepie sen t a h o t nelaHevm suips
m ER mode ung e
datalbase stou U e S Poo ayed o a dinaam
Lalle am enhw-uelutiensip diagam
what is Entity
wmh as naraigtis
gemerl a l a l ool 6 e
S
amd helds nelaliesnips in
a D6MS. F0 Shudnk,
SHuduk, TeaumA
Teaumeh
aShudn is an enhy un the plete
CLassSnubje
daisek a u the studems wU6e me Enhy Set.
w w is Atti buute r
aStude s Euhy hen Shudemt's oll-n
om Sudenb namme
t
Studes e Studleks emdu e wiu Le ik attilutes
weaR Eni A emH k dependA Ben omome eui uwe4
aueakR emhh ne a R emi doesn't cAntun amg key otribnfe
wlenk emty 1s hepiesene y a oovble hcanale.
Cenept Re eyAti bue
dH tuo hupus in table
Vse Re To niqrel m
3ude Tasle
S-name CAy ) AadMaa Cuwd s)EmniiA
Kead Delv 2 ) Ro u-wo 6) Vete-id
3) ARns uhen o
) ALC o
Kumai Mmaau21
9) Phone vo
Potpety
ReAdey0eti Lo ueth Gn a l
Covn da cabe Ke
Cam didate Re W e l e nly ee apphoPuabe ky alle
AAS Rey eY of ajeMatiue Re.
Umqe t NOT NVLL3
Paumatny R
Foreim Kom t is om a/m butt 06 e oefm butes hot e t h
10 ima pey a n talole onothe taLie helahen ).
MM VJains eseKLMhel lnkMH rtin Rey
Sudent CO
C0se-id CousNe naw ol-no
PoIl-oNamme ondd
A
Deli DBMS
Resehente4 2
C NehukS 2 Reseie
A Dovn Ja va
C3 x
Base Table
EK Table m eR Se 1ynda fK ho aki h om R eh he
NO
Odacle e a e uble Cose ADP Cms ain R
COveid vaschaal 10) foaein Fey Chou-no )
Owse n u m Va t n o s 0
eGONVN fudit (Kollno)
RoU wo eerene Shudent CRoUmo)
Re-teential me fuy -
C eRepsovu Tabe)
P. ase Tabe AeAeA Lte)
Apllo nanme odl d Conivid Lie-nameAol-mo
DB MS
NhetuuDsRS
A DoDn
D siim C JavA
Refeem Tale
Aeteemuna Tubie
1)nse N ViPaien ) mserk - mouy Law Volahen
cawe iolaho 2) DeleR No olahn
2) Delefe M
sA a) 0n delk oaode 3) UPoaien - Mouy n m e uolahen
4) Gn deue tet nul
con dolate vuo auhen
awt Violohey
3) UPdoah m- om
n) en wpant CAnde
b) Swn ouoml )b
S a e Moni 2) C
Le P (a,6,t) md Kzl n,y,2) be hwv elatiens i n w i
'a1s hreim e in R1 hak hetas t nmay Py R .
Cwide to b-ptions
a)Imest iuto R1 C) Delee tiem P
b) m e t i n R d) Delee t m R
wwth is C c e hegahdivg hesurntind iaepiny?
1) 0ptien n b anse Violatren
2) opin bfc wu Luse violoahn
3) ophen ct4
O h e n d4 a
Po4Oe Peyetne
Swpet k y A u p e Pag is a tebinakien o a l postible attibukes
wwich u n iarety idemkity two huplas in a alle,
Supe se a w Cmdidate Rey 1s Spe e
RCA A A3 Ay An) then new m p e Fysahe po mLle.
TtiyA is Camdidote PEy CKPoll-va|Polmoname e
holLno, nune
uA A ore Land Aoate Fe
Poo nawe,
AER
Powth e P Ay "3, an AAz9 P43 Csupe e ) name ae
A AM Ah AaAs Cwm' besk b
ak a y n e Ck
Wy Unauey e.
a + 8n
mmtn A,A ,"3zAy
A AA Ay A Ag
A,A AzAy dsA A A AgAy
a2an-
(ER-mndel) -> A,Ay AgAu
Etit-Retutien sip mode
Loiol Jepe sentai e
Fo n capual view deKhna ha.
#Datu
has pmyticat
existante.
Am jeut mat
Ewti Eutiny tgpe or
addre¥s)
Suden4 (Poll-ve, age,
Atti bueshasace ches| puepedy (Snea)
(0 Studey Sstudy Cove
Juelaienstp
visite Doeoper
(Visi
weusik
mkit
A tobuteS type
Relatievwau p
ER Models
1pes 4tibukes in fvuobie no
VS MwItinalnd Attmbwes
1) Sivae u d e Yore
Reg-) MotiLe. o) gno Smdemy
More Hm 2mOb' no.
Y add CPeamaneny l omeapondovu) nn (
2) ple vs Cewpose Att
Cae (Sudev nae)
Clannot diuile)
3) Sto- VS Derined Att &udep
ge) Re no
i ved)
pe alt13
VS Nm-key Att
(Aesr ahl ven rey)
CUae)
5) R u e v s Ptieual Atti. CNOY pahk RModel)
Tn M h Ran hau patioudal eld
onn anmh (Mo bie wo. e )
Cna nn) Depenas n Dme darnban deudes Datla aduiMn
6) Cptex Atr
(LewpoA e t e Tuwo addTo phone mo
Mwlhalned
wwen am emhim 1s eiakA i t h 1ey ir is Pwown ou Reowrine
ReLatieni
Relatiensup >Reptesented by diaond srape y types
a) m to mu- wwn a h ims tan te o m emhit is
amo HAO enti nen î is
Cnll 4-1 heahenMai p.
Deee b RelaieM p CCa dinali hy)
1
KWToR De pashmbn
Eployee
P:Ke K F K PD-1dD-nanme
FEiAD-d K
Loc
E- E-nami4e
A D
D T 2amg
25
D D
D,rod Oel
28
A
D D3 HR Delh
PK? ahan A p u nh Er s e
C u t E-id or D-i4
Ahte hgna
mame 0ge DLid
A
ET
28 D
B LSdes Uuphue r 3
(-M (O-o
b) one to mon
Jann
Adee Tm name)
Cmsto mer Gu we M
(CosF
R K P
PK Dane O-o tem AweCos
NaM Gy
O1 O &ure 0t-D
A Jal
C
De0 C O 0
C3 Mumloai C O3 03
A Muum Ou O Jemns
0-vo os a a f} Manny (0) vnali ne
o sCos bani h fk[mostH)
T0 0-o Cusres M .
PruPe OtD
Ov UD
0 XCmstonen or Guue ko MOge nui
O Teams
c) MAny w May (M-M) s (M N)
Desni3
SMdeE
M
Sudy Cousse
PK
Pou-no name ge folf- o
A
t6
C Phy
C
1
Cay Hindi
S
NeM em is PR
uo Hti
t C Aelatnkuip talble WAuue nn
Cowpoie PK - e u o Redu 1 en T e In M-)
A w S e Mun o 0 teuo es JaA T
JepAN tuis &R odel into Pelahiea
E Molel
Y(k a) 2 3
d) S T,-E7
7hE
T
T e Ennan ud ER Mwde
4) neevizakien is a o t t e m - p Ppoadn in w i h t u leue
leu emti ties cembine to tom a a h a leueenth . w genneralinuhe
tAB, nighe eut entity tan al wnedne with 0tN S e leue
emhties to make wwtnu ino teuel emkihg.
OR
C bt ned to m a upehCa.
u b - a sses ae
Acueuw
&ottewm-
hPPmav
Saud va Cu
2) Special zalitn is epposite_ to neneai rah en. It is a tep deun
appooa in w u dh n LeMel emi y am be hepem dew
vo tuwo L u pul eit m spe dntiratien ighe Lem
emtity M wet hau onwny lowLe - eel Ch sels ' s poibte
Sudet
A
Ex-StudentCseyudew
wl elakien Ltw huo emtiies is tieaked
is ocen
3) AahWAakien
a
s a Sinale ening
E o Coue
CembseH
omayi
Visites
ER Model o BanR
anvne ren Ch- Nane
Namee
Bonnk Has BAamch
(Aadres
(Addoes t e
Mamtain
Oan-id
N
Auowmtno
N
AcLou e-Type
M Bolne
wwwww
HO14
N
u s to mei
Cust iA) Addes
Wanme Pwo ne
ER Model z_(p
NO Jam
Oeparmlag ouhm)
lawEmployee ine
nemd anageh
HOUS
wR_m
HOts
Psaje Vane
LoLaon
Kpepemdet0f, Depen det
pelahons
Oname (ende
Hiearoial Modil This database model rgannises data Tuo a hree-
iRe- Shruchuhe wh a snale heo, to wni ch all e orua adara is
e d . T n t u s modek, a Cild ode wU n l n hane a inge
bahem wode. Tus m0dol t 1 u desibes Maiy hial- wwekd
helaiewips k e ndu a botk nuúpes el. E
Coae
tsuute
Departmu
Cousse TAOA Sdns
Teny
netuus model is
RmBn t h e hieeiinl
Netuek Mnde TUUe
heH Py ps to e mamoqed
allous May ma
o
lkalawse ir ahe alloume
Strutuse
pahek. d
ie shucht tho allows Mipe
tn a 1hee -
Mee an Me pahent wde.
4o J w
(B1
imteity CenStads (
A e set oPulas.
U&e4 to MaAntain t e quu y o o s t ien
Used to gand agivk auidental dawmage o daabae
Types
Doman
) Entiy Dnteauy
3) Rehaon tial uHity
) KM
1) DDma n
Aalige o naQues o m atti bule
id Nam
Rom 2M
hayam 2
3 Bbu bl >Net allomA, Because
AGE IS an
mt ntmruke.
Phimasuybey nale Contbe nml
me PR Alue is weA t idemti ty inu udul s a u s n Jelatien
(Becme Cun't idemidy here 7us)
w l naue, tmRn e
t e Pr a d
a
i
name mCh
n DBms
Sn sa 0 S
hoya Java
t ntain a NU ane
t aLo wed o puAS Rey Lan
fr1gn key)
3) Reseintinl Jatuty
s peutie bhw +huno table
4) FeM Coshan
he ue may 8et Wed h ideutiby om emtit witthin is
*Keys
enti y ser uminal
name Mmihple Reys, n gne hwm wiu be PR
tmhftyse
Name Semester
d
2 hd
3 N o t alto untd. BC oll 0 mu ba
A & wwiae
Kelaticunrl omd 0Ljuk- jeHA data model
RDEMS OODBMns
/Relaionn Datab ase Mavaqemm eeu Onene Databate manaqenndn
SysRm.
Systen.)
Entities, detineA as Stut data as 0jes.
1 Steies data in
allts uefd speifit
igommaiên.
Handles Lemparaivuely SiMple ) HandUs age omd Aspleo da
aum ADeMS
Aata 3) Stores dafa
os wul as metods
3) RDBms stes Bm dak
to we it.
Data ndepemdeue Am appli aHon)
Dat EnaprlAh On As main
M 8uhe.
mNn ejeh ne
egham As
dishn tivaly an
5) An 9oiet idmifie (oTD)iname
S A Pimay key em
n a table Unommla gueus
dean Hh es om eje
ulaheve MoA data is Sthred in Jelaties (talsis
RDems base n
nd is tm c h p s (aAus).
sephesemd Relnien Schuma
TubLes, Tubles (inae ), Atm bk,
COnAp
StmdinFCPou-wo, maml) add , plone) Ke Onhen stan ue,
Deaiee (No
attn buks in m 9lan em (&tmdenk hos y Aug e)) , Caidnali y
ono
wplus in hilah m), 9Mmn N alu
a Pelahon A buke
dOMaunCmt atm u e hos w poe dafnid a l u l Fope) . 2 Hem
COshay vus
ieut-0ueutd data ka pen MOdes iS Jinl wuel d siuatiovs
Uass nheiitan e , Pouymapm m Atm buks ernods
(emmands obe kcal to
Data Mmipmlahen Gpeahisns> Data mwnipuulahen
nwwwipnlate data in the databae. for e
1)Seltuk
3) updat
) Dellte
5) Mae