Page 91 - Play v1.0 gujarati class 8
P. 91
«kusuõx fkÞo
yu{yu‚ yuõ‚u‚ Subject Enrichment
«kusuõx 1
™e[u «{kýu MS Access {kt ºký fkuüfku ƒ™kðku:
Table: Purchases
Item_ID Quantity Purchased Rate per unit Amount
Table: Sales
Item_ID Quantity Sold Rate per unit Amount
Table: Stock in Hand
Item_ID Item Name Quantity in Hand at the beginning
• Ëhuf fkuüf{kt 5 yuLxÙeyku ƒ™kðku.
• ƒÄe ðMŒwyku {kxu ytŒu nkÚk{kt sÚÚkk™e „ýŒhe fhðk {kxu õðuhe ƒ™kðku.
«kusuõx 2
ABC nkuÂM…x÷ ‚uðkyku îkhk ËËeo™k hufkuzo ò¤ððk {kxu zuxk yuLxÙe Vku{o ƒ™kðku. fkuüf™ku ¼k„ ƒ™ðk™e sYh Au Œu ûkuºkku Au:
• Þwr™f …uþLx ykEze
• ËËeo™wt ™k{
• ËËeo™wt ‚h™k{wt
• ÷ûkýku
• zkuõxh™wt ™k{
• r™Ëk™
• ykhkuøÞ ðe{k fðhus (nk/™k)
«kusuõx 3
yu{yuMk yuõ‚u‚{kt ™e[u™k fkuüfku ƒ™kðku:
Table: Parts
Part No Part Name Par tUnit Supplier ID Stock Cost Price Sale Price
«kusuõx fkÞo 89

