NoAnmalizal ien

Nonnalizaion it Hhe process oh mininizing gedundand

a elaha
Rdundancy in elatin may caue inteaim, dletion
and cupdate anomalit
qedundanc th ato
Selete Anomaly
C-id -nae P d P-Nanae PPrice
CL Chatu I50D
Suha PI Shit 150D
C3 Rancho P Jcans. 220D

C4 Torousci 100
3:htTShit 1300
Suhas Py
PL LS0D
Raje P3 TShist 30D
3hist (500

Jh detete ancmaly , it yase daking

dellíng Some element
Bcoz b that pasticulai deleton Sone otee paaticules Elemmenk
alo deleted nohich uill be not able to geTecoves baek

Jneat Anomabs
product Inta fhe abaye
hauing
het P5 CAD
 above tabl
in ou above table, eID hich iA eutomeo id
priay kuy aohich astl be not hell &uniqe
This stuation Called Jniat Anomaly
Update Ahonaly
ete assuhe Cue ot he praduet príce you have
incsesend , Nha ise have to wptate ke prtee cveyuche
dotaat tin Peateamace Jsue hoill Bceuu
i} yeu have doHe changeu' to Sonaa tupee but not al

caltbd UrdateAromaly

into hell-suctuwd gelati nu hat Condairn nimun)

Tedundarcy

Ehence bh hbrmalizal en Ou Relati shoald haeOTee

 3 Raju
3
P.k D 63
DBNy,Ds
CoA OSA
Rancho
Raneho
Name RNo Coue Nane [Link]
atlibutes
Rn Mullivalued any no
ishese said
NE in be to R
isyelalin A INE
ndenics Join-
tnti 4NF
Valacd ulfi kmeve
BeNP
appiag Remoue
pend1neied
eranitye
pendeneiet
Parttat Remote
em Ptikka[Mulliyalud
fapotint famoye Rolatioo
Unnoamalzad
 4iB.E thibute- PainelStagle Non
CCombinotion)
RA,BeD,
E) velon
ath Asume
aibute kay)priMal dependent
on pattialy whikch Rin
aute (imple) non-pme no ishee SNP in
alseady
is it it 2N in be toeaid in
gelatlon
R A QNE
nelatfon oniginal t
3 Raju
DS 2
2 Piya
Raneho
Coute Nane CRotlNo
Pk
tabla Jecompee
he
sJ LSpoce Valuas null
Raneho 3
Con D Piya
Pafu 2
Cy bRoll
ColuMs nosA2 addadd ypu Jh Sol
 Panial ependeney
C ’B
C-’E Y

7 NhNo pattal dependey it onby one key Atribude in a

oelatioo
S R(A.B.C.D) FD (Hunctional Defendanie)

Nen-Prime SiplaAAi butes )CD

Pattal Aependuncy Prucnt
B ’D
Sol eeompode Yelatiom X imake anothe nelatisn
oh aHribute
[Link], ?

R1(A,B,c)

C"Ke B.
 Hunckienal Aependenc
Coneide
Bis funct'enally dyendant
Sach ale associated asitth eactly
Valee selation
R
A R
bl B
a b d A +B

doesnXAIB2
a

Cheek i A>6"tdoii no bold

cheek 4 4hald
cheek e>A aloci not hold!
cheek does not :held
chek . D . B J+. hold
hiold'k:
cheok doca nat hold
check

E is a ky in he abpve Relat'on R
Adunistina Depandenuy aly
iskoy in he gelalsa R
wheu dpau attibute
Candtdate key
 Note'

X 404 play a key rale in ditkcuntating good datakate

dexiga fem bad dalabate du'g

D h notiro

ohere
deleamin the valeu d

Cloue
relaliso RCA,BcD)

A >D

closuse B
A,BD,? 8TB

RCA,BD,E)

A->B,.
L

B’c,
 hold alo > then
Rate'
Traniiltvity
hold 4c>BC Aten
holdi A’B
helalion
R
CAB hods alo tp rathen holda
e-Bc edF dependey tunctonal
BCAe A
ABC>A
Yelatton
R
or
6tSet et atibatey
or ae
whee
'a in batey atti
Reylezívtq
Rule
Tranutivita
Rale
Augmantatin
Rude
*Reteatvi
Rule ts
AntomuArmtongs
obvicus
relattons
al Sattabed
by 4 aoe ay
beeause trivial
betoSaid Bependsnaies
ale dunctiona! Some l*
 atlribate
a TelattR

ana B ’ c hold
A >c hold

AAAAfanl Rale

aluo holdu.
whee Set aue attri butesY Set o etlibokes in

A’Be hold

eeomipo hítim Rale: A Pa >ph hold

4 alo hold

A ’ Ba holo
Hhen A ’ A’c hold

But AB c thern AC2 holda or not

hot lwe
Aloweo But

rB>holds hun <r> alko holds

&BC’D holds
 6h D4,ind all þo 8tble
rom aion R.
RCaB,ciD)
PPA } AB,
B’C
AB> D
tranitive
Pseuoraniitiv