database design for institute of chemistry ceylon
Post on 05-Apr-2018
217 Views
Preview:
TRANSCRIPT
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
1/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 3
QQLLOOVVAA[[YYOO]]__ HHFF IIHHBBHHDDKKHH
FFCCIIQQBB]]__HHFF@@[[CCMMQQCC]]AAYY]]QQMMOOAAYY
U{huhyam Mc}ckcya Mayo`l
Fh{ }ja
Oly}o}q}a hf Ijadoy}{ Iabhl
Yqkdo}}am fh{ }ja fqbfobbdal} hf {asqo{adal}y cy Cyyo`ldal} fh{ }jadhmqba Qya{ Ial}a{am Mc}ckcya Mayo`l
K Avcl Uc}jo{c}la
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
2/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl ;
AZAIQ]OVA YQDDC[_
]joy mhiqdal}c}ohl oy {abc}ol` }h mc}ckcya mayo`l u{huhyam }h ka }ja kcinalm hf c lapihduq}a{owam cq}hdc}ohl yy}ad, ]ja cq}hdc}am yy}ad oy alvoyohlam }h odu{hva }ja
hua{c}ohlcb fqli}ohly po}jol }ja h{`clowc}ohl,
]joy mhay lh} olibqma cl olfh{dc}ohl {abc}am }h mc}ckcya mavabhudal} h{ maubhdal}"
h{ cl yuaiofoic}ohly hl }ja ihduq}a{owam cq}hdc}ohl yhf}pc{a ucinc`a" kq} c jo`j
bavab hva{voap u{odc{ob fhiqyol` hl }ja mc}ckcya, ]ja ci}ovo}oay olvhbvam ol pj yqij
c mc}ckcya oy yabai}am clm jhp o} pobb com }ja cq}hdc}ohl yy}ad,
]ja ihducl ijhyal oy Oly}o}q}a hf Ijadoy}{ Iabhl, ]joy oy }ja hlb bhicb cicmadoi
oly}o}q}a u{hvomol` ijadoy}{ bai}q{ay fh{ uhy} C(B y}qmal}y, O} jcy lh mo{ai} ihdua}o}h{y
kq} ihdua}ay fh{ }ja }c{`a} dc{na} hf yijhhb bacva{y po}j oly}o}q}ohly yqij cy CUOO] clm
CIK],
]ja oly}o}q}a jcy }cnal c fh{pc{m y}au ol}h {aal`olaa{ol` }jao{ kqyolayy u{hiayyay k
olo}ocbb ihduq}a{owol` yhda hf o}y ih{a kqyolayy fqli}ohly, Yhda hf pjoij olibqma
y}qmal} dclc`adal}, ]joy mhiqdal} ihl}coly c u{huhyam mc}ckcya mayo`l fh{ }jc}
ihduq}a{owam yy}ad, Ol h{ma{ }h `a} cl hva{voap hf }ja hua{c}ohly iq{{al}b
qlma{}cnal c} }ja oly}o}q}a ol}a{voapy pa{a ihlmqi}am,
Cf}a{pc{my }ja folmol`y pa{a clcbwam clm }ja mc}ckcya mayo`l pcy ma{ova, Az}almam
Al}o} [abc}ohlyjou *AA[/ Moc`{cdy pa{a qyam }h `a} c jo`j bavab hva{voap hf }ja
mc}ckcya dhmab, Cf}a{pc{my }ja bh`oicb clm ujyoicb dhmaby pa{a i{ac}am,
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
3/33
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
4/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl =
3,5 ]JA H[@CLOWC]OHL
3,3IHDUCL_ KCIN@[HQLM
]ja oly}o}q}a hf ijadoy}{ "Iabhl pcy fh{dam ol 3?03,]ja oly}o}q}a oy c bac{lam yhioa}
ic}a{ol` }h }ja ijadoicb yioaliay cy pabb cy c u{hfayyohlcb clm sqcbofoam azcdolc}ohl
khm bhhnol` cf}a{ clm {ayuhlyokba fh{ }ja dcol}alclia clm aljcliadal} hf }ja
u{hfayyohl hf ijadoy}{ ol Y{o Bclnc, ]joy oy }ja hbmay} yqij khm ol Y{o Bclnc, ]ja
oly}o}q}a pcy maibc{am cl cuu{hvam ijc{o} k }ja uc{bocdal}" clm mhlc}ohly dcma k
cl oly}o}q}ohl h{ olmovomqcb }h }ja oly}o}q}a hf ijadoy}{ Iabhl" c{a }ja{afh{a
mamqi}okba f{hd }ja olihda hf }ja oly}o}q}ohl h{ olmovomqcb fh{ olihda }cz uq{uhyay,
]ja oly}o}q}a u{hvomay c aihlhdoicbb kalafoiocb kq} cbyh va{ affai}ova clm qu$}h$mc}a
ihq{yay ol ijadoy}{ *kohbh` clm dc}jadc}oiy oy cbyh }cq`j} cy yquuh{}
dhmqbay/,Yava{cb y}qmal}y cf}a{ }ja ihduba}ohl hf }joy fhq{ bavab `{cmqc}a ihq{yay jcva
`hla }h mh }jao{ jo`ja{ bavab ma`{aay yqij cy dcy}a{y clm UjM }h ihql}{oay bona F{clia
clm }ja QY, ]joy yjhpy }jc} }ja oly}o}q}a clm o}y amqic}ohl u{h`{cd oy u{hval
ol}a{lc}ohlcbb cy pabb,
]ja oly}o}q}a u{hvomay c fhq{ bavab ma`{aa u{h`{cdy }jc} oy asqovcbal} }h c bhicb
qlova{yo} K,Yi, yuaiocb ma`{aa u{h`{cd, ]joy oy cl huuh{}qlo} fh{ }ja uhy} C(B
y}qmal}y pjh pcy qlckba }h }{clyfa{ }h bhicb qlova{yo}oay }h `a} c ia{}ofoam ijadoy}{
ma`{aa f{hd cl ol}a{lc}ohlcbb clm bhicbb {aih`lowam oly}o}q}a c} cl cffh{mckba u{oia,
3,;IHDUCL_ YALOH[ DCLC@ADAL]Y @HCBY
3, ]h u{hdh}a amqic}ohl ol ijadoy}{ c} cbb bavaby,;, ]h u{hdh}a clm cmvclia ijadoy}{ clm o}y cuuboic}ohly ol Y{o Bclnc,9, U{hdh}a clm alihq{c`a h{o`olcb {ayac{ij ol ijadoy}{ }h cyyayy }ja abo`okobo} hf
iclmomc}ay fh{ vc{ohqy {cmay hf dadka{yjou,
=, ]h u{hvoma }ja oly}o}q}ay y}qmal}y k ay}ckboyjol` clm dcol}colol` qu$}h$mc}abok{c{oay clm uqkboyjol` dc}}a{y hf ol}a{ay} bhicbb,
1, ]h ihda ol ihl}ci} clm jcva khlmol` po}j h}ja{ {aih`lowam oly}o}q}ay bhicbb,
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
5/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 1
3,9IHDUCL_ YOWA CLM Y][QI]Q[A
]ja ihducl oy yo}qc}am ol paboncmc" [cgc`o{oc, U{ayal}b }ja oly}o}q}a oy {qllol` ol c
fhq{ y}h{oam kqobmol` pjoij ihl}coly c bok{c{" fova bai}q{a jcbby" }ph bc{`a yowam
ijadoy}{ bcky clm }ph ihduq}a{ bcky *ihlyoy}y hf ;1 ua{yhlcb ihduq}a{y/, ]ja oly}o}q}a
}cnay ol }ph kc}ijay hf y}qmal}y ua{ ac{ clm iq{{al}b u{hvomay bai}q{ol` fh{ dh{a }jcl
=55 y}qmal}y,
]ja oly}o}q}a `a}y ol ya{voiay hf c }h}cb hf 06 voyo}ol` bai}q{a{y pjh c{a va{ ihdua}al}
clm azua{oaliam ol }jao{ foabm hf y}qm, Bai}q{a{y ihlyoy} hf bai}q{a{y ihdol` f{hd
Ihbhdkh" Ua{cmaloc" Y{o Gccpc{mcluq{c" Nabcloc" [qjqlc clm }ja Hual Qlova{yo},
Ua{yhllab f{hd }ja olmqy}{ocb yai}h{ c{a cbyh u{ayal} }h u{hvoma bai}q{ay,
3,=H[@CLOWC]OHLCB JOA[C[IJ_ Y][QI]Q[A
U{ayomal}
Voia U{ayomal}
Yai{a}c{ Ol}a{lc}ohlcb[abc}ohly
Yai{a}c{
Amqic}ohlcb Cffco{y
Ijco{dcl
Cmdoyyohl clm A}joicb
U{ci}oiay Ihddo}}aa
Ijco{dcl
Cicmadoi Khc{m
Yai{a}c{
Cmdoyyohl clm A}joicb
U{ci}oiay Ihddo}}aaIhq{ya
Ihh{molc}h{
Bai}q{a{y
La}ph{n
Cmdoloy}{c}h{Bck Oly}{qi}h{
Dal}h{
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
6/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 6
3,1IHDUCL_ KQYOLAYY HUA[C]OHLYJO@J BAVAB HVA[VOAP
Oluq}
[ai{qo}dal} hf sqcbofoam y}qmal}y fh{ fciqb} u{h`{cdy, [aih{mol` y}qmal} mc}c yqij cy }jao{ ua{yhllab olfh{dc}ohl clm naauol` }{cin hf
mc}c ya}y yqij cy }jao{ ucdal} ma}coby" azcd dc{ny clm c}}almclia,
[aih{mol` h}ja{ ihducl {abc}am mc}c yqij cy olfh{dc}ohl ckhq} uq{ijcyay" ycbc{ma}cob clm aval}y,
Hua{c}ohly
Ihlmqiol` hf bai}q{ay {abc}am }h }ja foabm hf ijadoy}{,
Dc{nol` c}}almclia iq{{al}b dclqcbb jcy hu}am fh{ cl cq}hdc}am c}}almclia}{cinol` kc{ihma yy}ad }h ka odubadal}am,
U{auc{ol` affai}ova }oda }ckba yijamqbay fh{ }ja oly}o}q}a bai}q{a{y, Dhmqba avcbqc}ohl ol }a{dy hf }ja ihq{ya y}{qi}q{a clm o}y ihl}al}y, Avcbqc}ohl mhla
k }ph i{o}a{oc" p{o}}al azcdy clm u{ci}oicby, *O} oy }h ka lh}am }jc} }ja uclab hf
bai}q{a{y ol }ja oly}o}q}a maioma }ja pao`j}am ua{ial}c`ay hf p{o}}al clm u{ci}oicb
azcd dc{ny fh{ acij dhmqba }jc} }ja y}qmal}y qlma{}cnay,/ Bai}q{ay c{a ihlmqi}am ol moffa{al} fciqb}oay, ]jaya fciqb}oay acij jcva hla ihq{ya
u{h`{cd *Az$ Clcb}oicb Ijadoy}{ Y}{acd" Abai}{h Ijadoy}{ Y}{acd" H{`cloi
Ijadoy}{ Y}{acd A}i,/
Acij y}qm y}{acd pobb jcva moffa{al} dhmqbay }jc} pobb ka }cq`j} bai}q{a{y, Bai}q{a{y `a} com f{hd bck oly}{qi}h{y fh{ u{ci}oicby" clm y}qmal}y jcva ihduq}a{
bck fciobo}oay }h mh }ja{a cyyo`ldal}y clm clcb}oicb fqli}ohly ,La}ph{n
cmdoloy}{c}h{y c{a u{ayal} ol }ja ihduq}a{ bcky,
Y}qmal} ic{{oa{ `qomclia u{h`{cd mhla }j{hq`j cl cuuhol}am dal}h{ *}joy oyhu}ohlcb fh{ y}qmal}y/ pjoij pobb jabu }ja y}qmal}y ol fo`q{ol` hq} }jao{ uc}jy ol }ja
foabm hf ijadoy}{,
Hq}uq}y
Ia{}ofoic}ay }h yjhp y}qmal} u{h`{ayyohl" cllqcb cpc{my c{a `oval,
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
7/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 0
;,5 ]JA KQYOLAYY ICYA FH[ MC]CKCYA MAYO@L
;,3IQ[[AL] U[HIAYYAY CLM Y_Y]ADY QYAM
]ja oly}o}q}a cb{acm jcy c ihduq}a{owam yy}ad clm c mc}ckcya kcinalm fh{ o}y uc{hbb
clm bok{c{ dclc`adal} fqli}ohly, ]ja ciihql}ol` mauc{}dal} clm }ja bok{c{ocly
{ayuai}ovab c{a }ja u{hiayy hpla{y fh{ }ja cfh{adal}ohlam yy}ady, Kh}j }ja yy}ad
{qly olmaualmal}b hf acij h}ja{,
]ja y}qmal} al{hbdal} oy mhla ol c }{cmo}ohlcb pc *}h}cbb ucua{ kcyam/, ]ja ihq{ya
ihh{molc}h{ hf }ja oly}o}q}a jclmbay cbb olsqo{ay {abc}am }h u{hyuai}y clm yabai}y }jasqcbofoam y}qmal}y clm al{hbby }jad }h }ja oly}o}q}a, Moffa{al} {a`oy}{oay c{a nau} fh{
moffa{al} fciqb}oay, Cbyh moffa{al} kc}ijay c{a nau} ol moffa{al} {a`oy}{ khhny, Lh u{hua{
{aih{my c{a nau} hl moffa{al} dhmqbay, Pjalava{ c laam fh{ c dhmqba mayi{ou}ohl c{oyay
}ja ihq{ya ihh{molc}h{ clm yqkgai} yuaiocb} bai}q{a{ moyiqyyay }ja dhmqba ihl}al}y
*azcdolc}ohl i{o}a{oc" lqdka{ hf i{amo}y" ucyy dc{ny/ clm uqkboyjay }jad hl oly}o}q}a
ghq{lcby( k{hijq{ay clm uqkboic}ohly,
Y}qmal}y qyc`a hf ihduq}a{y ol bcky clm azua{odal} mayny ol bckh{c}h{oay oy mhla
po}jhq} cl yaloh{ dadka{ yqua{voyohl, Cl vcicl} azua{odal} mayn cvcobckba pobb ka
qyam, ]ja{a oy lh hu}ohl hf u{a khhnol` cyya}y fh{ yijamqbam qya fh{ cl u{ci}oicb,
]joy oy }ja icya fh{ bai}q{a jcbb khhnol` cy pabb, ]ja iq{{al} u{hiayy mhay lh} cbbhp
bai}q{a{y }h voap cvcobckba bckh{c}h{ {hhdy h{ bai}q{a jcbby }h ihlmqi} bai}q{a yayyohly
h{ u{ci}oicb yayyohly, ]ja u{hiayy iq{{al}b oy ihduba}am k ihddqloic}ohl ka}paal
bai}q{a{ clm ihq{ya ihh{molc}h{ va{kcbb,
Y}qmal} c}}almclia {aih{my c{a lh} nau}, ]ja{a oy iq{{al}b lh u{hiayy fh{ dc{nol` clm
y}h{ol` y}qmal} c}}almclia }h bai}q{a yayyohly h{ u{ci}oicb yayyohly,
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
8/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl :
;,;C[ACY HF ODU[HVADAL]
Ciih{mol` }h }ja ol}a{voap ihlmqi}am" }jhq`j }ja ihducly ac{b ol}cna jcy kaal
oli{acyol` ac{b *dcolb kaicqya }ja mova{yohl hf ol}a{ay} po}jol bhicb y}qmal}y f{hd
kqyolayy clm O] y}qm y}{acdy }h yioalia y}{acdy mqa }h iq{{al} ghk dc{na} }{almy/
}ja{a jcy lh} kaal c dclc`adal} olo}oc}ova }h olvay} ol c ihduq}a{owam y}qmal}
dclc`adal} yy}ad, ]ja{afh{a }ja oly}o}q}a hua{c}ohly jcva kaal jcvol` }ja fhbbhpol`
pacnlayyay(hua{c}ohlcb ol$affoioalioay fh{ yhda ua{ohm,
3, O}y }ja y}clmc{m lh{d }h jcva ihduq}a{owam yy}ady }h naau }cin clm {aih{mcl oly}o}q}ay al{hbdal} clm cyyayydal} m{oval kqyolayy }{clyci}ohly, Kq} }ja
u{ayalia hf c dclqcb *p{o}}al {a`oy}{oay/ po}jol }ja oly}o}q}a jcva dcma }ja
yac{ijol` clm {a}{oavcb hf mc}c k ihq{ya ihh{molc}h{y *clm yhda}oday
bai}q{a{y/ va{ }oda ihlyqdol` clm ol$affoioal},
;, Y}qmoay jcva yjhpl }jc} }ja c}}almclia hf y}qmal}y }h bai}q{ay jcy cl oduci}hl }jao{ hva{cbb ua{fh{dclia clm }jao{ folcb {ayqb}y, Iq{{al}b }ja oly}o}q}a
mhay lh} naau }{cin hf y}qmal} c}}almclia, Pjal bhhnol` c} h}ja{ oly}o}q}ay
yqij cy Qlova{yo} hf Nabcloc c}}almclia oy dc{nam fh{ bai}q{a yayyohly cy
pabb cy bckh{c}h{ yayyohly pjoij c{a cl ayyal}ocb uc{} hf y}qmal}y bac{lol`,
9, ]ja yqddc{owam {auh{}y *{auh{}y {abc}am }h al{hbdal}y ua{ ac{" f{hd pjoijmoy}{oi}" pjoij c`a `{hqu" Y}qmal} ua{fh{dclia" bai}q{a{ ua{fh{dclia/ }jc}
}ja ihducl }hu dclc`adal} {aiaovay c{a ucua{ kcyam, ]ja cdhql} hf }oda
}jc} oy ihlyqdam }h }{clyfa{{ol` }ja i{o}oicb olfh{dc}ohl }h }ja olfbqal}ocb
uc{}oay ol }ja oly}o}q}a jcy dcma }ja hva{cbb h{`clowc}ohlcb maioyohl dcnol`
u{hiayy olaffoioal},
=, [hhd khhnol` fh{ bai}q{a{y clm cyya} khhnol`y *Ihduq}a{y clm bckh{c}h{azua{odal} mayny/ fh{ y}qmal}y icl ka cq}hdc}am clm dcma dh{a affoioal},
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
9/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl ?
;,9I[O]OICB YQIIAYY FCI]H[Y
$ I{ac}a hua{c}ohlcb affoioalioay po}jol }ja oly}o}q}a }h ic}a{ }h }ja `{hpol`y}qmal} ol}cna madclmy, ]ja ihduq}a{owam yy}ady clm o}y mc}ckcyay yjhqbm ka
ckba }h yquuh{} }ja kqyolayy u{hiayy pjal cijoavol` }joy,
$ Dcol}col y}qmal} ua{fh{dclia }h }ja jo`jay} y}clmc{my k yquuh{}ol` }jad"u{hvomol` }jad dh{a ihl}{hb hva{ oly}o}q}a cyya}y ol c ihl}{hbbam dclla{,
$ ]joy pobb olcmva{}al}b i{ac}a c `ala{cb ihlioya }jc} }joy oly}o}q}a oy dcol}colol`ol}a{lc}ohlcb y}clmc{my cdhl`y} ol}a{lcb clm az}a{lcb y}qmal} ihddqlo}oay, ]joy
oy oduh{}cl} pjal ihdua}ol` po}j yaihlmc{ ihdua}o}h{y yqij cy O] clm
kqyolayy ma`{aa hffa{ol` oly}o}q}ay yqij cy CUOO]" CLI clm CIK],
;,=YIHUA HF ]JA MAYO@LAM MC]CKCYA
]joy u{huhyam mc}ckcya pobb jcva 1 dhmqbay, ]ja c{a
3, Y}qmal} Al{hbdal}y Dhmqba;, Azcdy clm @{cmol` Dhmqba9, [hhd Khhnol` Dhmqba=, Cyya} Khhnol` Dhmqba1, Y}qmal} C}}almclia Dhmqba
Acij hf }ja ckhva dal}ohlam dhmqbay pobb ihva{ }jhya {ayuai}ova c{acy qlma{ o}y
hua{c}ohl, *Ma}cobam AA[ moc`{cdy {au{ayal}ol` }ja mc}c fbhpy clm al}o}oay oy `oval ol
ijcu}a{ 1/ ]ja mc}ckcya dhmab jhpava{ pobb lh} y}h{a cl mc}c {abc}am }h uc{hbb
fqli}ohly h{ bok{c{ fqli}ohly yolia }jc} oy iq{{al}b dclc`am }j{hq`j c yauc{c}a
yy}ad clm c yauc{c}ab kqob} mc}ckcya,
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
10/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 35
;,1IHLYASQALIAY HF LHL CMHU]OHL
$ Jqdcl a{{h{ icl icqya ol affai}ova kqyolayy }{clyci}ohly clm dc ol avomal}bbacm }h adubhaa(y}qmal} moyyc}oyfci}ohl, Ol yava{a icyay do`j} aval mcdc`a }ja
oly}o}q}a uhuqbc{o} clm ciiau}clia cy c ihdua}al} cicmadoi oly}o}q}a,
$ ]ja lhl azoy}alia hf ijainol` cvcobckba cyya}y h{ {hhdy pobb dacl bhl`a{ihddqloic}ohl iiba ka}paal bai}q{a{y" y}qmal}y clm ihq{ya ihh{molc}h{y pjoij
pobb bacm }h hua{c}ohlcb olaffoicioay,
$ Lh cyya} }c``ol` hf UI h{ azua{odal} mayny, Y}hbal o}ady icllh} ka }{cinam,$ Po}jhq} u{hua{ ihduq}a{ bcky clm ijadoy}{ bck bai}q{a yayyohl dclc`adal}
yhda ybh}y dc kaihda hva{bhcmam,
;,6CMVCL]C@AY PO]J ]JA LAP MC]CKCYA MAYO@L
$ Ma}a{y }ja doyqya hf ihduq}a{ bcky clm ijadoy}{ bcky kaicqya ciihql} c{a nau}hf }ja y}qmal}y }jc} qyam }jad clm }ja h}ja{ ma}coby yqij cy mq{c}ohl clm }oda
qyam
$ Cmmo}ohlcbb o} u{hdh}ay yabf y}qm olo}oc}ovay cdhl` y}qmal}y *]ja icl qyabok{c{ cyya}y clm ihduq}a{ {ayhq{iay cvcobckba pjalava{ }ja laam k u{a
khhnol`" yodobc{ }h bok{c{ khhn kh{{hpol`y/
$ Ihducl yaloh{ azaiq}ovay icl `a} }odab clm dh{a ciiq{c}a {aih{my hl y}qmal}ol}cnay" bai}q{a{ ua{fh{dclia clm kc}ij ua{fh{dclia, ]joy oy kaicqya lhp }ja
u{hiayy oy cq}hdc}am clm }ja mc}c oy nau} ol c {abc}ohlcb mc}ckcya icuckba hf
{a}{oavcb,
$ Dcnay }ja ph{n hf ihq{ya ihh{molc}h{y dqij acyoa{" }joy phqbm dacl c yaiq{ay}h{a fh{ mc}c *{c}ja{ }jcl }ja iq{{al} dclqcbb nau} {aih{my/ clm c fcy}a{ dh{a
ciiq{c}a pcy hf {a}{oavol` }jad }j{hq`j }ja }h$ka$kqob} yhf}pc{a,
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
11/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 33
9,5 FCI] FOLMOL@ DA]JHMHBH@_
]ja ijhyal fci} folmol` }aijlosqa pcy ol}a{voapol` }ja na y}cnajhbma{y ol }ja
oly}o}q}a,
Fo{y} Ol}a{voap
Ol}a{voapaa$ Yaloh{ Bai}q{a{
Mc}a$;535(5=(51" Dhlmc
*Ujhla Ol}a{voap/
]oda $35,95 c,d
Yqddc{ $]joy pcy mhla c} }ja olo}oc}ohl ujcya hf }ja u{hgai} }h `a} cl hva{cbb
ihducl voap f{hd c dclc`a{y ua{yuai}ova clm }h `a} }h nlhp }ja yihua hf }ja
u{hkbady fhqlm, ]ja olfh{dc}ohl moyiqyyam ol 3y}
clm ;lm
ijcu}a{y pcy mhiqdal}am
}j{hq`j }ja folmol`y ol }joy ol}a{voap, Clm cbyh cl hva{cbb omac hl }ja kqyolayy
}{clyci}ohly }jc} }ja oly}o}q}a qyay pcy omal}ofoam,
Yaihlm Ol}a{voap
Ol}a{voapaa$ Ihq{ya Ihh{molc}h{
Mc}a$;535(5=(51" Dhlmc
*Ujhla Ol}a{voap/
]oda $;,95 u,d
Yqddc{ $]h omal}of }ja ih{a u{hiayyay ol }ja oly}o}q}a clm qlma{y}clm jhp o} oy
kaol` ic{{oam hq}, ]ja y}qmal} al{hbdal} u{hiayy" jhp }ja cyyayydal}y c{a dc{nam8
Jhp c{a }ja y}qmal} olfh{dc}ohl nau}8 pa{a fhqlm hq} f{hd }joy ol}a{voap ,]ja
olfh{dc}ohl fhqlm f{hd }joy ol}a{voap oy mhiqdal}am oy {afbai}am hl }ja AA[ moc`{cdy
ol ijcu}a{ 1, ]ja ih{a u{hiayyay olvhbvam clm }ja moffoiqb}oay fciam pjal ihddo}}ol` }h
c fqbb dclqcb }{clyci}ohl dclc`adal} yy}ad pcy omal}ofoam f{hd }joy ol}a{voap,
F{hd }joy ujcya hf }ja u{hgai} }ja {asqo{adal}y fh{ }ja mc}ckcya pcy omal}ofoam, ]joy
bacm }h }ja fh{dc}ohl hf }ja fqli}ohlcb {asqo{adal}y fh{ }ja mc}ckcya
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
12/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 3;
=,5 FQLI]OHLCB [ASQO[ADAL]Y HF ]JA MC]CKCYA
]ja mc}ckcya yjhqbm ka ckba }h yquuh{} }ja fhbbhpol` fqli}ohly,
Alckbol` }ja y}h{c`a hf mc}c {a`c{mol` y}qmal} c}}almclia }h u{ci}oicb yayyohly cy
pabb cy bai}q{a yayyohly,
Cq}hdc}ohl hf }ja u{hiayy hf y}qmal} al{hbdal} cbbhpol` fh{ }ja y}qmal}yua{yhllab mc}c }h nau} ol cl affoioal}b {a}{oavckba dclla{,
Y}qmal} azcd dc{ny jcy }h ka y}h{am ol }ja mc}ckcya, Azcd Yqua{voyh{y jcy }h ka ckba }h u{hvoma faamkcin }h bai}q{a{y, Y}qmal}y yjhqbm ka ckba }h bhm`a {asqay} fh{ azcd dc{n {aijainy, Ciihql} dclc`adal} hf y}qmal}y }jc} jcy dcma khhnol`y ol ijadoy}{ bcky clm
ihduq}a{ bcky,
Ihq{ya ihh{molc}h{y jcva }h ckba }h i{ac}a }oda }ckbay fh{ bai}q{ay clm azcdy, Bck azua{odal} mayn clm ihduq}a{ khhnol` fqli}ohl fh{ y}qmal}y clm {hhd
khhnol` fqli}ohl fh{ ihq{ya ihh{molc}h{y,
Voap khhnol` yijamqba fh{ bai}q{a{y,
Qya{y hf }ja yy}ad pobb ka"
3, Y}qmal} Al{hbdal}y Dhmqba *Y}qmal}" Ihq{ya ihh{molc}h{/;, Azcdy clm @{cmol` Dhmqba *Y}qmal}" Bai}q{a{" Azcd Yqua{voyh{" Ihq{ya
ihh{molc}h{/9, [hhd Khhnol` Dhmqba *Bai}q{a{" Azcd Yqua{voyh{" Ihq{ya ihh{molc}h{/=, Cyya} Khhnol` Dhmqba *Y}qmal}/1, Y}qmal} C}}almclia Dhmqba *Y}qmal} voc c}}almclia }{cinol` yy}ad/
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
13/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 39
1,5 AZ]ALMAM AL]O]_ [ABC]OHLYJOU MOC@[CDY
AA[M Dhmqba 3 $ Y}qmal} Al{hbdal}
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
14/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 3=
Bh`oicb [acyhlol`
Y}qmal} {abc}am yhda c}}{okq}ay }jc} {asqo{a bal`}j mc}c y}h{a {asqo{adal}y jcva
}h ka nau} cy mc}c }ua y}{ol`, C dqb}o vcbqam c}}{okq}a pcy lh} ubciam kaicqya
o} pobb i{ac}a qllaiayyc{ cmmo}ohlcb }ckbay
Y}qmal} dal}h{ol` oy cl hu}ohlcb ya{voia fh{ c y}qmal}, Jalia uc{}ocb
maualmali
]ja{a oy hlb hla ihq{ya ihh{molc}h{ jcvol` cmdoloy}{c}ova {o`j}y }h qumc}a }ja
}oda }ckbay,
Hla fciqb} ihl}coly c yai}ohl hf dhmqbay, ]jaya dhmqbay c{a c y}qm y}{acd fh{
c y}qmal},
Bai}q{a{ ma}a{dolay }ja p{o}}al clm u{ci}oicb ua{ial}c`ay fh{ }ja dhmqbay,
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
15/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 31
AA[M Dhmqba ;Y}qmal} Azcdy clm @{cmol`
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
16/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 36
Bh`oicb [acyhlol`
Dc{ny al}o} oy ic}a`h{oay cy c pacn al}o} kaicqya po}jhq} }ja dhmqba o} {abc}ay
mh lh} azoy} cbb }ja dc{ny c{a lh bhl`a{ laamam }h ka nau} hf o}, ]joy pacn al}o}
jhpava{ jcy c {abc}ohlyjou po}j bai}q{a{ cy pabb,
Ihq{ya ihh{molc}h{ laamy }h vcbomc}a }ja {aijain yqkdo} {asqay} f{hd y}qmal}
kafh{a o} oy yal} }h }ja bai}q{a{y }h cvhom qllaiayyc{ {asqay}, Yqij mc}c jcy }h
ka y}h{am yauc{c}ab,
]ja lqdka{ hf }oda c dhmqba azcd jcy kaal {aijainam cbyh laamy }h ka y}h{am
jalia o}y u{ayal}am cy cl c}}{okq}a hl }ja {abc}ohl,
]ja azcd yqua{voyh{y c{a lh} bai}q{a{y yh }ja jcva }h ka y}h{am yauc{c}ab, ]ja
`ova }jao{ faamkcin hl y}qmal} ua{fh{dclia hl }ja azcd*yqij cy ubc`oc{oyd
hffaliay/ }jc} oy laamam fh{ bai}q{a{ }h ua{fh{d ualcbowc}ohly hl azcd dc{ny,
]joy faamkcin oy y}h{am yauc{c}ab fh{ bc}a{ qya *ol hiicyohly yqij cy y}qmal}
avcbqc}ohly/
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
17/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 30
AA[M Dhmqba 9[hhd Khhnol`y
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
18/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 3:
Bh`oicb [acyhlol`
]ja al}o}oay po}jol {hhd khhnol` cbyh laam }h ka qlosqab omal}ofoam k o}y hpl
OM, Jalia }ja {abc}ohlyjou oy Q oly}acm hf c lh{dcb moyghol}, Yq{{h`c}a nay
pobb ka ol qya,*Bc}a{ mauoi}am ol {abc}ohlcb yijadc/
Qumc}ay {abc}ay }h }ja qya{y dcnol` khhnol`y clm qumc}ol` }ja ma}coby hf o},
Hlb hla la}ph{n cmdoloy}{c}h{ clm hla bck oly}{qi}h{ oy `oval ciiayy u{ovoba`ay
fh{ dcnol` khhnol`y,
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
19/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 3?
AA[M Dhmqba =Cyya} Khhnol`y
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
20/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl ;5
Bh`oicb [acyhlol`
]odaybh} oy c dqb}o vcbqam c}}{okq}a kaicqya moffa{al} }odaybh} mc}c jcy }h ka
y}h{am fh{ ava{ khhnol` }jc} oy dcma, ]ja mc}c hl }joy c}}{okq}a pobb ka
{au{ayal}am ol c yauc{c}a {abc}ohl ol }ja {abc}ohlcb yijadc,
Dcl bck oly}{qi}h{y c{a ph{nol` ol hla bck, Kq} fh{ hla ihduq}a{ bck hlb hla
la}ph{n cmdoloy}{c}h{ oy u{ayal},
]ja }ay} bcky c{a fh{ y}qmal}y {ayac{ij ph{n, Clm mc}c {abc}am }h }jc} jcy }h ka
y}h{am yauc{c}ab,
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
21/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl ;3
AA[M Dhmqba 1Y}qmal} C}}almclia
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
22/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl ;;
Bh`oicb [acyhlol`
C}}almclia jcy }h ka naau }{cin hf fh{ kh}j bai}q{a yayyohl cy pabb cy u{ci}oicb
yayyohl" jalia }ph yauc{c}a al}o}oay, Acij al}o} jcy }h ka qlosqab omal}ofoam
f{hd acij h}ja{ oly}acm hl gholol` }jad cy c yayyohl al}o}, *Of }joy pcy mhla c
ihddhl u{odc{ na jcy }h ka qyam }h omal}of kh}j bck clm bai}q{a yayyohly/
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
23/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl ;9
6,5 AA[MDHMQBAY CF]A[ OL]A@[C]OHL
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
24/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl ;=
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
25/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl ;1
0,5 ]JA BH@OICB DHMAB
]joy ijcu}a{ pobb ma}cob }ja ihlva{yohl {ayqb}y hf }ja ckhva dal}ohlam A[My ol}h o}y
{abc}ohlcb yijadcy,
3, Y}qmal} Al{hbdal} Dhmqba
c, Y}qmal}*Y}mOM" Fo{y}Lcda" Bcy}Lcda" Y}mAdcob"Y}mCmm{ayy" Y}mUjhla" Y}mSqcbofoic}ohl" Kc}ijOM/
k, Dal}h{*Dal}h{OM" Dal}h{Lcda" Dal}h{Adcob"Dal}h{Ujhla/
i, Y}qmal}XDal}h{*Y}mOM" Dal}h{OM/m, Kc}ij*Kc}ijOM" _ac{" LhY}qmal}y" Mayi{ou}ohl"
Fciqb}OM" ]oda]ckbaOM/
a, Fciqb}*Fciqb}OM" Fciqb}Lcda " Mayi{ou}ohl" FciXY}qmal}y/f, ]odaX]ckba*]oda]ckbaOM" Mc}a" ]oda" Lh}ay" IhXIh{molc}h{OM/`, Ihq{yaXIh{molc}h{*IhXIh{molc}h{OM" IhXIh{molc}h{Lcda"
IhXIh{molc}h{Adcob" IhXIh{molc}h{Ujhla /
j,
Dhmqba*DhmqbaOM" DhmqbaLcda" BaiUa{ial}c`a" U{ciUa{ial}c`a"DhmXMayi{ou}ohl" Fciqb}OM" ]oda]ckbaOM/
o, Bai}q{a{*BaiOM" BaiLcda" BaiUjhla" BaiAdcob" BaiCmm{ayy"BaiSqcbofoic}ohl/
;, Azcd & Dc{ny Dhmqba
c, Y}qmal}*Y}mOM" Fo{y}Lcda" Bcy}Lcda" Y}mAdcob" Y}mCmm{ayy" Y}mUjhla"Y}mSqcbofoic}ohl/
k, Dhmqba*DhmqbaOM" DhmqbaLcda" BaiUa{ial}c`a" U{ciUa{ial}c`a"DhmXMayi{ou}ohl"Dc{namK" Hva{yaalK/
^ Dc{namK fh{ao`l na foabm oy }ja u{odc{ na BaiOM hf }jaBai}q{a{ al}o}, O} jcy kaal {alcdam ja{a }h odu{hvaqlma{y}clmckobo} clm {acmckobo}T^ Hva{yaalK fh{ao`l na foabm oy }ja u{odc{ na Yqua{voyh{OM hf}ja AzcdYqua{voyh{ al}o}, O} jcy kaal {alcdam ja{a }h odu{hvaqlma{y}clmckobo} clm {acmckobo}T
i, DhmqbayX]cnal*Y}mOM" DhmqbaOM" C}}adu}Lh/
Ba`alm7
U{odc{Na
Fh{ao`lNa
Yq{{h`c}aNa
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
26/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl ;6
m, Bai}q{a{*BaiOM" BaiLcda" BaiUjhla" BaiAdcob" BaiCmm{ayy"BaiSqcbofoic}ohl/
a, AzcdYqua{voyh{*Yqua{voyh{OM" YquLcda" YquAdcob" YquCmm{ayy"YquUjhla/
f, Dc{ny*DhmqbaOM" Dc{nyOM" P{o}}alAzDc{ny" U{ciDc{ny" Y}mOM" BaiOM/`, Faamkcin@oval*Yqua{voyh{OM" BaiOM" Faamkcin/j, Ihq{yaXIh{molc}h{*IhXIh{molc}h{OM" IhXIh{molc}h{Lcda"
IhXIh{molc}h{Adcob" IhXIh{molc}h{Ujhla /
o, Azcd]oda]ckba*Az]oda]kOM" DhmqbaLcda" Mc}a" Y}c{}]oda" Alm]oda"IhXIh{molc}h{OM/
g, BaiX[afa{XAz]d]ckba*BaiOM" Az]oda]kOM/n, Cpc{m*Cpc{mOM" Cpc{mLcda" _ac{" Qumc}amK" Y}mOM/
^Qumc}amK fh{ao`l na foabm oy }ja u{odc{ na IhXIh{molc}h{OMhf }ja Ihq{yaXIh{molc}h{ al}o}, O} jcy kaal {alcdam ja{a }hodu{hva qlma{y}clmckobo} clm {acmckobo}T
b, [aijainCuuboic}ohl*[aijainOM" Lh}ay" Y}mOM" [afa{{amK/^[afa{{amK fh{ao`l na foabm oy }ja u{odc{ na IhXIh{molc}h{OMhf }ja Ihq{yaXIh{molc}h{ al}o}, O} jcy kaal {alcdam ja{a }hodu{hva qlma{y}clmckobo} clm {acmckobo}T
d, UcyyX[aijainX[asqay}*IhXIh{molc}h{OM" BaiOM" [aijainOM/9, [hhd Khhnol` Dhmqba
c, Bai}q{a{*BaiOM" BaiLcda" BaiUjhla" BaiAdcob" BaiCmm{ayy"BaiSqcbofoic}ohl/
k, [hhdXKhhnol`*KhhnOM" Mc}a" Y}c{}X]oda" AlmX]oda" LhHfUc{}oioucl}y"Lh}ay/
i,
Bai}q{aXJcbb*BJcbbOM" Uq{uhya" [asqay}Xk" KhhnOM" Qumc}amK/
^Qumc}amK fh{ao`l na foabm oy }ja u{odc{ na IhXIh{molc}h{OMhf }ja La}ph{nCmdoloy}{c}h{ al}o}, O}y jcy kaal {alcdam ja{a }hodu{hva qlma{y}clmckobo} clm {acmckobo}T
m, Ihduq}a{XBck*IhdBckOM" Lqdka{HfUIy " IhdU{ci}oicbXOlfh" KhhnOM"Qumc}amK/
^Qumc}amK fh{ao`l nafoabm oy }ja u{odc{ na La}CmdolOM hf }jaIhq{yaXIh{molc}h{ al}o}, O}y jcy kaal {alcdam ja{a }h odu{hvaqlma{y}clmckobo} clm {acmckobo}T
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
27/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl ;0
a, Ijadoy}{XBck*IjadBckOM" Lqdka{HfMayny " Lqdka{HfOly}{"IjadU{ci}oicbXOlfh" KhhnOM"Qumc}amK/
^Qumc}amK fh{ao`l na foabm oy }ja u{odc{ na BckOlyOM hf }ja
BckOly}{qi}h{ al}o}, O}y jcy kaal {alcdam ja{a }h odu{hvaqlma{y}clmckobo} clm {acmckobo}T
f, Bai}q{a{X[hhdKhhnol`*BaiOM" KhhnOM/`, Ihq{yaXIh{molc}h{*IhXIh{molc}h{OM" IhXIh{molc}h{Lcda"
IhXIh{molc}h{Adcob" IhXIh{molc}h{Ujhla /
j, La}ph{nCmdoloy}{c}h{*La}CmdolOM" La}CmdolLcda" La}CmdolCmm{ayy"La}CmdolAdcob" La}CmdolUjhla /
o, BckOly}{qi}h{*BckOlyOM" BckOlyLcda" BckOlyAdcob" BckOlyCmm{ayy"BckOlyUjhla/
=, Cyya} Khhnol` Dhmqba
c, ]ay}XBck*BckOM" Bck]ua" BckYowa" BckBhic}ohl/k, Ihduq}a{XBck*IhdBckOM" Lqdka{HfUIy" IhdU{ci}oicbXOlfh" BckOM/i, Ijadoy}{XBck*IjadBckOM" Lqdka{HfMayny" IjadU{ci}oicbXOlfh"
Lqdka{HfOly}{" BckOM/
m, La}ph{nCmdoloy}{c}h{*La}CmdolOM" La}CmdolLcda" La}CmdolCmm{ayy"La}CmdolAdcob" La}CmdolUjhla /
a, BckOly}{qi}h{*BckOlyOM" BckOlyLcda" BckOlyAdcob" BckOlyCmm{ayy"BckOlyUjhla/
f, IhdBckXDclc`a*IhdBckOM" La}CmdolOM" Mc}aHfCyyo`ldal}/`, BckOlyXPh{nyol*IjadBckOM" BckOlyOm" Mc}aHfCyyo`ldal}/j, Khhnol`Yijamqba*YijamqbaOM" Yijamqba]ua" Mc}a" BckOM/o, Yayyohl*YayyohlOM" YijamqbaOM/g, ]odaYbh}*YayyohlOM" ]odaYbh}/n, Y}mXYayX[ayXKhhnol`*Y}mOM" [ayhq{iaOM" YayyohlOM/b, Y}qmal}*Y}mOM" Fo{y}Lcda" Bcy}Lcda" Y}mAdcob" Y}mCmm{ayy" Y}mUjhla"
Y}mSqcbofoic}ohl/
d, [ayhq{ia*[ayhq{iaOM" [ayhq{ia]ua" [ayhq{iaBhic}ohl" BckOM/l, Ihduq}a{*DcijolaOM" K{clm" Yuaam" Jc{mMoyn" Dadh{" [ayhq{iaOM/h, Azua{odal}XMayn*MaynOM" MaynYowa" [ayhq{iaOM/
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
28/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl ;:
1, Y}qmal} C}}almclia Dhmqba
c, Y}qmal}*Y}mOM" Fo{y}Lcda" Bcy}Lcda" Y}mAdcob" Y}mCmm{ayy" Y}mUjhla"Y}mSqcbofoic}ohl/
k, Bai}q{aYayyohl*BaiYayXOM" BaiYayX]o}ba/i, BaiYayXC}}almclia*Y}mOM" BaiYayXOM" C}}almXMc}a/m, U{ci}oicbYayyohl*U{ciXOM" U{ciX]o}ba/a, U{ciYayXC}}almclia*Y}mOM" U{ciXOM" Uc{XMc}a /f, Dhmqba*DhmqbaOM" DhmqbaLcda" BaiUa{ial}c`a" U{ciUa{ial}c`a"
DhmXMayi{ou}ohl/
`, BaiYayXU{ciYayXDhmqba*BaiYayXOM" U{ciXOM" DhmqbaOM/
:,5 ]JA UJ_YOICB DHMAB
Lh{dcbowc}ohl U{hiayy
]ja Lh{dcbowc}ohl u{hiayy pcy fhbbhpam }h fq{}ja{ {afola }ja {abc}ohly }jc} pa{a
ma{ovam k dcuuol` }ja al}o}oay clm {abc}ohlyjouy ol AA[ moc`{cdy ol}h {abc}ohly, ]ja
{abc}ohly pa{a ihlyoma{am qu }h 9LF *9{m
Lh{dcb Fh{d/,
3LF *Fo{y} Lh{dcb Fh{d/Cbb {abc}ohly pa{a ijainam fh{ ihduhyo}a c}}{okq}ay" dqb}o$vcbqam
c}}{okq}ay clm lay}am {abc}ohly ol h{ma{ }h ka }ja {abc}ohly ol 3LF, Cbb
azoy}ol` {abc}ohly pa{a ol ua{fai} 3LF,
;LF *Yaihlm Lh{dcb Fh{d/]ja {abc}ohly pa{a ucyyam }j{hq`j }ja yaihlm y}au hf }ja lh{dcbowc}ohl
u{hiayy pjoij bhhnam fh{ lhl$fqli}ohlcb maualmalioay cdhl` }ja
u{odc{ na clm h}ja{ c}}{okq}ay hf }ja {abc}ohly, Cbb azoy}ol` {abc}ohly
pa{a ol ;LF,
9LF *]jo{m Lh{dcb Fh{d/]ja 9
{my}au ol }ja lh{dcbowc}ohl u{hiayy `qc{cl}aam }jc} lh lhl$u{oda
c}}{okq}a hf c {abc}ohl oy }{clyo}ovab maualmal} hl }ja u{odc{ na, ]joy
cbyh pcy ihlyoy}al} po}j 9LF,
Laz} uc`a ma}coby }ja ujyoicb dhmaby hf }ja omal}ofoam {abc}ohlcb yijadcy,
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
29/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl ;?
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
30/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 95
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
31/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 93
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
32/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
Mc}ckcya Mayo`l fh{ Oly}o}q}a hf Ijadoy}{ Iabhl 9;
-
8/2/2019 Database Design for Institute of Chemistry Ceylon
33/33
Fciqb} hf @{cmqc}a Y}qmoay" Qlova{yo} hf Ihbhdkh
?,5 IHLIBQYOHL
]ja u{huhyam mc}ckcya mayo`l oy dcolb }c{`a}am c} comol` }ja oly}o}q}a ol yquuh{}ol` o}
mcob }{clyci}ohly, ]ja mc}ckcya pobb ci} cy c yol`ba uhol} hf y}h{c`a fh{ oly}o}q}ayayyal}ocb mc}c" o}y dcol jqk, ]ja mayo`l y}c`ay hf }ja u{hgai} pa{a }ja dhy} ihdubaz ol
}joy u{hgai} mqa }h }ja fci} acij dhmqba pcy mhla k yauc{c}a mayo`la{y, Olo}ocbb
yava{cb `qomabolay clm y}clmc{my pa{a c`{aam quhl *Az$lcdol` ihlval}ohly/ }h cvhom
ihlfqyohl pjal A[ voapy c{a ol}a`{c}am,
]ja pjhba u{hgai} pcy mhla jcvol` }ja 9LF mc}ckcya dhmab ol dolm aval f{hd }ja
olo}ocb y}c`ay, ]joy ycvam }ja }acd }oda kaicqya cq}hdc}oicbb }ja }ckbay pa{a ol o}y 9LF
fh{d,
CINLHPBAM@ADAL]Y
D `{hqu cuu{aioc}ay }ja `qomclia clm }q}h{ol` u{hvomam k }ja dhmqba bai}q{a{
D{, [qnyjcl Dclijclccna" pjh comam qy ol qlma{y}clmol` }ja kcyoi ihliau}y hf
mc}ckcya dhmabol` clm jhp o} ihqbm ka voapam f{hd c dclc`a{ kqyolayy ua{yuai}ova,
]ja u{ci}oicb cuu{hcij yjhpl k jod ol joy bai}q{ay k qyol` icya y}qmoay clm dcl ol$
ibcyy aza{ioyay comam qy ol qlma{y}clmol` }jaya ihliau}y ka}}a{,
]ja fhbbhpol` ihhua{c}a pak yo}a jcy kaal qyam ol }ja ihduobc}ohl hf }joy {ayac{ij clm
clcbyoy ucua{ " fq{}ja{ olfh{dc}ohl icl ka hk}colam f{hd o},
$ Oly}o}q}a hf Ijadoy}{ Iabhl *;535/, ^HlbolaT,j}}u7((ppp,oijadi,ihd(^Ciiayyam ;3}j Cu{ob ;535T
http://www.ichemc.com/http://www.ichemc.com/http://www.ichemc.com/http://www.ichemc.com/
top related