Page 39 - Play v1.0 gujarati class 8
P. 39

he÷uþ™þe…™e h[™k fhðk {kxu ƒu xuƒ÷ ƒ™kðku :
                      rðãkÚkeo™k hku÷ ™tƒh, ™k{, r…Œk™wt ™k{, ‚h™k{wt ð„uhu suðe ‚k{kLÞ {krnŒe ÄhkðŒwt Table2 ™k{™wt xuƒ÷
                      ƒ™kðku.
                      hku÷ ™tƒh, „wý, xfk, „úuz ð„uhu suðe {krnŒe ÄhkðŒwt Table3 ™k{™wt xuƒ÷ ƒ™kðku.











                             rh÷uþLkrþÃkLku ÔÞkÏÞkrÞík fhðk {kxu fkuüfkuLkku WÃkÞkuøk fhðku (Using tables for defining relationships)
                 ƒu fkuüfku ðå[u™k ‚tƒtÄ™u ÔÞkÏÞkrÞŒ fhðk {kxu, yk …„÷kt™u y™w‚hku:

                 …„÷wt 1    zuxkƒuÍ xqÕ‚ xuƒ nuX¤ rh÷uþ™þe… „úw… ŒhVÚke
                            rh÷uþ™rþ… f{kLz …h Âõ÷f fhku.
                 …„÷wt 2    Show  xuƒ÷  zkÞ÷ku„  ƒkuõ‚  ¾w÷þu.  Add
                            ƒx™ …h Âõ÷f fhku. …‚tË fhu÷ fkuüf zuxkƒuÍ
                            xqÕ‚ xuƒ{kt ‚tƒtÄ rðLzku{kt Ëu¾kþu.               zuxkçkuÍ xq÷ xuçk (Database Tools tab)

                 …„÷wt 3    yuf xuƒ÷™k «kÞ{he  fe rVÕz …h Âõ÷f fhku y™u
                            …fze hk¾ku.
                 …„÷wt 4    yLÞ xuƒ÷{kt ‚k{kLÞ rVÕz{kt {kW‚ …kuRLxh™u zÙuøk fhku y™u {kW‚ ƒx™ Akuzku.

                 …„÷wt 5    Edit Relationship zkÞ÷ku„ ƒkuõ‚ ¾ku÷þu. Create ƒx™ …h Âõ÷f fhku.
                 yk ƒu fkuüfku™k ‚tƒtrÄŒ ûkuºkku ðå[u ÷kE™îkhk he÷uþ™þe… ƒ™kðkþu:








                                                                                       Relationship
                                                                                       established between
                                                                                       'Table2' table and
                                                                                       'Table3' table based on
                                                                                       the Primary Key named
                                                                                       ‘Roll No’.

                                            rh÷uþLkrþÃk çkLkkððk (Relationship Created)

                 õðuhe ƒ™kðe (Creating a Query)
                 õðuhe ƒ™kððk {kxu, yk …„÷kt y™w‚hku :

                 …„÷wt 1    Create xuƒ nuX¤ õðuhe „úw…{ktÚke õðuhe rzÍkR™ f{kLz …h Âõ÷f fhku.









                                                      õðuhe çkLkkððe (Creating a query)


                                                                  yu{yuMk yuõMkuMk{kt õðuhe, Vku{o yLku heÃkkuxo 37
   34   35   36   37   38   39   40   41   42   43   44