MANY TO MANY

1.      MEMBANGUN DATABASE  KAMPUS

create database kampus
use kampus

      create table mahasiswa (
Nim char (4)primary key,
Nama varchar (20),
Agama varchar (10),
Jns_kelamin varchar (1),
Alamat varchar (20))
select * from mahasiswa

Menambahkan record – recordnya :
insert into mahasiswa values('0123','Adit','Islam','L','P.Siantar')
insert into mahasiswa values('0124','Bobby','Hindu','L','Medan')
insert into mahasiswa values('0125','Cahyanti','Kristen','P','Perdagangan')
insert into mahasiswa values('0126','Dedek','Budha','P','P.Siantar')

3.     MEMBANGUN TABLE MATAKULIAH
create table matakuliah (
Kode_mk char (3)primary key,
Nama_mk varchar (20))
select * from matakuliah

Menambahkan record – recordnya :
insert into matakuliah values('MO1','Database')
insert into matakuliah values('MO2','P.Citra')
insert into matakuliah values('MO3','Web')

4.     MEMBANGUN TABLE KRS
create table krs (
Id_krs char (4) primary key,
Nim char (4) references mahasiswa (Nim),
Kode_mk char (3) references matakuliah (Kode_mk))
select * from krs

Menambahkan record – recordnya :
insert into krs values('K021','0123','MO1')
insert into krs values('K022','0124','MO2')
insert into krs values('K023','0125','MO3')
insert into krs values('K024','0126','MO1')
insert into krs values('K025','0124','MO3')

CROSS JOIN
select * from mahasiswa cross join matakuliah cross join krs

INNER JOIN
select m.Nama,m.Jns_Kelamin,t.Nama_mk from mahasiswa m inner join matakuliah t inner join krs k on k.Nim = k.Nim on k.Kode_mk = k.Kode_mk

LEFT OUTER JOIN
select m.Nama,m.Jns_Kelamin,t.Nama_mk from mahasiswa m left outer join matakuliah t left outer join krs k on k.Nim = k.Nim on k.Kode_mk = k.Kode_mk

RIGHT OUTER JOIN
select m.Nama,m.Jns_Kelamin,t.Nama_mk from mahasiswa m right outer join matakuliah t left outer join krs k on k.Nim = k.Nim on k.Kode_mk = k.Kode_mk

FULL OUTER JOIN
select m.Nama,m.Jns_Kelamin,t.Nama_mk from mahasiswa m full outer join matakuliah t left outer join krs k on k.Nim = k.Nim on k.Kode_mk = k.Kode_mk