Koding Pembuatan Database Kampus

Membuat database KAMPUS

Create database KAMPUS

Membuat Tabel
Tabel Mahasiswa

Create table MAHASISWA(

THANG int (4) not null primary key,

NIM int (4) not null,

NAMA varchar(30) not null,

ALAMAT varchar (80) null,

     TANGGAL date null default ‘0000-00-00’);

Tabel Matakuliah

Create table MATAKULIAH (

KODE char (2) not null primary key,

MATAKULIAH varchar (30) not null,

SKS int(4) null):

Tabel Dosen

Create table DOSEN (

NIP int (4) not null primary key,

NAMA varchar (30) not null);

Tabel Kelas

Create table KELAS (

IDKELAS int(4) not null primary key,

KODE char (2) not null,

NIP int (4) not null,

Foreign key KODE references MATAKULIAH(KODE),

Foreign key NIP references DOSEN(NIP) );

Tabel KRS

Create table KRS (

NIM int (4) not null,

IDKELAS int (4) not null,

NILAI int (4) not null,

Foreign key NIM references MAHASISWA (NIM),

Foreign key IDKELAS references KELAS (IDKELAS) );