8/9/2019 Trillium Software System Training 21st Century +917386622889

http://slidepdf.com/reader/full/trillium-software-system-training-21st-century-917386622889 1/11

Ph No: 0891 2728543.

Mob: +91-7386622889.

Email:contact@21cssinia.com

37-12-14,plot No-27,NGGO's Colony, Pattabhi reddy gardens,Visakhapatna-!7

Trillium Software System Training 

8/9/2019 Trillium Software System Training 21st Century +917386622889

http://slidepdf.com/reader/full/trillium-software-system-training-21st-century-917386622889 2/11

"ay1 Content# Prepare "ata $oad

1.P!"a#a!" $ata loa

•E%amin" &'' ("at)!"s

•&o *oin to &''

2.,!"at" an Entit !om a $"limit" 'o)!c"

•&o sta!t ,!"at" Entit /ia! "sc!ib" so)!c"

•&o a a col)mn )!in Entit c!"ation

•&o !"mo" a col)mn )!in Entit c!"ation

•&o s#"ci /hich !o/s to loa

•&o monito! Entit c!"ation #!o!"ss

8/9/2019 Trillium Software System Training 21st Century +917386622889

http://slidepdf.com/reader/full/trillium-software-system-training-21st-century-917386622889 3/11

3."!i Entit c!"ation

•&o sho/ a s)mma! o Entit m"taata

•&o i"/ all !o/s o! an Entit

•&o sho/ a s)mma! o tt!ib)t" m"taata

•&o in th" sho!t"stlon"st tt!ib)t" l"nth

•&o i"/ al)"s matchin th" sho!t"stlon"st tt!ib)t" l"nth

4.!ani" o)! /o!s#ac"-$isco"! P!o"ct•&o ,!"at" a $isco"! #!o"ct

•&o "%amin" a $isco"! #!o"ct

5.,!"at" anoth"! Entit !om a $"limit" 'o)!c"

•&o sta!t ,!"at" Entit /ia!$"sc!ib" so)!c"

•&o ilt"! ata at loa tim"

8/9/2019 Trillium Software System Training 21st Century +917386622889

http://slidepdf.com/reader/full/trillium-software-system-training-21st-century-917386622889 4/11

6.*oain $ata !om an $, so)!c"s

•&o sta!t ,!"at" Entit /ia! $"sc!ib" so)!c"

•&o !"nam" an Entit

•

&o "l"t" an Entit !om M"t abas"

7.*oain $ata !om lat il" so)!c"s 

"ay2 Content# %n&estigate "ata ontent

1.E%amin" &'' ("at)!"

2.al)" an"s-Minim)mMa%im)m al)"s

•&o in Minim)mMa%im)m al)"s

•&o in ho/ ot"n th" MinMa% al)"s

•&o i"/ !o/s containin th" MinMa% al)"s

8/9/2019 Trillium Software System Training 21st Century +917386622889

http://slidepdf.com/reader/full/trillium-software-system-training-21st-century-917386622889 5/11

3.$oc)m"nt (inins

•ooma!s:P!iat" an P)blic ooma!s

•&o c!"at" a P)blic oo ma!s

•&o i"/ P)blic oo ma!s

• Not"s:&o a not"s to an tt!ib)t";&o i"/ a list o all not"s o! a sinl" tt!ib)t"

4.E%amin" $ata t#"s

•&o "%amin" ata t#"s o an tt!ib)t"s

5.E%amin" N)lls

•&o i"/ n)mb"! o n)lls in an tt!ib)t"

•&o i"/ !o/s in an Entit that contains n)lls

•&o "n"!at" a list o tt!ib)t"s that contains n)lls

•&o i"/ a list o Not"s o! all b"cts in M"tabas"

8/9/2019 Trillium Software System Training 21st Century +917386622889

http://slidepdf.com/reader/full/trillium-software-system-training-21st-century-917386622889 6/11

6.Miss#"llins an $ata Ent! <ss)"s: 'o)n"%;M"ta#hon"s

•&o list 'o)n"%"s o! an tt!ib)t"

•&o "%amin" s)s#icio)s 'o)n"%"s

•&o list M"ta#hon"s o! an tt!ib)t"

•&o "%amin" s)s#icio)s M"ta#hon"s

7.(o!mat $"iations:Mass;Patt"!ns

•&o list Mass o! an tt!ib)t"

•&o "%amin" s)s#icio)s Mass

•&o list Patt"!ns o! an tt!ib)t"

•&o "%amin" s)s#icio)s Patt"!ns

8.N)m"!ical 'tatistics o! an tt!ib)t"

•&o in th" a"!a" o! s)m o an tt!ib)t"

•&o "%amin" #ot"ntial ata )#lication

8/9/2019 Trillium Software System Training 21st Century +917386622889

http://slidepdf.com/reader/full/trillium-software-system-training-21st-century-917386622889 7/11

9.E%amin" al)" '"ts an $)#licat"s al)"s

•&o list a s"t o al)"s o! an att!ib)t"

"ay3 Content# "e(ine )tandards*+eode Vales

1.$"in" 'tana!s"co" al)"s

•nal" Ph!as"s to ="l# 'tana!i" al)"s

•&o #"!o!m Ph!as" nalsis on tt!ib)t"

2."co" al)"s

•&o !"co" al)"s

3.>"n"!at" a "co" al)" loo )# &abl"

•&o "n"!at" a !"co" al)" loo )# tabl"

8/9/2019 Trillium Software System Training 21st Century +917386622889

http://slidepdf.com/reader/full/trillium-software-system-training-21st-century-917386622889 8/11

"ay4 Content# %n&estigate +elationships-eys

*"ependenies

1.?"s

•&o !"i"/ Pot"ntial ?"so)n )!in im#o!tA

•&o sa" a $isco"!" ?"

•&o aliat" "%#"ct" ?"s

•&o i"nti )#licat" al)"s /ithin a ?"

•2.$"#"n"nci"s

•&o !"i"/ #ot"ntial $"#"n"nci"s o)n )!in ata loaA

•&o !"sol" $"#"n"nc conlicts

•&o list co!!"ctions ma" to $"#"n"nc conlicts•&o aliat" "%#"ct" $"#"n"nci"s

8/9/2019 Trillium Software System Training 21st Century +917386622889

http://slidepdf.com/reader/full/trillium-software-system-training-21st-century-917386622889 9/11

"ay. Content# %n&estigate +elationships /0oins

1.(inin Pot"ntial Boins

•&o in Pot"ntial Boins

•&o !"i"/ Boin analsis !"s)lts

2.aliatin E%#"ct" Boins

•&o aliat" E%#"ct" Boins

•&o !"i"/ E%#"ct" Boin analsis !"s)lts

3.Entit "lationshi# $ia!am

•&o i"/ an E$ o! a sinl" oin

•&o i"/ E$ o! m)lti#l" oins

•&o o!mat E$

4.E%#o!t $$*'

•&o "%#o!t sch"ma in $$* o!mat !om E$

•&o "%#o!t sch"ma !om &'' E%#lo!"! 

8/9/2019 Trillium Software System Training 21st Century +917386622889

http://slidepdf.com/reader/full/trillium-software-system-training-21st-century-917386622889 10/11

"ay Content#"e(ine )tandards-")"*siness +les

1.$ata 'tana! $"inition$'$A

•&o ch"c tt!ib)t" com#l"t"n"ssN)ll ch"cA

•&o isabl" a $'$ t"st

•&o s#"ci mo!" $'$ t"sts on an tt!ib)t"

2.)sin"ss )l"s•&o c!"at" a )sin"ss )l"

•&o !)n a )sin"ss )l"

•&o !"i"/ !"s)lts !om )sin"ss )l" analsis

•&o "it a )sin"ss )l"

8/9/2019 Trillium Software System Training 21st Century +917386622889

http://slidepdf.com/reader/full/trillium-software-system-training-21st-century-917386622889 11/11

"ay7 Content#etabase anager asks

 1. M"ta bas" Mana"! minist!ati" &ass

•&o c!"at" a M"ta bas"

•&o c!"at" a *oa" conn"ctions o! i"!"nt so)!c"s

•&o c!"at" a )s"! 

•&o a )s"! to m"ta bas"s

•&o "nabl" " analsis )!in ata loa

•,!"at" a P!oilin #!o"ct

•$"l"t" a P!o"ct

•"nam" a P!o"ct