1 / 4

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

Implimentasi Aljabar Relasional Dengan SQL. Selection ( σ ) σ Kota=“Malang” ( Dosen ) Select * From Dosen Where Kota ='Malang' σ Kota=“ Blitar ” ( Mahasiswa ) Select * From Mahasiswa Where Kota =' Blitar '. Intersection ( ) p kota (Dosen)  p kota (Mahasiswa)

keefe
Télécharger la présentation

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

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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)

More Related