—— |
— =
oma
=
al
: _
Fumehional Depsndlunty 2. 2
eds ii
Commder o Aclwon R ond 2 arfetbutes A ang gr”
an 6 2
— Bis urcHomally dependent on © z
| as iy ent, Value —
| A 5 a orecianed mie era) oe Valu eRe O
| iw febron £, =I
\
Retahronal Modal =
(he, Sobatronal wrodal ums a Colleton & teat,
sto Hupreseur boty dala Ond tre Kelas oushiyc
oumong thos data,
j
5
Studi CRNO, name, Frame, dob ) |
I
[| We
| R( A BoD)
| en acne 8 \c |p
vi ia [Ta le [es r
ME la, | ty |b, 1a |oe
& | oe ba Oy Oo co ae |
l ay) A | wl alam j |
; Las} Op | bs [ee [ay | |
Check ADR door not held. —
chek 4 >o > held. Cassmate,
Gea —
hese =
Co Ap + > 7
Gp SOs wet? 000s not helt
_ VS -
Sr hold one +o One aN 7
Many to. One S
St downer held C
one sto
nanny. ney
az oD des nor hold
r o> e Aelds. ar 7
I
] | chet Ag >C heldg
| |_check co >A hetdg |
[ ~
|
1
of endl S
Xb Key un the helaton R 7
Whe x Qe. ath butes ox Sef wf
athibutes |" Py, thre Aven Peloton.
D) Cuncirenal lo Gav +
ae 8 es fon
aes gf Constrart
Tagheree! cependce anion oh wy oe aw Notion :
Bs ee eae ak bute _te—
ch Clocene of an dltenibe ——————~\
b The Gh a pela aC Aj 4,2)
x ,
Pe = ADB, A>D, esos
at =f 4:8 6, BY
A
Cawu of A.
Closure 4 6 = Bt=Lbc$
ty et = fey
= Lbs
(pia alsa al a ha Wn
se FDS = 2A SB CSD, 82S, DE, Edah
ati Ae coef
&t = Cec, Derek ay
cts tp, CABG
‘Sevieany el
Sor: - femnehioral ipondon Sea, a. Oar ex fa
rer rl
sind eee tesiy We sahishied, by. all
|
ASA >
\\\
\
a
Sssute
I R opivity. Poke .
4 meufebson Rule
3) Trbusitivity Rube.
R feyivi Rute 3
HSE holds sf BEX
fi Lo q subse FX,
whee a6 ore attributes or Se of alfvibutes ny
a tebhion R, (
pa Ay
ype ey
Ap 2 fF LV
VAAN
Aé — 6 —,.
pec —> BC
Rule 2
A functional Aepondtonicy, a> Bp Bolin, How
LL
| Yas ye io = BN
| - = Ce ty
| where BY ae SAI or) u
p—l|_ge jbubes WW a eK
[to ad
lena A> &
|-— DP Ac SD Bo.
[~The Rule 2 —
tos
_
7-—_] [Some Additonal fates —
[DO Union Rube:
x—> pf aw
Da = PY.
[Q_Decomposition Gales
“a> py AB
he az
S
¢
pas p jay ?
{
7 held ow no
@ Peeudo- bronsifvily Rubi
a—> B and yh 4
shin ky > 2 i
Closure. of o Ser oh funchoral Dependencies g
eg ft FDP, adap EE Gm
= aD
ROAB,C,D)
FDs = | A> 86 65> C, ABsDdy
EC dwwe ot F=f Asch
- bez A>B 9 Boe
[a | a | SS | | ee ee a
=[ASD
bez 4B 2D WY ADB SAADD =» AOD Foy Asc w Nady & 7
Onn Some Wd dpendviis >
usta atfyibules A,B,C,
mm a D&E ellos
FD ou given Coke 2005 “aus seg”
hoc, C056, B50 E>x4h
Hae Poltowsing punuronral “dipendeucles do nok
Lied by Hae obbve sek 2
Tay ep 2 AC
by BD DCD
ce be DCd
a) AC > BC
Be eDTL{ CDE, A,B oe CD DAC 7
218, DY only 7
RA Bic, 8, ¥, F)
Fdc:] 138 ,A>Y,6C SAY, AYZ 2G pyock | i
Tat] 7 | of A ty @
r = fAG, Ae, AD, Age, ACD, ABC
FDS
ah all
=> tf 1% :
| o ={d
ABD,
{|
aE —Teanidan a. talahon 84,8 0,0)
Pte = $A 36, BSC, Cd) D>AS
‘
In
>
[s
eo)
At =1A,6,C,PL —or a
- [ et ee pn) ee
find all camdidake keys
\ \O VSN RRR
Vet
salt
ieee aeRO OME Cordis ky
j = A
a y 6
eS Cc
j be ote keh dB
uf on athib ule dale Comeliclate
Tar wid alse be 0 ko
Pro de not @ Ondidabe ay
fey Het dor a Matin, RLA,8 (Bre F)
am pele B=, C3 Eco sF4
eds =
gone
Agt = ALAS, GE ABD AB
EDEN Bz>D
FOs
+ tepp > Rigi
| AB,o2 9.7. 0, Bee ia!
pe ER So asm, WwW AB whssing
fs) up CKoy
“EComail 0 bulahon RCA B,CD6,ED
[PO=T AB> Di C>B D>ch BFE TF
Lys: : RHS
418 o,9, 8286 F
[ ar ‘ CA
(33 *A°So am pork fy
LLLL
cK ABt = LAG, ED CES
- _ act = fac 0, ee 5
LADY SRA DCF, BE}
—~l i
they, eptiong = - DB ACAD.
EDs =f Abx D, 2 by PERS HT
3 Y
LHS on 6, 6, DEF §
faB.c, 6h ie i
Geta 1
% 4
Orc ~ Vv 3
= (ai>>: as ‘i
on geAady
Os —> GE
[8 AS, AC pe, GB/QC Qs. * Ukere.
yaa FS 1a
we
2<_|| Ronddern o twihohan' KR. CA, @ CDS, )
de = Uno, BeSP, E54 0584
ee aes Pecos? |
(ys TAA RUS
A C,D,6 PL [Link]
q £14 classmate,
qeG =t fb, G4, py :
| Bey = LB EG £,D ay a :
rea E,Gh A
| Deg =A DALE G,6,c4 ;
I
(a a qlakron A CA,&.c,D,F, &) :
TH
Find minimal Set 2 Minimal FDS |
[ f&de=$ BLDDA,
Ae ca e/a A Fue a
Gc 36,
| AD BF, =
4 es 4 7
+ CD ?;
! xA 2 Gq 4
LL aceon amet
la Sestousienn ADP we DGy
|
TT 1 2S
1 \g
{ \y
t 3
jt Cid | “C-nome [ Lid _| Pname i ‘i
dD ll ¢, Chy e puter = ] log
aby On |. Sutias? \P) S ee: pe
at Ce kan fa Teams = i
me Cy Piya Py Trowpan]i| 1982 bin? a
ai Gs figa 1 P| Tye | PP I
Ce gona 1 Pel teesl| see?
Ce view | Pt = rt | SO a
“al Ce Riu Po, Taunt | 134
_al C4 viru Ps sir | ae
ling Sita
ee yoy _dabere Fanaa ecard tho, oy a
| D2we Prveniiays
Delete Trouser mo
from tobte Piya
ei Solin pe duredbul
OOM he x
\\
4
AA
1
Let Suppose we have ft add
Pe cap
Gero the table 0% can't ingot ; :
, Cap daty tebe :
C id!
Sut ber wivthy + We Con nor In
tape tech . ct lout
l yes ene woh pak MA ub, Budo, & Coname,
[se Tomct inset Swen pecord tol prey .
ipa Benonraly |
ya cut ke. obpra We updo Gry prroduck prrijee
Code we have to takhple” tines are)
Bi wae wis’ Om record Le us create Onconision co,
oneal sot Sf updere d Youre Fine Us Create Performance”
sua
Seema at :
o Tt ty O ypwces oh grouping athibubes nto well
Se yulahour hate Gotan minimum tebtindansy ”
in
ab sfocures CroracielanG = tpedbic ont,
He One relahion, ghoul Dave one ghee a
Litt LI 4
g
s
Z
5
ieee :
” Rarnavee —_ B
— a Deperden - ss
aN fasenore Oven —
saree Qumove Noo- long —
one po Ngee
Remove Repeatorg groups > temove mult
volued tthe)
+
A veolahon & un oid dy be dw ANE Sy swore. do no
omy mwdsivelued atbibate
T Rell No
<7 Cowtse 4 a
DBMs, CN, 03
ae ote
> Mabigle Moog a \
ee * Ty Wat Sol® we dd not Imcreane rca, wens
Insite.
[ave [Name [Couns
Pda Dory
a
os
ee vo ADA
Rou OPM i
Rowe CR A
@ Wp |e q= pe
now uw ithe aloo table MH RolkNo La no
LAV \\\A\A
prima. Kee
Solution 2
\p We novo create mudliple icolumn,
Ronnlo | Name ] Counsel | Couiged | Counge?
Bs Am Pers os O38
x Ron | AbdA o-0P™ —
\_3 | Ravi tN r i
Rrobumx > 1 So momy nut yalus (Spate anc)
Py OU
For ay above Solahons
We Ouvare two taloler .
RC RoiNo, Narre, Counc) RoliNo(PR)
wz
RL Ro NO, Name) RLRotiNo , Course)
R f p )\ wwe
aT Nawe _] Samet
[Riya
Rou) =
Bo Qo 2 som, LOO
2NF
\\
i 3 C dp oon dp
A valalion @ Sp Said do be so.
abwadyy Joo LENE] ond Hue oe 80
: cl
aityibule Jw R which Yo pastiolly. dapencionl oy
:
Ee
Lr Wee \-
\s\Erala\el
fartial Depentons eS
WET ROA BC Oe) ete Ni
eae Ckey = CD 8
ir | Pama othibute > 1 C04 is
Alon Prime athrtuka => 4 4,9, 64 —
dif CA 9 a
7g ataseD.
ee |
aan Tmdbkey T : ce a 4
SN T
classmate,
aAgt = 3 A,8,C, Dd: Y
AB a Ck .
> wo 4
————————
&§-p Du
~~ sS
Bee D Decompose selatren Rand make another
Flan with attribute’ Boma’
R CAS CD,6)
pee
84:82) Ro (6,D)
Bor|[PO = TAB Sch | FD =U BSby
Now above tise deromposeal rolohon WwW jn 2NF.
+ | RLABC0 ) LFDs cf ABC
| D726 4
1 Stet Lis \ 2!
>E,8,) Ce)
ee A,G,D é
coh Agpt = LARC. 064 = Ckey.
—
7
-
m2
m4
pa
)
J
Pesime atinbuses , ae
Non Prime attrioctes
Cheat ‘pantal dependent. le LF records ane not giver Thon los ae
uuiden ie table INE by oapautt EN
ps AG 2 Cut fs SR
both Fd, au Bn parted aaperdong
RCA GUD GE) ‘i
RCASD) RalAaGed) Ral D6 NT
Porsficte t {ers tesd
=,
o
Reyuied }
HL
4 ;
A tulad @ ie Hald oto pe Jn SNE IF Sie So
abuody S101 2NF ena Hore vin No” omy, non
prime attringe Jn R toluch Uy ivanaeively
Dependent Ow te Key of
RCA Bc dD) “Peet assel mt
ca D3 =
ph ol
LHS RRS NPA 1 =
8,6 SDF ou
2 “ARG a
= UA 6,¢,05 = Gakoy. Haan
ae =
SeeE heck posal dapendloncg.
No portal depanden dene
2, Tudation & Jody NE .
clescmate
| 2 Check £% trans}
me $ tapi denny,
Lp A@—>c & c->D
i 4 St FR
EF eR NPA NPAT NPA,
[4 1
— hee D? Go -trandy vely depend ont |
Wow “Decomposition cA
8, CAG, C9 Ro Ce, D)
FO = {Ag} ZESBY
Qi RCA Gone, F) i
FRB =4 A>DECF, C3DE4
Steps chaok @: bon
Lh 38 RHS
AAS. B60, 6,8
6, 2,6) Py
At=1A,/8,0,08, 64 =O Neey
Step 2 Cherte hor DNF
A>ece & C>dE
No gortial Dependency.
oo RQ wo OM ONE Aw ecr XC 2 Ps 7
= New NRA -
PA 7
DE one pronaitivelsy Capen mR
i Grep yt Decompose above lost - _
4 7 a} ;
a ae
R CABG ED 8 Ce, 0,6) -
>
TPBr= LA SBCES 5 OSVE} ——
| Cheek EDs vote el MHCR a AQ arr ert
| NE. Given thor RUA a
Gd) and e key = Ab.
[ee
> ABC ’y AB>D csp a o2e- &
4)
joyce Codd Normal Form
7
A aulanon @ Jo catd dy be Geo Bone ty Se Rp
Taw BNF Ond por every functonal em daney
ZT
> B, X Should be /Supen kay dn R
EDs = £465 cD, D> 6}
y RCAB SC DD
Steg + Cheek for Cr Koy
ABt =f AGC DY
ADt = LA BC DY
2 AS & AD ane Choy
ro
a> prime _attibubes = ABD
Non prime Obbibutes = ©
sttp2 chetkK for 2NE
porttas dependency ‘
| | => F pont of prime). [non game
+ | attribute J | attribute
! | &o thexe in nd pasties depundeny,
SD Stvin one
| Step 3 Chee for SNF
Check how Donstvely depencon
mim, Ae non prime attrpweda tren Date
a
=
a
Loo ako dm SNES
Step ced por ote gS
KH —> ®
Pan a es
& should use en.
|
[ARS
YR AB do a Sy. 10.0 1
I \o = a)
| No
D So Mor A Sky.
La
i wo R Jo nor Im BENF
jgtep © Decompese Balad
H {
REL O) a.C8,8)
| ost . -
| DS>LTA3cD = }
ll <5 EOL SSR
Dy n\'s quaat ony 1eD
T avon oak quate « wy Do Sama as
ees
Sa Sap SS
a
ae a
Se ee =
oe RCA /B, 0, Ex, yt
FD, = 2 ABDC
Acoek ABY - C ey
Ap > Ee: Bcy
g ~ D Acy
Ye
Check for Myrest possible Aevmat Porm,
OSIN-F bS 2NF CD BNF. DD BONE
&ps ® 5D (pantal dapenclancy ).