Many To Many

Many To Many

create database kampus

use kampus

create table mahasiswa(

        Nim Char(12)not null primary key,

        Nama Varchar(20),

        Alamat varchar(15),

        jnsklmn char(1),

        Agama Varchar(10))

select * from mahasiswa

create table Mata_kuliah(

        kd_matakuliah char (5)not null primary key,

        Nm_matakuliah varchar (10),

        sks varchar(10))

select*from mata_kuliah

create table KRS(

        Id_krs char(3)not null primary key,

        Nim char(12)references mahasiswa (Nim),

        kd_matakuliah char(5)references mata_kuliah (kd_matakuliah))

select*from KRS

insert into Mahasiswa values('201202030050','ayu','jl.Bali','P','Islam')

insert into mahasiswa values('201202030051','Ranti','Jl.Setia negara','P','Kristen')

insert into mahasiswa values('201202030052','DANU','Jl.singosari','P','Budha')

insert into mata_kuliah values('M0001','Database','2')

insert into mata_kuliah values('MOO02','Mtk1','2')

insert into mata_kuliah values('M0003','agama','2')

Insert into KRS Values('K01','201202030050','M0001')

Insert into KRS Values('K02','201202030050','M0001')

select*from mahasiswa cross join KRS

select M.Nama,K.Kd_matakuliah from mahasiswa M inner join KRS K on M.NIM=K.NIM

select M.Nama,M.Alamat,K.Kd_matakuliah from mahasiswa M Left outer join KRS K on M.NIM=K.NIM