C.f A-SSMA-t.e..

Date :
Page : I

r- , ) . ~

.
·~7 . -r i\. I

\. I
\7 I

'\
I

u . I\
- ......... . ./ . u \
\ -,.
'\ I

. r--

I
1
l 1~
I
V- C
'
__. t- --"'II l J ' ''
I

B"'4 : @c~v-, ous-. PYO<:i'<arnrner

J I ....)

Tl hi hat- IS no -rmaJ iz..0-..:Hon

.
<
-4" · Norrna.l i -za..tion IS t-h e., p--r-o ce s..s of O"'UC{nt'- z...rnq
I
.__) _)
t-he d ctJq cird t-he. cert"("' i 6 uJ-e.s oF- Cl.. d oJ-a_b a s e. .
. I.. t- p-e "C f-o"" m-e c\ t-o "f'e d '-I C e.. t-h e. d aJ-~ '"'I'€ du r, d a. n c-->
I
'
In °'- d oJ-cLbo .s e.. &, -e f') s l.\ ... e.. t-ha.t daJ-~ is -st-c-Y--e'q I

\ cq i coJ L"f •
'- I
N o-rma_.... j [Link] Of')
'-'
. is .s"' sh~. rn a..t i c. ooD--roct ~h oF- [Link] ~irn
I '
ta-b\e.. t-o e...\ i rn i n oj-e da..tq -red Ltn d [Link]-..., ct_r·) d -
\...\ n d es i "(" a.. b I e c.h O"f'd c. te r i'3 b' cg \t 1<-e. ·, n s i Cf) , ~ Pdd. t--~ eir
a.n~ ol~~te.. . 1-
. N o,y--moJ ,·"2-a.J-i o {') j.3 mu.J ti f~p
-5
I
O"'(' 0
I
e. ,e S .S +-hoJ- [Link]
da.t~ in r\.....\bu.l Qr fu"("m & '\'"'€. m o v e dunlica._f -e_
I

,!
d a_tq f-co rn r-el oJ--i o n tables.
I

._.J
 -

[Link]. e.
Date :
Page : 'l-

Ta..b \ e 6-P ·Office.\ '-:. . ;:'.:-i ernplo"le es . .

I

T rl N [Link].. Ad d"'(e s s P'f"' o Fess i o 01

IO I '\Jishal PL1ne. 0€'V€.-\ C)p
I
e-r
IO 2- Vi'1a'\/ Nciqar A c:[Link] n ta. nt
s vv
-
I0-3 h...,-ee_ BQed [Link],3 t
Io l4 P"<'o n cry N~shi~ [Link] r
v
!OS s ei ~"fa b h;;.; M'--'rnboi C\ e"f"k
r '
\06 rrt Cl'\/ U , [Link]... O pe"f'a..t o,......_.
v
'
' .
i
·.

_A, -r: "I U

- -
C.v . -ef p,J e @cL\ '(' l OU j ~ -p'lc 9 -co.m rn e "'("" I

.__,/ I

I-n t-h , .s t-d. b \ e

I
.Jr , we.. hove.. ·. do...tq of oFFic€.-
e...n,olo..._,~e.5 . · I
I
I s..
I

.-i ~ s-e~-H~n AnornoJ"'-f :~

u I

An ins~"<'t-icn CLnoma.J "I 0 CC.\.._\""<"~ in +-he '"'(' e..t cti-i O r)

d ctl-Cl. bc:1. .s e when so m e.. u [Link]-.... i b '-.Lt-e.\S o-Y- data. ; fe.f'r)
I a-re. insev-t€ ol inro · dcu-a..b Qse u) it-hou.J- -€"I< !.Sf~f')C-e,.
0~ cthe--r- aJ-t-r i but-es .
I

-
-· ~---· - - ..
iJ u odoJ-1'on A no rn aJ'"" :--
I
I
v
[Link](! )0 AnomaJ ~ occ..u--rs c..u h-e Y"') +-h~ ..some..
I
r.......J
[Link] it-ern d--re. ,-epeaJ-e d U.) i t-h t-n (:. SClr0€.. v cu \.le 8
Q"'f'e ne>t lin\<.ed
I
t-o eqc:h ot-he"f'.

........
 -,

[Link]-t.e.
Date :
Page : .3

'2>7 0-QJetion An o rn0-1ies ·-

Qel-e..tion ctnomoJies O [Link] S w he ri
d cl-e__ti n a on ~ p Q "<'t- of +-h e_ doJ-ci d eJ-e_felS +-he.
I
_)
o t-h e r n [Link] s s Cl--r" i n f-- o rm C\..,t i c n f-...,om ~he ea:b
V
d a..:.h1.b a. s e .

-k T'1P e5
-.v I ,
oF- N o 1r6) ctJ 1--z oJ-, on
i) L NF
ii ) 2.. N F - - -- - - ___;_. - - - -- - - -

d'1 ) ~NF ~[Link]'Y'iows _.:,. ·P-r--oax-q mm [Link]'

I I.....,/

iv) [Link] ;

- a

·,
~ I
• .D \ qq"<'Q rr, :
....., 'l i NF= l
,,,~I 1-NI= l. . ~ -..

Na-Y--rnoJ iz.a..tion
"'
1 3NF l
,,

.,
'"rl BCNF I
_..___ __________ --
I -Jr Fu [Link] oncu -~eoendcu,c~
I
:·•- ·-

1J- is 0......- cd-i or"""$ hi P

tha..t e"?<. ist- b ~..h ..o -e-e.n
"('"-e__\

or
I
-9:.two sets ct.t-tr, bu..t e_.$ oF- Cl "( -e.,\ cJ-i Of') aJ [Link]..
~ he"(e_ one. stl er CL,t+,r i buJ--e .s ca..n d €..J-e-rrn1 n e..

'V'O-t '-t e... of- oth-€-r stl of- o..,tt-,\ b u_te3 . I

L9-e..not-ed 6'4 )< >1 '} :
I
. . X IS ' d e,~"f mi n0-n r
.
and '-< IS de p~nd O...(") t- ':

,
,, ' -
 [Link]-SSMA-t.e..
Doto :
Pngo: ~

ff iN~ ( FiY-st r-Jo"fmd Fo-c-~ ) -

'In i-NF -c e..l 0-.t-i o n eoch t-a. 6 \ e c~\ s ho uJ d
' q \e.
c o nta..i n q ,S ln V o..-1 Ll e. · E"cie h -~ - -re co -r d , o c\<.- s I i !.:. -e._
.
un1au e •
u
I

Pla"-1€'-cTd P I a "-I -e "r'I"-' o__ rn e._. ~arn e.-

__)
0 ,-J S horn C 'r i e lc:.-et , Hoc\,:.~_"/
OL \/a ish n c:1'\/ Foorba ll
u
~ 0'3 Gau,.-crv Ba .sF--e..t ball

H (.'<e.. .
I() Q d rn e.- '('Ou) e... e.t-o'f"ed t wo qa. f'() es so it
t,)
.
IS
'-...)

mu.H i -vcuued tlt-Y- i buJ-e. IJ s no t 1- N F y -e,\ a.f i o n .

Cc nV'€"ft i r i n ro 1-N F -- - - - -- -=- . . ·{§) CU"<'loU~ --p'<'o q-<a mm er

··- -- -
-
P, O'\fe-C Id _ Plo!\Je'f'Ncu-ne Qc:Lm ~
I
-
OI sl<ctm C-r i C \.=:.-€...\-
Cl Sham -1--=rcc. \~-e ...,
I
I
02- \/ a..i sh no'\/ Fa orbQ.11
0~ C:r Q Ll "Id 'V B q s ~ ~t-- be\.\ I .

1-f-s a i mp\e rnekhccl · t-o st-o-re Gtorn€s sq p -e "<'o.j- e. \"

I

in i..t-1 r. Now +-h i s

.
F i ..,& t- N o'f'mo...l fofm .
1s
I
I

l •
iNF wa..nts t-o ~-t-o-re. LH 'I I Cl W -e i nf o -rma...t t o f) in t-ob le_
;

u.J i t-h OU t do...t-Q ,y-e_p€a...to.t iC,f) .

I
 [Link]-SSMA-t.e.
Date :
Page : 5
11

I
I il 2- N,F ( Secol""\ d No-rmo J FoYm '\ ·. -
/

lfl [Link] 'l"'~\ a.t1'0 n must be io J_ Ni= . · 1-n 4-he.. I

second no'f'mct..l f-c'<'m oJI non-1~ -e"' a..t-t-v--i b LLt- es

I

v
' o-ce... fuJ.1'--' fun [Link] o
I..._)
l"' ncu. u
r, alep-er ,d a....n t on
•
th ~
h-ri ma -r '\J ~€\/.
I I. I I
I
I
I Sh. ~dentid SpecioJ I [Link]
I
s ·h.-1d-e_n·~ Aae I
-cJ
So I Ph~~ic s 1-'l-
.__)

501 Mo__tl, <2-2- I

S02- 'Z. () 0 \ OQ"I 2..'-1
--.J
50-3 [Link]~·f'it ci.7
503 Baton'\ / c:i.7 I
--' . l

'
In t-his t-Qb le.) .[Link].. IS '
d€P€.n d on Sruden tld
. J
w h t' c: h IS su..bs-et oP c o..nd ial aj- e J::.~'I Lts not ()..r--) F I
I
_)
.-e..\a_tr' 0 r, .
Ccnv~Y r +--his t-ctble. in . tw o pq "fts . I
6)) c.u'<'1o u.S- •p'('o9 Yq M mietr
.Studen t-le\ St-~ dent A-a P
I..._)
501 2-L..
I 50'2.... <)_~ .

S 0-3 9... 7
find
s~d~ t-Id S Pee I oJ, [Link] t _i of"\
I

50 l Ph"$\cs
',
SOI [Link] I
502-. Zoo\ oo
._,
"'I j
l
I
50-3 S, OJ) S \.: T j t .··.

sos Soto n'\I

J
 C.f ASSMAt..e.
Date :
Page : ~

The •fo \ I o t.0 i " q two tab le s q "('€, sqr-i s f"f t-h e
-.J • .__J
co nd i t ion~ CF- '.l-N F y-,e. \aJ-i o n . l l- ctJ so 1n 1- NF fo-rrn
.
[Link] '€. V €"('" no n - o-r I rn e oJ-t -ri b u.t ~ 15 '
d€pendClnr
I
\ I......)
Of) p-r \ m Cl 'f_"I ~e~ .
I
~ \..J

<g) c.q"<' \ C'-.\.S. - -pY-oq-rct mm ~r

-
~ ~ NF (__Thi Y-ci ~OY'rncJ \-O'lrf") j .' --
The. .e..lo...H0n in 2:>NF- it- it 13 \f) 2-N~ cu,d no
fy-o..na i ti o r, depend CLf'I c"" ~)( i~+ . N c n - p"f' i m -e. a.J-+-r; b uJ ~
. [Link] ~nt- on th_)e p-Y-1. rnq~"'/ F~" .
\--5
I I
I

S~d~tld s t-~d€n t [Link]., e t-u [Link].i occd e.. 8h..td€nrCi t --1

I
0
301 Adi t"' q L\ IJ...2..602- P~n e.
' I

3Cf Adlf"/Q LI I I ooc Ko\ hq pu-r

-
80L Ma..n ddr [Link] Ket\ '\I an
I

~0'3 R\..\shi l4 o o o_g_g Murn'boi :

Its not '¢NF b-e [Link] se .I SNd-entrd -> 8 h..t d eritc it"'
I
t Y-a..ns it iv e__ d €.Den d a,n C'\/ .
[Link]~n\--Z..ipcod e. is f)(df 8~p€ Y- I<~ 'l l) s N o\-en re it---, i .s
I
I ) l
r,c t- DY i rn e ctJ--tr i b ~ .
I

Bn-1dwtld st~ d ent:t--\ o..rn e oh..td ~nt z., o c: cd e...

I

'301 Acl ,·ti q \

.
~ 2...1-6' 0 '.L
0°1 Ftd it"' q I
L.t\\000
(302,_ 1110-n d Qr L.t 0C)OO I
Go-.3 -Rushi L.\ 0 0 C-9-9
.

I
 [Link]-SSMA-t.e..
Date :
Page : '7

<:0Nd~+Locot1'o-n '>
s h..t d-en t-.z r P<=o de S ·h..( d €f,t Ci ·1" 11 .
)
~ 2..'2-6 0 2.- .. P\..I n ~
Zif I ooo ~o\ hqplJ r
I

l..lOOOOI . ~ oJ"' ct f)
I

~ O o c...9--9 r<lt..tmba..(

- r-1 e. co f1'-' e'Y' t-e d t-he t-C\ b I e. int-o oNF b"/ co nv -e1"t i nq
I

it- into two p C\ "ft--3 & rh -(>_ 'I don' t hq"e. t---ra.. n s ,· t-- 1' -v e.. J
I
I
~
/

[Link]..ne......_,.
- ~ome d e.o ~ d [Link].i-e ~ e ou3 e -red u n d ct nc"i If) da...t-a..base .
I
I

I
_J
- R-ed'-tndctnc~ 'l'[Link] ~cl b ""'l BcNF .
'-.) u
@ c_u '<' 1o '-l S - · p-rc 9 r ct rn rn tfY'
I

47
'-..J
8 CN P ( 0 0'\/Ce
I
-Codd ~ O'i'rnaJ Fo 'f'm- )
.
- Bo"/ce - Cod al No'<'ma-1 r<Y'f'rY') IS net<" t- P Cl "i t- o f- Z>NF
- Ta.b \e. rn us r be
.
-~ n oNF .
- .
To..bl€. I f)~c Ni:- if "€. y €.'Y'"/ N n eHo f) c\ -e.p en d a n C'\/ )< ➔y
I I
~ is s wp-ey-'fe--e~ cF- t-ct ble.
'-.)

£"'MO lo~ ee. Cc de. P-roj ect Id • P'Y"c j ec\: L ea.d er

'o ,0 ,...,
Fos A iir
V

Of Fo/ oons~Q'Y"
02-- FOL./ Rohan
c~ Fo2- P""avin

Th is ..:M ta..ble Ir) .. BNF

. Fo-rm . Bu.t not i f') BCNF .
 c.f A-SSMAt.e.
Date :
Page : 9.

- Fo-r non tv-i voJ wnd: ic~aJ ol €_Pe_n d a nc_'"\J P 'f'c\ed- Lect d err_")
I
~
'
P'f'o i e t tL1) -e , P"'c......,i € er 1d i ~ D-r i m e_ oJ-t-Y i b LLt e. buJ-
v I

PY-o ie ctL~Q de-r I t) not PY' i me aJ-t--Y-i but e. ·

....J

I - Fa -r fc<:Nf conv-e-rr t-ab le 1 nt-a th-r-ee Po-rt-s .

I
tm o,o'J-e e Co d e P-ro'1ec ~1 d
v
0 ,0 Foe,
.,
or r-o I I
~
I 02- Fo4
00 Fo2- - I
I.
@ C.'-.\ "(' \ ou 8 - • p-ro_9Y'd. rn m err--
PccieetLea.d e-r P-rojec:-tld I
V J

I Pr ii r f 0 ..3
8 C'[Link]-S. ~ Cl Y' Fo I
Rohal) f OLJ
P-ravio FOL .

~- -I
"Th u~, we_ c ony-e-rt-ed 6 e ~sl I t-a b I e.s int o B c. N F . B"l
I
fo e: t o, i n o d-.
- _)
I

I
!Camli n! Page

•• •