Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 39 - Math_Genius_1 2
P. 39

    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

| 34 35 36 37 38 39 40 41 42 43 44 |