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

