Entity Relationship Diagram (Many To Many)

Assalamu’alaikum
Alhamdulillah finally finish ヽ(^o^)ノ

Ini adalah contoh dari dari Entity Relationship Diagram bagian many to many

Selamat mencoba semoga berguna bagi pembaca juga

Create database Studi Use Studi Create table Mahasiswa (             NIM char (3) not null primary key,             Nama varchar (10),             Alamat varchar (20),             Jenis_Kelamin char (1),             Agama varchar (10)) Select * from Mahasiswa Insert into Mahasiswa values ('A01', 'Mitha', 'Jln. Sabang No.3b', 'P', 'Islam') Insert into Mahasiswa values ('A02', 'Radith', 'Jln. Maluku No.4b', 'L', 'Islam') Insert into Mahasiswa values ('A03', 'Anya', 'Jln. Seram No.5b', 'P', 'Islam') Insert into Mahasiswa values ('A04', 'Aisyah', 'Jln. Bandung No.5c', 'P', 'Islam') Insert into Mahasiswa values ('A05', 'Ali', 'Jln. Jawa No.2c', 'L', 'Islam') Create table Mata_Kuliah (             Kode_Matkul char (3) not null primary key,             Nama_Matkul varchar (10)) Select * from Mata_Kuliah Insert into Mata_Kuliah values ('M01', 'Web Design') Insert into Mata_Kuliah values ('M02', 'Basis Data') Insert into Mata_Kuliah values ('M03', 'SQL Server') Select * from Mata_Kuliah Create table  KRS (             Id_KRS char (3) not null primary key,             NIM char (3) references Mahasiswa (NIM),             Kode_Matkul char (3) references Mata_Kuliah(Kode_Matkul)) Select * from KRS Insert into KRS values ('K01', 'A01', 'M01') Insert into KRS values ('K02', 'A02', 'M02') Insert into KRS values ('K03', 'A03', 'M02') Insert into KRS values ('K04', 'A04', 'M03') Insert into KRS values ('K05', 'A05', 'M01') Select K.Id_KRS, M.NIM, MK.Kode_Matkul from KRS K inner join Mahasiswa M inner join Mata_Kuliah MK on M.NIM=M.NIM on MK.Kode_Matkul=MK.Kode_Matkul Select K.Id_KRS, M.NIM, MK.Kode_Matkul from KRS K left outer  join Mahasiswa M left outer join Mata_Kuliah MK on M.NIM=M.NIM on MK.Kode_Matkul=MK.Kode_Matkul Select K.Id_KRS, M.NIM, MK.Kode_Matkul from KRS K right outer join Mahasiswa M right outer join Mata_Kuliah MK on M.NIM=M.NIM on MK.Kode_Matkul=MK.Kode_Matkul Select K.Id_KRS, M.NIM, MK.Kode_Matkul from KRS K full outer join Mahasiswa M full outer join Mata_Kuliah MK on M.NIM=M.NIM on MK.Kode_Matkul=MK.Kode_Matkul

Tampilan Inner Join

Tampilan Left Outer Join

Tampilan Right Outer Join

Tampilan Full Outer Join