bwt LA SBD pert 1

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 :