Operations of dbms

All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
 115 views
of 18

Please download to get full document.

View again

Description
3. U Name Amount Rishabh 9000 Ravi 1000 Raju 500 Name Amount Rishabh 15000 Ravi 1000 Rakesh 2500 Sales 2006 4. = Name Amount Rishabh 9000 Ravi 1000 Raju 500 Rishabh 15000…
Share
Transcript
  • 3. U Name Amount Rishabh 9000 Ravi 1000 Raju 500 Name Amount Rishabh 15000 Ravi 1000 Rakesh 2500 Sales 2006
  • 4. = Name Amount Rishabh 9000 Ravi 1000 Raju 500 Rishabh 15000 Rakesh 2500
  • 5. U A 1 B 2 D 3 F 4 E 5 A 1 C 2 D 3 E 4
  • 6. = A 1 D 3 Yields Query like this
  • 7. Student ID Name Address St_01 Rishabh Patna St_02 Abhishek Delhi St_03 Shruti Pilani St_04 Ashish Pilani St_05 Aakash Jamui St_07 Sagar Delhi
  • 8. Student ID Name Address St_01 Rishabh Patna St_02 Abhishek Delhi St_03 Shruti Pilani St_04 Ashish Pilani St_05 Aakash Jamui St_07 Sagar Delhi Student ID Name Address St_02 Abhishek Delhi St_07 Sagar Delhi
  • 9. Student ID Name Address St_01 Rishabh Patna St_02 Abhishek Delhi St_03 Shruti Pilani St_04 Ashish Pilani St_05 Aakash Jamui St_07 Sagar Delhi Student ID Name St_01 Rishabh St_02 Abhishek St_03 Shruti St_04 Ashish St_05 Aakash St_07 Sagar
  • 10. ID Name E_01 Rishabh E_02 Abhishek E_03 Shruti E_04 Ashish E_05 Ravi ID Salary E_01 90000 E_02 90000 E_03 85000 E_04 80000 E_05 10000
  • 11. ID Name Salary E_01 Rishabh 90000 E_02 Abhishek 90000 E_03 Shruti 85000 E_04 Ashish 80000 E_05 Ravi 10000 Yields Query like this
  • 12. ID Name E_01 Rishabh E_02 Abhishek E_03 Shruti E_04 Ashish E_05 Ravi ID Name E_02 Abhishek E_03 Shruti E_07 Danish
  • 13. ID Name E_01 Rishabh E_04 Ashish E_05 Ravi
  • 14. A 1 B 2 C 3 A 10 B 20
  • 15. A 1 A 10 A 1 B 20 B 2 A 10 B 2 B 20 C 3 A 10 C 3 B 20
  • 16. A B A1 B1 A1 B2 A2 B1 A3 B1 A4 B2 A5 B1 A5 B2 B B1
  • 17. A A1 A2 A3 A5
  • Related Search
    We Need Your Support
    Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

    Thanks to everyone for your continued support.

    No, Thanks