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

One To One

create database perusahaan

create table jabatan(

        kd_jabatan char(12)not null primary key,

        Nm_jabatan varchar(20))

select*from jabatan

create table pegawai(

        NIP char(12)not null primary key,

        nama varchar(20),

        Agama varchar(10),

        JNS_kelamin char(1),

        kd_jabatan char(12)references jabatan(kd_Jabatan))

        alter table pegawai add alamat varchar(20)

select*from pegawai

insert into jabatan values('201202030040','Direktur')

insert into jabatan values('201202030041','Personalia')

insert into jabatan values('201202030042','Marketing')

insert into pegawai values('201202030050','Anto','Islam','L','201202030040','JL.asahan')

insert into pegawai values('201202030051','Muhammad','Islam','L','201202030041','JL.Jawa')