PERANCANGAN BASIS DATA PEMASARAN , PENGIKLANAN DAN

PERANCANGAN BASIS DATA PEMASARAN , PENGIKLANAN
DAN PEMBAYARAN PROPERTI PADA PT REALL PRO
LAPORAN TUGAS AKHIR
Oleh
Chandra Harry Gunawan
1301045942
K.Indra Gujianto
1301046024
Wiva Nugraha
1301046075
Kelas/Kelompok : 07PCM/08
Universitas Bina Nusantara
Jakarta
2013
PERANCANGAN BASIS DATA PEMASARAN , PENGIKLANAN
DAN PEMBAYARAN PROPERTI PADA PT REALL PRO
SKRIPSI
diajukan sebagai salah satu syarat
untuk gelar kesarjanaan pada
Jurusan Sistem Informasi
Program Studi
Jenjang Pendidikan Strata-1
Oleh
Chandra Harry Gunawan
1301045942
K.Indra Gujianto
1301046024
Wiva Nugraha
1301046075
Kelas/Kelompok : 07PCM/08
Universitas Bina Nusantara
Jakarta
2013
DAFTAR ISI
Halaman Judul Luar .................................................................................................... i
Halaman Judul Dalam ................................................................................................ ii
Halaman Persetujuan Hard Cover ............................................................................... iii
Halaman Pernyataan Dewan Penguji ........................................................................... iv
Halaman Pemberian Hak Cipta ................................................................................... vii
Abstrak ...................................................................................................................... viii
Prakata ....................................................................................................................... ix
Daftar Isi..................................................................................................................... xi
Daftar Tabel ............................................................................................................... xvi
Daftar Gambar ............................................................................................................ xvii
Daftar Lampiran ......................................................................................................... xx
BAB 1 PENDAHULUAN ......................................................................................... 1
1.1 Latar Belakang ......................................................................................... 1
1.2 Ruang Lingkup ......................................................................................... 2
1.3 Tujuan dan Manfaat .................................................................................. 2
1.3.1 Tujuan ........................................................................................ 2
1.3.2 Manfaat ...................................................................................... 3
1.4 Metodologi ............................................................................................... 3
1.5 Sistematika Penulisan ............................................................................... 7
BAB 2 LANDASAN TEORI .................................................................................... 9
2.1 Pengertian Basis Data ............................................................................... 9
2.2 Database Management System (DBMS) ................................................... 9
2.2.1 Fungsi DBMS ............................................................................ 12
2.2.2 Kerugian DBMS ......................................................................... 12
2.3 Database Language ................................................................................... 13
2.3.1 Data Definition language (DDL) ................................................. 13
2.3.2 Data Manipulation Language (DML) .......................................... 13
2.4 Database Application Lifecyle (DBLC) .................................................... 14
2.4.1 Database Planning ...................................................................... 15
2.4.2 System Definiton ........................................................................ 15
2.4.3 Requirement Collection and Analysis ......................................... 16
2.4.4 Database Design ......................................................................... 17
2.4.5 DBMS Selection (optional) ......................................................... 19
2.4.6 Application Design ..................................................................... 20
2.4.7 Prototyping (optional).................................................................. 21
2.4.8 Impelementation ......................................................................... 22
2.4.9 Data Conversion and Loading (Pengubahan dan Pemuatan Data) 22
2.4.10 Testing ( Uji Coba) ................................................................... 23
2.4.11 Operasional Maintenance ( Perawatan Operasional ) ................ 24
2.5 Teori Entity-Relational Modelling ( ER Model ) ........................................ 24
2.6 Teori Normalisasi ...................................................................................... 29
2.6.1 Proses Normalisasi ...................................................................... 29
2.7 Teori Activity Diagram ............................................................................. 30
2.8 Teori State Transition Diagram (STD) ....................................................... 30
2.9 Integrity Constraints ................................................................................. 32
2.10 Database Security ................................................................................... 33
2.11 Backup and Recovery .............................................................................. 33
2.12 Teori Khusus .......................................................................................... 34
2.12.1 Pengertian Pemasaran ............................................................. .... 34
2.12.2 Pengertian Manajemen Pemasaran ............................................ 35
2.12.3 Pengertian Periklanan ............................................................... 35
2.12.4 Microsoft Visual Studio ............................................................. 35
2.12.5 C# ............................................................................................ 37
BAB 3 ANALISIS SISTEM BERJALAN ............................................................... 39
3.1 Profile Perusahaan .................................................................................... 39
3.2 Struktur Organisasi ................................................................................... 40
3.3 Tugas dan Wewenang ................................................................................ 41
3.4 Analisis Sistem Berjalan ........................................................................... 44
3.5 Diagram Sistem Berjalan .......................................................................... 46
3.5.1 Activity Diagram Pemasaran ...................................................... 46
3.5.2 ActivityDiagram Penawaran ....................................................... 47
3.5.3 Acitivity Diagram Pengiklanan ................................................... 48
3.5.4 Activity Diagram Pembayaran Properti ...................................... 49
3.5.5 Activity Diagram Pembayaran Komisi ........................................ 50
3.6 Permasalahan Yang Dihadapi ................................................................... 51
3.7 Usulan Pemecahan Masalah ...................................................................... 52
3.8 Database Planing ...................................................................................... 53
3.8.1 Mission Statement ...................................................................... 53
3.8.2 Mission Objective ....................................................................... 53
3.8.3 System Boundaries ..................................................................... 55
3.9 Requirement Collection & Analysis .......................................................... 57
BAB 4 ANALISIS DAN PERANCANGAN BASIS DATA .................................... 60
4.1 Perancangan Basis Data ............................................................................ 60
4.1.1 Perancangan Basis Data Konseptual ............................................. 60
4.1.1.1 Mengidentifikasi Tipe Entitas ........................................... 60
4.1.1.2 Mengidentifikasi Tipe Relationship ................................... 62
4.1.1.3 Mengidentfikasi Asosiasi Atribut Dengan Entitas .............. 66
4.1.1.4 Menentukan domain atribut .............................................. 71
4.1.1.5 Menentukan Atribut Candidate dan Primay Key ................ 76
4.1.1.6 Memvalidasi Model Traksaksi User .................................. 79
4.1.2 Perancangan Basis Data Logikal ................................................... 81
4.1.2.1 Menghilangkan Fitur yang Tidak Seusai dengan Model
Relational .......................................................................... 81
4.1.2.2 Menurunkan Relasi Untuk Model Data Logical Local........ 85
4.1.2.3 Memvalidai Relasi Menggunakan Normalisasi ................. 105
4.1.2.4 Mendefinisikan Batasan Intergritas ................................... 135
4.1.3 Perancangan Basis Data Fisikal .................................................... 145
4.1.3.1 Mendesain Relasi Dasar ..................................................... 145
4.1.3.2 Menganalisis Transaksi ..................................................... 179
4.1.3.3 Mengecek Indeks .............................................................. 186
4.1.3.4 Mengestimasi Kebutuhan Ruang Penyimpanan ................. 187
4.1.3.5 Mendesain Mekanisme Keamanan .................................... 201
4.1.4 Desain Aplikasi ............................................................................ 204
4.1.4.1 Struktur Menu.................................................................... 204
4.1.4.2 State Transition Diagram (STD) ........................................ 205
4.1.4.3 Rancangan Layar .............................................................. 216
4.1.4.4 Implementasi ..................................................................... 238
BAB 5 SIMPULAN DAN SARAN .......................................................................... 241
5.1 Simpulan .................................................................................................. 241
5.2 Saran ........................................................................................................ 242
DAFTAR PUSTAKA ............................................................................................... 243
RIWAYAT HIDUP
LAMPIRAN
SURAT SURVEI
DAFTAR TABEL
Tabel 3.1 Analisis dan Pengumpulan Kebutuhan ........................................................ 59
Tabel 4.1 Tabel Identifikasi Tipe Entitas .................................................................... 62
Tabel 4.2 Tabel Tipe Relations .................................................................................. 64
Tabel 4.3 Tabel Atribut .............................................................................................. 71
Tabel 4.4 Tabel Domain Atribut ................................................................................. 76
Tabel 4.5 Atribut Candidate dan Primay Key ............................................................. 78
Tabel 4.6 Tabel Hasil Struktur Normalisasi ................................................................ 135
Tabel 4.7 Mendefinisikan Batasan Intergritas ............................................................. 143
Tabel 4.8 Matriks Silang Transaksi dan Relasi ........................................................... 185
Tabel 4.9 Mengestimasi Kebutuhan Ruang Penyimpanan .......................................... 198
Tabel 4.10 Estimasi Ukuran Entitas Per Bulan ........................................................... 199
Tabel 4.11 Estimasi Ukuran Entitas Per Tahun ........................................................... 200
Table 4.12 Mendesain Mekanisme Keamanan ............................................................ 204
Table 4.13 Jadwal Implementasi ................................................................................ 240
DAFTAR GAMBAR
Gambar 2.1 Strong and Weak Entity Types ................................................................ 27
Gambar 2.2 One-to-one relationship .......................................................................... 28
Gambar 2.3 One-to-Many relationship ....................................................................... 28
Gambar 2.4 Many-to-Many relationsip ...................................................................... 28
Gambar 2.5 Notasi Activity Diagram ......................................................................... 31
Gambar 3.1 Struktur Organisasi ................................................................................. 40
Gambar 3.2 Activity Diagram Pemasaran PT Reall Pro............................................... 46
Gambar 3.3 Activity Diagram Penawaran PT Reall Pro .............................................. 47
Gambar 3.4 Activity Diagram Pengiklanan PT Reall Pro ............................................ 48
Gambar 3.5 Activity Diagram Pembayaran Properti PT Reall Pro .............................. 49
Gambar 3.6 Activity Diagram Pembayaran Komisi PT Reall Pro ............................... 50
Gambar 3.7 System Boundaries PT Reall Pro ............................................................ 55
Gambar 4.1 Gambar Entity danTipe Relasi Data ........................................................ 65
Gambar 4.2 ERD Konseptual dengan Primary Key .................................................... 78
Gambar 4.3 ERD Dengan Pathways ........................................................................... 80
Gambar 4.4 Hubungan Many-to-Many Kriteria dan Pelanggan .................................. 81
Gambar 4.5 Hubungan Many-to-Many Peninjauan dan PemasaranProperti ................ 82
Gambar 4.6 Hubungan Many-to-Many Iklan dan PemasaranProperti ......................... 83
Gambar 4.7 Menghilangkan atribut multi-valued ....................................................... 84
Gambar 4.8 ERD Logikal .......................................................................................... 144
Gambar 4.9 Struktur Menu ......................................................................................... 205
Gambar 4.10 STD Login ............................................................................................ 206
Gambar 4.11 STD Menu ............................................................................................ 206
Gambar 4.12 STD Sub Menu File .............................................................................. 207
Gambar 4.13 STD Sub Menu Change Password ......................................................... 207
Gambar 4.14 STD Sub Menu Master ......................................................................... 208
Gambar 4.15 STD Sub Menu Pelanggan .................................................................... 208
Gambar 4.16 STD Sub Menu Pemilik ........................................................................ 208
Gambar 4.17 STD Sub Menu Karyawan .................................................................... 209
Gambar 4.18 STD Sub Menu Komitmen Pemasaran .................................................. 209
Gambar 4.19 STD Sub Menu Transaksi ..................................................................... 210
Gambar 4.20 STD Sub Menu Kriteria ......................................................................... 210
Gambar 4.21 STD Sub Menu Peninjauan ................................................................... 211
Gambar 4.22 STD Sub Menu Kesepakatan ................................................................ 211
Gambar 4.23 STD Sub Menu Kontrak ....................................................................... 212
Gambar 4.24 STD Sub Menu Iklan ............................................................................ 212
Gambar 4.25 STD Sub Menu Pemasaran Properti ...................................................... 213
Gambar 4.26 STD Sub Menu Pembayaran ................................................................. 213
Gambar 4.27 STD Sub Menu Pembayaran Properti .................................................... 214
Gambar 4.28 STD Sub Menu Pembayaran Iklan ........................................................ 214
Gambar 4.29 STD Sub Menu Pembayaran Komisi ..................................................... 215
Gambar 4.30 STD Sub Menu Laporan ....................................................................... 216
Gambar 4.31 Form Login KY00001 ........................................................................... 216
Gambar 4.32 Form Menu KY00001 ........................................................................... 217
Gambar 4.33 Form Login KY00002............................................................................ 218
Gambar 4.34 Form Menu KY00002 ........................................................................... 219
Gambar 4.35 Form Login KY00003............................................................................ 219
Gambar 4.36 Form Menu KY00003 ........................................................................... 220
Gambar 4.37 Form Login KY00004............................................................................ 220
Gambar 4.38 Form Menu KY00004 ........................................................................... 221
Gambar 4.39 Form Menu KY00005 ........................................................................... 222
Gambar 4.40 Form Menu KY00005 ........................................................................... 223
Gambar 4.41 Master Pelanggan .................................................................................. 224
Gambar 4.42 Master Pemilik ...................................................................................... 225
Gambar 4.43 Master Komitmen Pemasaran ............................................................... 226
Gambar 4.44 Master Karyawan .................................................................................. 227
Gambar 4.45 Form Kriteria ........................................................................................ 228
Gambar 4.46 Form Pemasaran Properti ...................................................................... 229
Gambar 4.47 Form Iklan ............................................................................................ 230
Gambar 4.48 Form Peninjauan ................................................................................... 231
Gambar 4.49 Form Kesepakatan ................................................................................ 232
Gambar 4.50 Form Kontrak ....................................................................................... 233
Gambar 4.51 Form Pembayaran Properti ................................................................... 234
Gambar 4.52 Form Pembayaraan Komisi ................................................................... 235
Gambar 4.53 Form Pembayaraan Iklan ...................................................................... 236
Gambar 4.54 Laporan Pembayaraan Properti .............................................................. 237
Gambar 4.55 Laporan Pembayaraan Komisi .............................................................. 237
Gambar 4.56 Laporan Pembayaraan Iklan .................................................................. 238
DAFTAR LAMPIRAN
Lampiran Print Screen Program .................................................................................. P1
Lampiran Wawancara ................................................................................................. L1
Lampiran Form ........................................................................................................... F1