operations of dbms
DESCRIPTION
A Powerpoint presentation on Operations of DBMS. This is a creative Powerpoint but you need to be good at explaning, as it only consists of tables. All the Best !!TRANSCRIPT
![Page 1: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/1.jpg)
![Page 2: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/2.jpg)
![Page 3: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/3.jpg)
Name Amount
Rishabh 9000
Ravi 1000
Raju 500
Name Amount
Rishabh 15000
Ravi 1000
Rakesh 2500
Sales 2006
U
![Page 4: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/4.jpg)
Name Amount
Rishabh 9000
Ravi 1000
Raju 500
Rishabh 15000
Rakesh 2500
=
![Page 5: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/5.jpg)
A 1
B 2
D 3
F 4
E 5
A 1
C 2
D 3
E 4
U
![Page 6: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/6.jpg)
A 1
D 3=
Yields Query like this
![Page 7: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/7.jpg)
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
![Page 8: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/8.jpg)
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
![Page 9: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/9.jpg)
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
![Page 10: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/10.jpg)
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
![Page 11: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/11.jpg)
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
![Page 12: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/12.jpg)
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
![Page 13: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/13.jpg)
ID Name
E_01 Rishabh
E_04 Ashish
E_05 Ravi
![Page 14: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/14.jpg)
A 1
B 2
C 3
A 10
B 20
![Page 15: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/15.jpg)
A 1 A 10
A 1 B 20
B 2 A 10
B 2 B 20
C 3 A 10
C 3 B 20
![Page 16: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/16.jpg)
A B
A1 B1
A1 B2
A2 B1
A3 B1
A4 B2
A5 B1
A5 B2
B
B1
![Page 17: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/17.jpg)
A
A1
A2
A3
A5
![Page 18: Operations of dbms](https://reader033.vdocuments.us/reader033/viewer/2022061114/54583591af79594f558b5298/html5/thumbnails/18.jpg)