Praktek Pertemuan 8

create database Pertemuan8
use pertemuan8

create table Dosen (
NIDN Char (10) primary key,
Nama_Dosen varchar (25),
Pendidikan_terakhir varchar(20),
Agama varchar(15),
jns_klmin char(1),
Alamat varchar(30))
select*from Dosen

insert into Dosen values ('001','Sundari','M.kom','Islam','P','Jln.kartini')
insert into Dosen values ('002','Sumarno','S.kom','Islam','L','Jln.Medan')
insert into Dosen values ('003','Edi','S.kom','Islam','L','Karang sari')
insert into Dosen values ('004','Desman','S.pd','Kristen','L','Tanah Jawa')
insert into Dosen values ('005','Susi','S.Pd','Kristen','P','Jln.kartini')




create table Matakuliah (
Kd_Mtkul char (5) primary key,
Nama_Mtkul varchar (25),
sem char (4),
prodi varchar (30))
select*from Matakuliah

insert into Matakuliah values ('0A','DATABASE','II','Manajement Informatika')
insert into Matakuliah values ('0B','DELPHI','II','Manajement Informatika')
insert into Matakuliah values ('0C','PAN','II','Manajement Informatika')
insert into Matakuliah values ('0D','MATEMATIKA','VI','Manajement Informatika')
insert into Matakuliah values ('0E','STATISTIK','VI','Manajement Informatika')




create table Perkuliahan (
NIDN char (10) references Dosen (NIDN),
kd_Mtkul char (5) references Matakuliah (kd_Mtkul))
select*from Perkuliahan

insert into Perkuliahan values ('001','0A')
insert into Perkuliahan values ('002','0B')
insert into Perkuliahan values ('003','0C')
insert into Perkuliahan values ('004','0D')
insert into Perkuliahan values ('005','0E')
insert into Perkuliahan values ('002','0A')
insert into Perkuliahan values ('001','0C')
insert into Perkuliahan values ('00C','0A')





select * from Dosen where Agama='Hindu' or Agama='Islam'


select * from Dosen where jns_klmin='L' and Agama='Islam'



select * from Dosen where not jns_klmin='L'



select jns_klmin from Dosen group by jns_klmin



Select * from dosen order by Nama_Dosen















Trimakasih........................................