1.
MEMBANGUN DATABASE KAMPUS
create
database kampus
use 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
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
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
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
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
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
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
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
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