naeu tjyifu jyefvm&if; pD;u&ufukefawmhrSmrdkUvdkU 0,faeusqdkifrSm 0if0,fw,f/ vef'efwpfAl;udk 900 wJh/ raeUnu qdkifawGydwfukefvdkU wpfAl; wpfaxmifeJU pwdk;qdkifrSm 0,fcJh&wmudk trSwf&rdjyD; udk,f0,faeusqdkifu aps;oufom^aps;rSef ygovm;vdkU 0rf;omrdw,f/ 
Possible Answer
tvG,fqHk; ajym&&if Entity Integrity qdkwm NRC Number eJU wlw,f/
- NRC Data awGtwGuf xm;r,fh NRC Table rSm NRC Number awGu Unique jzpf&r,f/ Table wpfckwnf;rSm Same NRC Number eJU Row 2 ck r&Sd&bl;/
- NRC Number qdkwmudk Primary Key tjzpf toHk;jyK&r,f/
- NRC Number qdkwm Null vJrjzpf&bl;/
SQL rSm Not Null Unique qdkjyD; ajymMuw,f/ rsm;aomtm;jzifh tJ'D Column udk Primary Key tjzpfoHk;Muw,f/ Entity Integrity qdkwm Single Table xJrSm Duplicate Row awGr&Sdatmif Enforce vkyfay;wJh pepfudkqdkvdkwmjzpfw,f/
tcsKdUaom Table awGrSm Entity Integrity Enforce vkyfzdkUtwGuf Single Column eJU rvkHavmuf&if Multiple Column udk oHk;jyD; Combine Key taeeJU oHk;Muw,f/
Primary Key r&Sd&if bmjzpfrvJ vdkU tcsKdUtcsKdUawG ar;zl;Muw,f/ Table wpfckwnf;oHk;r,fhvltwGuf qdk&ifawmif Duplicate Row awG &SdvmzdkU Possibility awG&Sdvm&if Validation vkyfzdkU Code awG ydka&;&awmhr,f/ RDBMS udk ckdif;vdkuf&if Code a&;&oufomoGm;r,f/ Row awG rsm;vm&if Index vkyfay;vdkU&r,f/ Multiple Table awGeJU csdwfquftoHk;jyKr,fqdk&if ydkjyD;awmh vG,fuljrefqefvmr,f/ Single Table Database r[kwfbl;qdk&if Primary Key r&Sdwmu Exploit awG Duplication awGudk tvdktavsmuf umuG,fjyD;om;jzpfoGm;r,f/
Referencial Integrity qdkwmuawmh Foreign Key eJUygwfoufwJh Integrity yg/
( Parent & Child Tables ) rdbeJU om;orD;udk csdwfqufay;xm;wJh Link udk Enforce vkyfay;wmygyJ/ Oyrm Voucher Header & Voucher Detail Table 2 ckudk pOf;pm;Munfhr,fqdk&if
Voucher Number wpfckrSm Item awG wpfckxufru&SdvmEdkifw,f/ ( 1 Row in Parent Table related to >=1 Rows from Child Table ) It's representing One to Many Relationship in Data Model.
Link vkyfr,fh Field u Parent Table &JU Primary Key jzpf&r,f/ Child Table rSm olUudk,fydkif Primary Key &Sd&r,f/
Oyrm/ / Voucher No 1. rSm Item 10 ckyg&if tJ'D Item 10 ckpvHk;u Voucher No 1. eJUyJ oufqdkifw,fvdkU od&atmif Voucher Detail Table rSm Voucher Number udk Foreign Key taeeJU oHk;&w,f/ 'grS Voucher Detail Table xJu Row awG[m b,f Voucher eJU ygwfoufovJqdkwm od&r,f/
Referencial Integrity u tJ'D Link udk Enforce vkyfw,f/ tMurf;zsif;ajym&if Parent Table u Voucher No 1 qdkwJh Row udkzsufvdkuf&if Child Table u Voucher 1 eJUygwfoufwJh Row 10 cku t"dyg,frJhoGm;vdrfhr,f/
SQL rSm Referencial Integrity udk Enforce vkyfwJhenf; 3enf;&Sdw,f/
On Delete Restrict ~ txufyg udpö&yfvdkrsKd;rSm 'Denf;udk oHk;w,f/ Child Table rSm oufqdkif&m Row awG&Sdae&if Parent Table u Row udk zsufcGifhray;bl;/
On Delete Cascade ~ Parent Table u Row wpfckudk zsufvdkuf&if oufqdkif&m Child Table u Reference vkyfxm;orQ Row awG tm;vHk;udk Auto zsufay;w,f/ ( tcsKdUaom RDBMS awGu 'Dpepfudk Support rvkyfbl;vdkU zwfzl;w,f/ tJovdkjzpfae&if Parent Table u Row udk zsufwJhae&mrSm Before Delete ae&mrSm Trigger a&;jyD;awmh Child Rows in Child Table awGudk t&if zsuf&w,f/ )
On Delete Set Null ~ 'Denf;u tcsKdUaom Case awGtwGuf Developer udk vkyfydkifcGifh ay;xm;&HkoufoufygyJ/ Referencial Integrity udk tjynfht0 r&EdkifwJhtajctaeeJU Developer &JU udk,fydkif Design/System eJU Referencial Integrity udk xdef;csKyfr,fhtcsdefrsKd;awGrSm toHk;0ifw,f/

- My mom and dad ~ Allowing me to do things in my way and supported me all the time.
- eugeentay ~ Being more than a true friend & supporting me as much as he can
- Ko Zaw Moe ~ Sharing with his study guides for 70-300 and support
- Apex ~ Introducing me with the examEngines
- Projectw site & Members ~ Giving me guidence to better ExamEngine & Study Materials
- examcollection ~ Sharing exam resource files
- RedRose ~ Giving Endless supports with love at all time
- Forum Friends ~ Well wishing and moral supports
wcgw&HrSm [moudk cGJjcrf;pdwfjzmvdkuf&if r&D&awmhbl;/
wcgw&HrSm [moudk tao;pdwfajz&Sif;ae&if r&D&awmhbl;/
wcgw&HrSm [moudk [movdkU rjrifwwfwJholawGaMumifh [moawG ysufpD;ukefw,f/
World AIDS Day, observed December 1 each year, is dedicated to raising awareness of the AIDS pandemic caused by the spread of HIV infection. AIDS has killed more than 30 million people, with another 40 million people positive for HIV, making it one of the most destructive epidemics in recorded history. Despite recent, improved access to antiretroviral treatment and care in many regions of the world, the AIDS epidemic claimed an estimated 3.1 million (between 2.8 and 3.6 million) lives in 2005 of which, more than half a million (570,000) were children.Needles, use clean ones,
Negotiating skills; negotiating safer sex with a partner and empowering women to make smart choices.







