1.membuat tabel mahasiswa
CREATE TABLE MAHASISWA
( NPM CHAR(8) NOT NULL PRIMARY KEY,
NAMA VARCHAR2(25) NOT NULL,
LAHIR DATE,
AGAMA VARCHAR2(10) NOT NULL,
ALAMAT VARCHAR2(30) NOT NULL,
KOTA VARCHAR2(12) NOT NULL,
KODE_POS CHAR(5) NOT NULL,
TELPON VARCHAR2(10) );
output :
2.membuat tabel dosen
CREATE TABLE DOSEN
( KODE_DOSEN CHAR(5) NOT NULL PRIMARY KEY,
NAMA_DOSEN VARCHAR2(25) NOT NULL,
ALAMAT VARCHAR2(30) NOT NULL,
KOTA VARCHAR2(12) NOT NULL,
KODE_POS CHAR(5) NOT NULL,
TELPON VARCHAR2(10) );
output :

3.membuat tabel matkul
CREATE TABLE MATKUL
( KODE_MK CHAR(5) NOT NULL PRIMARY KEY,
NAMA_MK VARCHAR2(20) NOT NULL,
SKS SMALLINT NOT NULL,
STATUS CHAR(1) NOT NULL );
output :

4.membuat tabel nilai
CREATE TABLE NILAI
( NPM CHAR(8) NOT NULL,
KODE_DOSEN CHAR(5) NOT NULL,
KODE_MK CHAR(5) NOT NULL,
NIL_MID SMALLINT,
NIL_FIN SMALLINT );
output :