Selection ( σ ) σ Kota=“Malang” ( Dosen ) Select * From Dosen Where Kota ='Malang' - PowerPoint PPT Presentation

slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Selection ( σ ) σ Kota=“Malang” ( Dosen ) Select * From Dosen Where Kota ='Malang' PowerPoint Presentation
Download Presentation
Selection ( σ ) σ Kota=“Malang” ( Dosen ) Select * From Dosen Where Kota ='Malang'

play fullscreen
1 / 4
Selection ( σ ) σ Kota=“Malang” ( Dosen ) Select * From Dosen Where Kota ='Malang'
144 Views
Download Presentation
keefe
Download Presentation

Selection ( σ ) σ Kota=“Malang” ( Dosen ) Select * From Dosen Where Kota ='Malang'

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. ImplimentasiAljabarRelasionalDengan SQL • Selection (σ) • σKota=“Malang”(Dosen) • Select * From Dosen Where Kota ='Malang' • σKota=“Blitar”(Mahasiswa) • Select * From Mahasiswa Where Kota ='Blitar'

  2. Intersection () • pkota (Dosen)  pkota (Mahasiswa) • (select distinct kota from Dosen) • Intersect • (select distinct kota from Mahasiswa) • Union () • p kota (Dosen)  p kota (Mahasiswa) • (select distinct kota from Dosen) • union (select distinct kota from Mahasiswa) • Minus (-) • pkota (Dosen) - p kota (Mahasiswa) • (select distinct kota from Dosen) • EXCEPT (select distinct kota from Mahasiswa)

  3. CROSS ( x ) • nid,nama,alamat,kota (Mahasiswa) X pnid, • nama, jurusan (Jurusan) • SELECT * FROM MAHASISWA CROSS JOIN JURUSAN • JOIN ( ) • kd_dosen,Nama(Dosen) p Kd_dosen,Mt_kuliah, • Nilai(Nilai) • SELECT Dosen.kd_dosen,Dosen.Nama, Nilai.Kd_dosen,Nilai.Mt_kuliah,Nilai.Nilai FROM Dosen JOIN • Nilai ON Dosen.Kd_Dosen = Nilai.Kd_Dosen

  4. Division (/ ) • R/S1 • SELECT distinct(Sno) FROM R WHERE EXISTS(SELECT * FROM S1 WHERE R.pno = S1.pno) • R/S2 • SELECT distinct(Sno) FROM R WHERE EXISTS(SELECT * FROM S2 WHERE R.pno = S2.pno)