BASIS DATA PDF

Preview

Summary

LAPORAN PRAKTIKUM BASIS DATA SEMESTER GENAP TAHUN AKADEMIK 2018/2019 Disusun oleh : NIM : 1818057 NAMA : Febryan Alfaridzi KELOMPOK : 25 PROGRAM STUDI TEKNIK INFORMATIKA S-1 FAKULTAS TEKNOLOGI INDUSTRI INSTITUT TEKNOLOGI NASIONAL MALANG 2019 LEMBAR PERSETUJUAN LAPORAN PRAKTIKUM BASIS DATA SEMESTER G...

Description

LAPORAN PRAKTIKUM

BASIS DATA SEMESTER GENAP TAHUN AKADEMIK 2018/2019

Disusun oleh :

NIM

: 1818057

NAMA

: Febryan Alfaridzi

KELOMPOK

: 25

PROGRAM STUDI TEKNIK INFORMATIKA S-1 FAKULTAS TEKNOLOGI INDUSTRI INSTITUT TEKNOLOGI NASIONAL MALANG 2019

LEMBAR PERSETUJUAN LAPORAN PRAKTIKUM BASIS DATA SEMESTER GENAP TAHUN AKADEMIK 2018/2019

Disusun oleh :

NIM

: 1818057

NAMA

: Febryan Alfaridzi

KELOMPOK

: 25

Mengetahui Kepala Laboratorium

Mengetahui

Database dan Sistem Informasi

Dosen Pembimbing

Moh. M. Rokhman, S.Kom, M.Kom

Mira Orisa, ST.MT

NIP. P. 1031500479

NIP. P. 1031000435

PROGRAM STUDI TEKNIK INFORMATIKA S-1 FAKULTAS TEKNOLOGI INDUSTRI INSTITUT TEKNOLOGI NASIONAL MALANG 2019

KATA PENGANTAR Segala puji bagi Allah SWT semata karena dengan rahmat dan hidayah-Nya lah penulis dapat menyelesaikan Laporan Praktikum Basis Data tepat pada waktunya. Terwujudnya laporan ini, tentunya tidak lepas dari bantuan-bantuan yang telah penulis terima. Pada kesempatan ini, penulis menyampaikan terima kasih kepada yang terhormat: 1.

Ibu Mira Orisa, ST,MT. selaku dosen pembimbing Praktikum Database

2.

Bapak Yoseph Dedi Irawan, ST, MT. selaku dosen mata kuliah basis data

3.

Bapak Moh. M. Rokhman, S.Kom. M.Kom selaku Ketua Pelaksana Praktikum Database Jurusan Teknik Informatika ITN Malang.

4.

Instruktur Lab. Database dan Sistem Informasi Teknik Informatika yang telah memberi petunjuk kepada penulis selama pelaksanaan praktikum.

5.

Rekan-rekan yang telah membantu dalam pelaksanaan dan penyelesaian laporan ini.

Harapan penulis laporan praktikum ini bermanfaat bagi penulis sendiri maupun pembaca. Malang, Mei 2019

Penulis

ii

DAFTAR ISI KATA PENGANTAR ......................................................................................... ii DAFTAR ISI ...................................................................................................... iii DAFTAR GAMBAR ........................................................................................ viii DAFTAR TABEL ............................................................................................... x PRAKTIKUM BASIS DATA BAB I ................................................................... 1 1.

2.

ERD .......................................................................................................... 1 1.1

Alat dan Bahan ................................................................................... 2

1.2

Langkah – Langkah ............................................................................ 3

1.3

Tujuan ................................................................................................ 3

1.4

Kesimpulan ........................................................................................ 3

DFD .......................................................................................................... 4 2.1

Alat dan Bahan ................................................................................... 4

2.2

Langkah – langkah ............................................................................. 4

2.3

Tujuan ................................................................................................ 6

2.4

Kesimpulan ........................................................................................ 6

PRAKTIKUM BASIS DATA BAB II ................................................................. 7 1.

TIPE DATA .............................................................................................. 7

2.

DDL .......................................................................................................... 8 2.1

Alat dan bahan ................................................................................... 9

2.2

Langkah – langkah ............................................................................. 9

2.3

Tujuan .............................................................................................. 11

2.4

Kesimpulan ...................................................................................... 11

PRAKTIKUM BASIS DATA BAB III .............................................................. 12 1.

DML ....................................................................................................... 12 1.1

Alat dan Bahan ................................................................................. 14

iii

2.

1.2

Langkah – langkah ........................................................................... 14

1.3

Tujuan .............................................................................................. 16

1.4

Kesimpulan ...................................................................................... 16

OPERATOR ........................................................................................... 17 2.1

Alat dan Bahan ................................................................................. 18

2.2

Langkah – langkah ........................................................................... 18

2.3

Tujuan .............................................................................................. 20

2.4

Kesimpulan ...................................................................................... 20

PRAKTIKUM BASIS DATA BAB IV .............................................................. 21 1.

2.

DML ....................................................................................................... 21 1.1

Alat dan Bahan ................................................................................. 23

1.2

Langkah – langkah ........................................................................... 23

1.3

Tujuan .............................................................................................. 26

1.4

Kesimpulan ...................................................................................... 26

DCL ........................................................................................................ 27 2.1

Alat dan Bahan ................................................................................. 27

2.2

Langkah – langkah ........................................................................... 27

2.3

Tujuan .............................................................................................. 30

2.4

Kesimpulan ...................................................................................... 30

PRAKTIKUM BASIS DATA BAB V ............................................................... 31 1.

UNION, INTERSECTION, DIFFERENCE............................................. 31 1.1

Alat dan Bahan ................................................................................. 32

1.2

Langkah – langkah ........................................................................... 32

1.3

Tujuan .............................................................................................. 36

1.4

Kesimpulan ...................................................................................... 36

PRAKTIKUM BASIS DATA BAB VI .............................................................. 37

iv

1.

2.

VIEW...................................................................................................... 37 1.1

Alat dan Bahan ................................................................................. 38

1.2

Langkah – langkah ........................................................................... 38

1.3

Tujuan .............................................................................................. 39

1.4

Kesimpulan ...................................................................................... 39

SUB QUERY .......................................................................................... 40 2.1

Alat dan Bahan ................................................................................. 40

2.2

Langkah – langkah ........................................................................... 40

2.3

Tujuan .............................................................................................. 42

2.4

Kesimpulan ...................................................................................... 42

PRAKTIKUM BASIS DATA BAB VII ............................................................. 43 1.

JOIN ....................................................................................................... 43 1.1

Alat dan Bahan ................................................................................. 44

1.2

Langkah – langkah ........................................................................... 44

1.3

Tujuan .............................................................................................. 47

1.4

Kesimpulan ...................................................................................... 48

PRAKTIKUM BASIS DATA BAB VIII ........................................................... 49 1.

2.

TRIGGER ............................................................................................... 49 1.1

Alat dan Bahan ................................................................................. 49

1.2

Langkah – langkah ........................................................................... 49

1.3

Tujuan .............................................................................................. 51

1.4

Kesimpulan ...................................................................................... 51

PROCEDURE ......................................................................................... 51 2.1

Alat dan Bahan ................................................................................. 51

2.2

Langkah – langkah ........................................................................... 52

2.3

Tujuan .............................................................................................. 55

v

2.4

Kesimpulan ...................................................................................... 55

PRAKTIKUM BASIS DATA BAB IX .............................................................. 56 1.

FUNCTION ............................................................................................ 56 1.1

Alat dan Bahan ................................................................................. 56

1.2

Langkah – langkah ........................................................................... 56

1.3

Tujuan .............................................................................................. 57

1.4

Kesimpulan ...................................................................................... 58

PRAKTIKUM BASIS DATA BAB X ............................................................... 59 1.

2.

3.

TRANSACTION .................................................................................... 59 1.1

Alat dan Bahan ................................................................................. 60

1.2

Langkah – langkah ........................................................................... 60

1.3

Tujuan .............................................................................................. 62

1.4

Kesimpulan ...................................................................................... 62

BACKUP ................................................................................................ 63 2.1

Alat dan Bahan ................................................................................. 63

2.2

Langkah – langkah ........................................................................... 63

2.3

Tujuan .............................................................................................. 64

2.4

Kesimpulan ...................................................................................... 64

RESTORE............................................................................................... 64 3.1

Alat dan Bahan ................................................................................. 64

3.2

Langkah – langkah ........................................................................... 64

3.3

Tujuan .............................................................................................. 65

3.4

Kesimpulan ...................................................................................... 65

PENUTUP ......................................................................................................... 66 1.1

Kesimpulan ...................................................................................... 66

1.2

Saran ................................................................................................ 67

vi

DAFTAR PUSTAKA ........................................................................................ 68

vii

DAFTAR GAMBAR Gambar 1.1 ERD Penyewaan Alat Musik ............................................................. 3 Gambar 1.2 DFD LV 0 Penyewaan Alat Music FA Musical Studio...................... 4 Gambar 1.3 DFD LV 1 Penyewaan Alat Musik FA Musical Studio ..................... 5 Gambar 2.1 Create Table ..................................................................................... 9 Gambar 2.2 Menambah field tabel ..................................................................... 10 Gambar 2.3 Menghapus tabel ............................................................................. 10 Gambar 3.1 Insert table ...................................................................................... 14 Gambar 3.2 Update tabel.................................................................................... 15 Gambar 3.3 Delete tabel ..................................................................................... 16 Gambar 3.4 Operator Aritmatika ........................................................................ 18 Gambar 3.5 Operator Pembanding ..................................................................... 19 Gambar 3.6 Operator Logika .............................................................................. 19 Gambar 4.1 Group By ........................................................................................ 23 Gambar 4.2 Having ............................................................................................ 23 Gambar 4.3 Upper Lower................................................................................... 24 Gambar 4.4 Substring ........................................................................................ 25 Gambar 4.5 Len ................................................................................................. 25 Gambar 4.6 Top ................................................................................................. 26 Gambar 4.7 Grant .............................................................................................. 28 Gambar 4.8 Revoke ........................................................................................... 28 Gambar 4.9 Deny ............................................................................................... 29 Gambar 5.1 Union All ........................................................................................ 33 Gambar 5.2 Union.............................................................................................. 34 Gambar 5.3 Intersection ..................................................................................... 35 Gambar 5.4 Difference ....................................................................................... 35

viii

Gambar 6.1 Create View .................................................................................... 38 Gambar 6.2 Alter View ...................................................................................... 38 Gambar 6.3 Delete View .................................................................................... 39 Gambar 6.4 Sub Query....................................................................................... 40 Gambar 6.5 Operator Exists dan Not Exists ....................................................... 41 Gambar 7.1 Inner Join ........................................................................................ 44 Gambar 7.2 Left Outer Join................................................................................ 45 Gambar 7.3 Right Outer Join ............................................................................. 46 Gambar 7.4 Full Outer Join ................................................................................ 46 Gambar 7.5 Relasi 3 Tabel ................................................................................. 47 Gambar 8.1 Trigger Insert .................................................................................. 49 Gambar 8.2 Trigger Update................................................................................ 50 Gambar 8.3 Trigger Delete................................................................................. 50 Gambar 8.4 Create Procedure dengan parameter ................................................ 52 Gambar 8.5 Alter Procedure dengan parameter .................................................. 53 Gambar 8.6 Create Procedure tanpa parameter ................................................... 53 Gambar 8.7 Alter Procedure tanpa parameter ..................................................... 54 Gambar 8.8 Delete Procedure............................................................................. 54 Gambar 10.1 Membuat Transaksi....................................................................... 60 Gambar 10.2 Membatalkan Transaksi ................................................................ 61 Gambar 10.3 Menjalankan Transaksi ................................................................ 62 Gambar 10.4 Backup ......................................................................................... 63 Gambar 10.1 Membuat Transaksi.................................................................