Notes

--CREATE STOGROUP SG_HOT1
--ON '/db2data1/db2inst', '/db2data2/db2inst'
--DATA TAG NONE;

--CREATE BUFFERPOOL IBMBP8KB PAGESIZE 8192;

--CREATE LARGE TABLESPACE REG_HOT1
--PAGESIZE 8192
--MANAGED BY AUTOMATIC STORAGE
--USING STOGROUP SG_HOT1
--AUTORESIZE YES
--BUFFERPOOL IBMBP8KB;

--CREATE LARGE TABLESPACE IDX_HOT1
--PAGESIZE 8192
--MANAGED BY AUTOMATIC STORAGE
--USING STOGROUP SG_HOT1
--AUTORESIZE YES
--BUFFERPOOL IBMBP8KB;

--CREATE LARGE TABLESPACE LOB_HOT1
--PAGESIZE 8192
--MANAGED BY AUTOMATIC STORAGE
--USING STOGROUP SG_HOT1
--AUTORESIZE YES
--BUFFERPOOL IBMBP8KB;

CREATE TABLE MASTER.FAKULTAS
(
ID_FAKULTAS SMALLINT NOT NULL PRIMARY KEY,
FAKULTAS VARCHAR(60) NOT NULL
)
IN REG_HOT1
INDEX IN IDX_HOT1
LONG IN LOB_HOT1;

CREATE TABLE MASTER.STRATA
(
ID_STRATA SMALLINT NOT NULL PRIMARY KEY,
SINGKAT VARCHAR(10),
STRATA VARCHAR(45)
)
IN REG_HOT1
INDEX IN IDX_HOT1
LONG IN LOB_HOT1;

CREATE TABLE MASTER.JURUSAN
(
ID_JURUSAN SMALLINT NOT NULL PRIMARY KEY,
ID_FAKULTAS SMALLINT,
JURUSAN VARCHAR(45) NOT NULL,
FOREIGN KEY (ID_FAKULTAS)
REFERENCES MASTER.FAKULTAS(ID_FAKULTAS)
)
IN REG_HOT1
INDEX IN IDX_HOT1
LONG IN LOB_HOT1;

CREATE TABLE MASTER.SELEKSI_MASUK
(
ID_SELEKSI_MASUK SMALLINT NOT NULL PRIMARY KEY,
SINGKAT VARCHAR(12),
SELEKSI_MASUK VARCHAR(45)
)
IN REG_HOT1
INDEX IN IDX_HOT1
LONG IN LOB_HOT1;

CREATE TABLE MASTER.PROGRAM_STUDI
(
ID_PROGRAM_STUDI SMALLINT NOT NULL PRIMARY KEY,
ID_STRATA SMALLINT,
ID_JURUSAN SMALLINT,
PROGRAM_STUDI VARCHAR(60),
FOREIGN KEY (ID_STRATA)
REFERENCES MASTER.STRATA(ID_STRATA),
FOREIGN KEY (ID_JURUSAN)
REFERENCES MASTER.JURUSAN(ID_JURUSAN)
)
IN REG_HOT1
INDEX IN IDX_HOT1
LONG IN LOB_HOT1;

CREATE TABLE MASTER.MAHASISWA
(
NIM VARCHAR(15) NOT NULL PRIMARY KEY,
ID_SELEKSI_MASUK SMALLINT,
ID_PROGRAM_STUDI SMALLINT,
NAMA VARCHAR(45),
ANGKATAN SMALLINT,
TGL_LAHIR DATE,
KOTA_LAHIR VARCHAR(60),
JENIS_KELAMIN CHAR(1),
FOREIGN KEY (ID_SELEKSI_MASUK)
REFERENCES MASTER.SELEKSI_MASUK(ID_SELEKSI_MASUK),
FOREIGN KEY (ID_PROGRAM_STUDI)
REFERENCES MASTER.PROGRAM_STUDI(ID_PROGRAM_STUDI)
)
IN REG_HOT1
INDEX IN IDX_HOT1
LONG IN LOB_HOT1;