Set Operations in Relational Databases In Hindi – जानें क्या है हिन्दी में

1.Union Operations In Hindi (∪) :

  • Operation: Joins the rows of two relations (tables), excluding duplicate rows.
  • Symbol: ( R \cup S ) (Yahan ( R ) aur ( S ) do relations hain.)
  • Example: Agar ( R ) students ka set hai jinki grade “A” hai, aur ( S ) students ka set hai jinki grade “B” hai, toh ( R \cup S ) un students ka set represent karega jo ya toh “A” grade hai ya “B” grade hai.

2. Intersection In Hindi (∩):

  • Operation: Common rows ko retrieve karta hai do relations mein.
  • Symbol: ( R \cap S ) (Yahan ( R ) aur ( S ) do relations hain.)
  • Example: Agar ( R ) set Math mein enrolled students ka hai aur ( S ) set Physics mein enrolled students ka hai, toh ( R \cap S ) Math aur Physics dono mein enrolled students ka set represent karega.

3. Set Difference In Hindi (-):

  • Operation: Pehle relation mein se woh rows retrieve karta hai jo doosre relation mein nahi hain.
  • Symbol: ( R – S ) (Yahan ( R ) aur ( S ) do relations hain.)
  • Example: Agar ( R ) set mein woh students hain jo Math mein enrolled hain aur ( S ) set mein woh students hain jo Physics mein enrolled hain, toh ( R – S ) Math mein enrolled students ka set represent karega jo Physics mein nahi hain.

Leave a Comment