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/
Needles, use clean ones,
Negotiating skills; negotiating safer sex with a partner and empowering women to make smart choices.