DataBase: Contoh Praktikum

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')

DataBase