Scribd
Upload
75 views5 pages

Fathan Mubina - 185150400111055 - Lat1

The document discusses implementing a database for a university campus. It includes: 1) Creating storage groups, bufferpools, and tablespaces for the estimated 300GB database on SSD storage. 2) Implementing the normalized student data schema from Figure 1 by creating tables for faculties, majors, degree levels, study programs, entrance selections, and students with foreign keys. 3) A screenshot confirming the creation of the tables in the schema.

Uploaded by

Fathan Mubina
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
75 views5 pages

Fathan Mubina - 185150400111055 - Lat1

The document discusses implementing a database for a university campus. It includes: 1) Creating storage groups, bufferpools, and tablespaces for the estimated 300GB database on SSD storage. 2) Implementing the normalized student data schema from Figure 1 by creating tables for faculties, majors, degree levels, study programs, entrance selections, and students with foreign keys. 3) A screenshot confirming the creation of the tables in the schema.

Uploaded by

Fathan Mubina
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 5

LABORATORIUM BASIS DATA FAKULTAS ILMU KOMPUTER

UNIVERSITAS BRAWIJAYA

NAMA : FATHAN MUBINA


NIM : 185150400111055
KELAS : SI - C
BAB : DATA PLACEMENT DAN DATABASE OBJECT

1. Soal
Sebagai seorang DBA anda diberikan sebuah server yang akan digunakan untuk
mengimplementasikan database.
Basis data yang akan diimplementasikan merupakan basis data kampus perkiraan ukuran
datanya sampai dengan 300GB.

1.1 Query
CREATE STOGROUP SG_HOT1
ON '/ssd1/db2inst1', '/ssd2/db2inst1'
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;

Laporan Praktikum Administrasi Basis Data – Nama – NIM 1


LABORATORIUM BASIS DATA FAKULTAS ILMU KOMPUTER
UNIVERSITAS BRAWIJAYA

1.2 Screenshot

Laporan Praktikum Administrasi Basis Data – Nama – NIM 2


LABORATORIUM BASIS DATA FAKULTAS ILMU KOMPUTER
UNIVERSITAS BRAWIJAYA

2. Soal
Impelementasikan Gambar 1 yang merupakan hasil normalisasi dari sebagian
basis data KAMPUSDB

Gambar 1. Skema mahasiswa

2.1 Query
CREATE SCHEMA MASTER;
CREATE TABLE MASTER.FAKULTAS
(
ID_FAKULTAS SMALLINT NOT NULL PRIMARY KEY,
FAKULTAS VARCHAR(45) NOT NULL
)
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 NOT NULL,
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.STRATA


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

Laporan Praktikum Administrasi Basis Data – Nama – NIM 3


LABORATORIUM BASIS DATA FAKULTAS ILMU KOMPUTER
UNIVERSITAS BRAWIJAYA

CREATE TABLE MASTER.PROGRAM_STUDI


(
ID_PROGRAM_STUDI SMALLINT NOT NULL PRIMARY KEY,
ID_STRATA SMALLINT NOT NULL,
ID_JURUSAN SMALLINT NOT NULL,
PROGRAM_STUDI VARCHAR(60) NOT NULL,
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.SELEKSI_MASUK


(
ID_SELEKSI_MASUK SMALLINT NOT NULL PRIMARY KEY,
SINGKAT VARCHAR(12) NOT NULL,
SELEKSI_MASUK VARCHAR(45) NOT NULL
)
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 NOT NULL,
ID_PROGRAM_STUDI SMALLINT NOT NULL,
NAMA VARCHAR(45) NOT NULL,
ANGKATAN SMALLINT NOT NULL,
TGL_LAHIR DATE NOT NULL,
KOTA_LAHIR VARCHAR(60) NOT NULL,
JENIS_KELAMIN CHAR(1) NOT NULL,
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;

Laporan Praktikum Administrasi Basis Data – Nama – NIM 4


LABORATORIUM BASIS DATA FAKULTAS ILMU KOMPUTER
UNIVERSITAS BRAWIJAYA

2.2 Screenshot

Laporan Praktikum Administrasi Basis Data – Nama – NIM 5

You might also like