Page 39 - Math_Genius_1 2

laca/ cukus osQ fy, nks VscYl cuk,¡%
Vscy 2 uke dk Vscy ftlesa Nk=kksa osQ ckjs esa lkekU; tkudkjh gksrh gS] tSls fd mudk jksy uacj] uke] firk dk

uke] irk vkfnA
Vscy 3 uke dk Vscy ftlesa jksy uacj] vad] çfr'kr] xzsM vkfn osQ ckjs esa tkudkjh gksrh gSA

laca/ksa dks ifjHkkf"kr djus osQ fy, VscYl dk mi;ksx djuk (Using tables for defining relationships)
nks VscYl osQ chp laca/ dks ifjHkkf"kr djus osQ fy,] bu LVsIl dk ikyu djsa%

LVsi 1 MsVkcsl VwYl VSc osQ rgr fjys'kuf'ki xzqi ls
fjys'kuf'ki dekaM ij fDyd djsaA
LVsi 2 'kks Vscy Mk;ykWx ckWDl •qysxkA ,sM cVu ij fDyd
djsaA p;fur Vscy laca/ foaMks esa fn•kbZ nsxhA
+
LVsi 3 ,d Vscy osQ izkFkfed dh IkQhYM ij fDyd djosQ
MsVkcsl midj.k VSc (Database Tools tab)
j[ksaA
LVsi 4 ekml ikWbaVj dks nwljs Vscy osQ dkWeu iQhYM esa MªSx djsa vkSj ekml cVu dks NksM+ nsaA

LVsi 5 blls ,fMV fjys'kuf'ki djsa MkW;ykWx ckWDl •qy tk,xkA fØ,V cVu ij fDyd djsaA
;g nks VscYl osQ lacaf/r {ks=kksa osQ chp ,d js•k ;k laca/ cuk,xk%

^jksy uacj* uked çkFkfed oqaQth osQ
vk/kj ij ^Vscy 2* Vscy vkSj ^Vscy 3*
Vscy osQ chp laca/ LFkkfir fd;k x;kA
(Relationship established between
‘Table 2’ table and ‘Table 3’ table
based on the Primary Key named
‘Roll No’.)

laca/ cuk;k (Relationship Created)

,d ç'u cukuk (Creating a Query)
iz'u cukus osQ fy,] bu LVsIl dk ikyu djsa%
LVsi 1 fØ,V VSc osQ rgr iz'u lewg ls iz'u fMtkbu dekaM ij fDyd djsaA

,d ç'u cukuk (Creating a query)

,e,l ,Dlsl esa ç'u] iQkWeZ vkSj fjiksVZ 37