create database kampus
use kampus
create table kelas(
kdkls char(4) not null primary key,
namakls varchar(10))
create table jurusan(
kdjur char(4) not null primary key,
namajur varchar(20))
create table mahasiswa(
nim char(12)not null primary key,
nama varchar (30),
alamat varchar (30),
jnsklmn char(1),
agama varchar (15),
kdkelas char(4)references kelas(kdkls),
kdjur char(4)references jurusan(kdjur))
select*from mahasiswa
select*from kelas
select*from jurusan
insert into kelas
values('K01','KA-01')
insert into kelas
values('K02','KA-02')
insert into jurusan
values('KMI','MI')
insert into jurusan
values('KKA','KA')
insert into mahasiswa
values('20120103001','PUSPITA','JLN.SUASIO','P','ISLAM','K01','KKA')
insert into mahasiswa
values('20120103002','RONI','JLN.LANGKAT','L','KRISTEN','K02','KKA')
insert into mahasiswa
values('20120103003','dewi','JLN.serdang','p','budha','K01','KKA')
insert into mahasiswa
values('20120103004','fani','JLN.jawa','p','protestan','K02','KKA')