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) );
Tidak ada komentar:
Posting Komentar