IMPLEMENTASI E-MARKETING MENGGUNAKAN CRM

PADA ANGGUN HANTARAN DAN DEKORASI

BERBASIS WEB

SKRIPSI

Diajukan Untuk Memenuhi Salah Satu Syarat

Untuk Menyelesaikan Pendidikan Strata Satu (S-1)

Program Studi Sistem Informasi

Disusun Oleh :

SRI AYU NINGSIH

16.22.0134

Sekolah Tinggi Manajemen Informatika dan Komputer Royal

STMIK ROYAL

KISARAN 2020

viii

KATA PENGANTAR

Puji dan syukur penulis ucapkan kepada Allah SWT, Tuhan Yang Maha

Esa, atas rahmat dan karunia-Nya yang telah diberikan kepada penulis, sehingga

dapat menyelesaikan Laporan Skripsi ini. Laporan Skripsi ini penulis susun

sebagai salah satu syarat untuk menyelesaikan Program Strata-1 Sistem Informasi

pada Sekolah Tinggi Manajemen Informatika dan Komputer Royal.

Dalam penyusunan Skripsi ini penulis mengambil judul : “Implementasi

E-Marketing Menggunakan CRM Pada Anggun Hantaran Dan Dekorasi

Berbasis Web”.

Selama proses Laporan Skripsi ini penulis telah banyak mendapat bimbingan,

nasehat, doa dan materi dari berbagai pihak, maka penulis mengucapkan terima

kasih yang sebesar-besarnya kepada:

1. Bapak Anda Putra Lubis, M.MA., Selaku Ketua Yayasan Pendidikan Royal

Teladan Asahan.

2. Ibu Wan Mariatul Kifti, S.E., M.M, selaku Plt Ketua STMIK Royal.

3. Ibu Rizky Fauziah, M. IKom., M.Kom, selaku Wakil Ketua 1 STMIK Royal

Kisaran.

4. Bapak Sudarmin, M.Kom, Selaku Wakil Ketua III STMIK Royal Kisaran;

5. Bapak William Ramdhan, M.Kom., Selaku Ketua Program Studi Sistem

Informasi STMIK Royal Kisaran.

6. Bapak Jeperson Hutahaean, M.Kom., Selaku dosen pembimbing I, yang telah

banyak membimbing dalam proses penyelesaian skripsi.

ix

7. Ibu Uswatun Hasanah, S.Sy,M.H.I, Selaku dosen pembimbing II yang telah

banyak membimbing dalam penulisan dan memberikan banyak masukan

terhadap skripsi.

8. Ibu Ade Friska Andriani, Selaku Kepala Pimpinan Anggun Hantaran dan

Dekorasi.

9. Seluruh Dosen dan Staff Kependidikan STMIK Royal Kisaran yang telah

banyak membantu kelancaran perkuliahan penulis.

Dalam penyusunan Skripsi ini penulis menyadari sepenuhnya bahwa ini

masih jauh dari kesempurnaan, oleh karena itu segala kritik dan saran yang

bersifat membangun sangat penulis harapkan demi kesempurnaan Skripsi ini dan

untuk menambah ilmu pengetahuan penulis.

Akhir kata hanya kepada Allah SWT, Tuhan Yang Maha Esa tempat

menyerahkan diri, semoga Skripsi ini dapat diterima sebagai pedoman dan

berguna bagi yang membacanya.

Kisaran, Agustus 2020

Hormat Penulis,

Sri Ayu Ningsih

NIM : 16.22.0134

x

DAFTAR ISI

Halaman

HALAMAN JUDUL ..................................................................................... i

HALAMAN PERSETUJUAN..................................................................... ii

HALAMAN PENGESAHAN ..................................................................... iii

HALAMAN PERNYATAAN KEASLIAN ............................................... iv

HALAMAN PERSEMBAHAN................................................................... v

ABSTRAK ................................................................................................... vi

ABSTRACT ................................................................................................ vii

KATA PENGANTAR ............................................................................... viii

DAFTAR ISI ................................................................................................. x

DAFTAR GAMBAR .................................................................................. xv

DAFTAR TABEL.................................................................................... xviii

BAB I. PENDAHULUAN

1.1 Latar Belakang Masalah ..................................................................1

1.2 Identifikasi Masalah ...................................................................... 5

1.3 Batasan Masalah .............................................................................6

1.4 Rumusan Masalah .......................................................................... 7

1.5 Tujuan Penelitian ........................................................................... 7

1.6 Manfaat Penelitian .......................................................................... 8

xi

1.7 Sistematika Penulisan .................................................................... 9

BAB II TINJAUAN PUSTAKA

2.1 Dasar Teori ....................................................................................12

2.1.1 Implementasi .........................................................................12

2.1.2 E-Marketing ..........................................................................12

2.1.2.1 Pengertian E-Marketing ............................................ 12

2.1.2.2 Konsep E-Marketing .................................................14

2.1.2.3 Jenis-Jenis E-Marketing ..............................................14

2.1.3 CRM ......................................................................................15

2.1.3.1 Pentingnya CRM .........................................................16

2.1.3.2 Fase Customer Relationship Management ..................17

2.1.3.3 Kerangka Customer Relationship Management .........18

2.1.3.4 Manfaat Customer Relationship Management ............19

2.1.4 Pengertian Hantaran dan Dekorasi ......................................19

2.1.5 Website .................................................................................20

2.1.6 Alat Bantu Perancangan Sistem ...........................................20

2.1.6.1 Flowmap ......................................................................20

2.1.6.2 UML (Unifed Modelling Language) ...........................22

2.1.6.3 ERD (Entity Relationship Diagram) ...........................27

2.1.7 Perangkat Lunak Yang Digunakan ........................................28

2.1.7.1 Bahasa Pemrograman ................................................28

xii

2.2 Tinjauan Penelitian ........................................................................32

2.3 Kerangka Pemikiran ......................................................................34

2.4 Tinjauan Perusahaan/Instansi ........................................................35

2.4.1 Latar Belakang atau Sejarah Perusahaan ...........................35

2.4.2 Struktur Organisasi .............................................................35

2.5 Hipotesis .....................................................................................36

BAB III METODOLOGI PENELITIAN

3.1 Kerangka Penelitian ................................................................... 37

3.1.1 Uraian Kerangka Kerja....................................................... 38

3.2 Metode Penelitian ..................................................................... 41

3.3 Teknik Pengumpulan Data ........................................................ 41

3.4 Tempat dan Waktu Penelitian .................................................... 42

3.4.1 Tempat Penelitian ................................................................42

3.4.2 Waktu Penelitian .................................................................43

BAB IV ANALISIS DAN PERANCANGAN

4.1 Analisis Sistem .......................................................................... 44

4.1.1 Analisis Masalah .................................................................44

4.1.2 Analisis Kebutuhan Sistem .................................................46

4.1.2.1 Analisa Data ..............................................................46

4.1.2.2 Analisa Proses ...........................................................47

4.1.2.3 Analisa Pengguna ......................................................48

4.1.2.4 Analisa Perangkat Keras ...........................................48

xiii

4.1.2.5 Analisa Perangkat Lunak ..........................................49

4.1.2.6 Analisa Konfigurasi Sistem.......................................50

4.2 Analisa Biaya ..............................................................................50

4.3 Perancangan Sistem Secara Umum ............................................50

4.3.1 Aliran Sistem Informasi Lama yang Sedang Berjalan ........51

4.3.2 Aliran Sistem Informasi Baru yang Diusulkan ..................54

4.3.3 Unifed Modelling Language (UML) ...................................57

4.3.3.1 Usecase Diagram ......................................................57

4.3.3.2 Class Diagram ...........................................................63

4.3.3.3 Squence Diagram ......................................................64

4.3.3.4 Activity Diagram .......................................................67

4.3.3.5 Flowchart...................................................................70

4.4 Perancangan Basis Data .............................................................. 73

4.4.1 Entity Relationship Management (ERD) ..............................73

4.4.2 Struktur Data .........................................................................73

4.5 Perancangan Antar Muka (User Interface) ..................................77

4.5.1 Desain Global ........................................................................77

4.5.2 Desain Masukan .....................................................................78

4.5.3 Desain Keluaran ......................................................................86

BAB V IMPLEMENTASI DAN PEGUJIAN

5.1 Kebutuhan Sistem ...........................................................................87

5.2 Implementasi Sistem .......................................................................89

xiv

5.3 Pengujian Sistem .............................................................................90

5.4 Kelebihan dan Kelemahan Sistem ...................................................98

5.5 Hasil Pengujian ................................................................................99

BAB VI KESIMPULAN DAN SARAN

6.1 Kesimpulan ...................................................................................112

6.2 Saran ..............................................................................................113

DAFTAR PUSTAKA

DAFTAR LAMPIRAN

1.……Listing Program

2. ……Berita Acara Skripsi

3. ……Surat Riset

4. ……Surat Balasan Riset Dari Instansi

5. ……Surat Penunjukan Pembimbing Skripsi

6. ……Daftar Riwayat Hidup

xv

DAFTAR GAMBAR

Halaman

Gambar 2.1 Kerangka CRM ...........................................................................18

Gambar 2.2 Simbol PHP ................................................................................ 29

Gambar 2.3 Simbol MYSQL ..........................................................................30

Gambar 2.4 Simbol XAMPP ......................................................................... 31

Gambar 2.5 Kerangka Pemikiran ................................................................... 34

Gambar 2.6 Struktur Organisasi Anggun Hantaran dan Dekorasi ................. 35

Gambar 3.1 Kerangka Kerja .......................................................................... 38

Gambar 4.1 ASI Lama Anggun Hantaran dan Dekorasi.................................53

Gambar 4.2 ASI Baru Anggun Hantaran dan Dekorasi ..................................56

Gambar 4.3 Use Case Diagram .....................................................................57

Gambar 4.4 Class Diagram............................................................................ 63

Gambar 4.5 Diagram Squence Login ..............................................................64

Gambar 4.6 Diagram Squence Logout ............................................................65

Gambar 4.7 Diagram Squence Mengelolah Data User ...................................65

Gambar 4.8 Diagram Squence Mengelolah Data Produk ...............................66

Gambar 4.9 Diagram Squence Mengelolah Data Laporan .............................67

Gambar 4.10 Activity Diagram Login .............................................................68

Gambar 4.11 Activity Diagram Logout ...........................................................68

Gambar 4.12 Activity Diagram Data User ......................................................69

Gambar 4.13 Activity Diagram Mengelolah Data Produk .............................70

xvi

Gambar 4.14 Activity Diagram Data Laporan ................................................70

Gambar 4.15 Flowchart Login ........................................................................71

Gambar 4.16 Flowchart Hak Akses Admin ....................................................71

Gambar 4.17 Flowchart Penyewaan ...............................................................72

Gambar 4.18 ERD Penyewaan Hantaran dan Dekorasi ..................................73

Gambar 4.19 Struktur Data .............................................................................74

Gambar 4.20 Desain Global ............................................................................78

Gambar 4.21 Rancangan Halaman Home Admin ............................................79

Gambar 4.22 Rancangan Halaman Home Publik ............................................79

Gambar 4.23 Rancangan Halaman Login Admin ............................................80

Gambar 4.24 Rancangan Halaman Input User ...............................................80

Gambar 4.25 Rancangan Halaman Input Produk ............................................81

Gambar 4.26 Rancangan Halaman Login User...............................................81

Gambar 4.27 Rancangan Halaman Input Pesan Produk .................................82

Gambar 4.28 Rancangan Halaman Form Registrasi.......................................82

Gambar 4.29 Rancangan Halaman Konfirmasi Pemesanan ...........................83

Gambar 4.30 Rancangan Halaman List Pesanan.............................................83

Gambar 4.31 Rancangan Halaman Kirim Pesan/Pertanyaan ..........................84

Gambar 4.32 Rancangan Halaman Semua Produk .........................................84

Gambar 4.33 Rancangan Halaman Informasi Sewa .......................................84

Gambar 4.34 Rancangan Halaman Kontak .....................................................85

Gambar 4.35 Rancangan Halaman Manajemen User .....................................85

xvii

Gambar 4.36 Rancangan Halaman Komentar .................................................85

Gambar 4.37 Rancangan Halaman Laporan Pelanggan ..................................86

Gambar 4.38 Rancangan Halaman Laporan Pemesanan ................................86

Gambar 5.1 Halaman Home Admin ................................................................99

Gambar 5.2 Halaman Home Publik ..............................................................100

Gambar 5.3 Halaman Login Admin ...............................................................100

Gambar 5.4 Halaman Input User ..................................................................101

Gambar 5.5 Halaman Input Produk ..............................................................102

Gambar 5.6 Halaman Login User .................................................................102

Gambar 5.7 Halaman Input Pemesanan ........................................................103

Gambar 5.8 Halaman Form Registrasi..........................................................103

Gambar 5.9 Halaman Konfirmasi Pemesanan .............................................104

Gambar 5.10 Halaman List Pesananan..........................................................105

Gambar 5.11 Halaman Kirim Pesan/Pertanyaan ...........................................105

Gambar 5.12 Halaman Semua Produk ..........................................................106

Gambar 5.13 Halaman Informasi Sewa ........................................................107

Gambar 5.14 Halaman Kontak ......................................................................108

Gambar 5.15 Halaman Manajemen User ......................................................108

Gambar 5.16 Halaman Komentar .................................................................109

Gambar 5.17 Halaman Daftar Kode Voucher ...............................................109

Gambar 5.17 Halaman Laporan Pelanggan ..................................................110

Gambar 5.18 Halaman Laporan Pemesanan ................................................111

xviii

DAFTAR TABEL

Halaman

Tabel 2.1 Simbol-Simbol Flowmap ................................................................21

Tabel 2.2 Simbol-Simbol Usecase ................................................................. 23

Tabel 2.3 Simbol-Simbol Class Diagram .......................................................24

Tabel 2.4 Simbol-Simbol Activity Diagram................................................... 25

Tabel 2.5 Simbol-Simbol Squence Diagram ................................................. 26

Tabel 3.1 Waktu Penelitian ........................................................................... 43

Tabel 4.1 Data Masukan .................................................................................47

Tabel 4.2 Data Keluaran ................................................................................47

Tabel 4.3 Analisis Perangkat Keras ................................................................49

Tabel 4..4 Analisis Perangkat Lunak ..............................................................49

Tabel 4.5 Analisis Biaya .................................................................................50

Tabel 4.6 Deskripsi Use Case Login ..............................................................58

Tabel 4.7 Deskripsi Use Case Logout .............................................................58

Tabel 4.8 Deskripsi Use Case Mengelolah Data User ....................................59

Tabel 4.9 Deskripsi Use Case Mengelolah Paket Hantaran dan Dekorasi .....60

Tabel 4.10 Deskripsi Use Case Mengelolah Data Laporan ............................62

Tabel 4.11 Tabel Akun ...................................................................................75

Tabel 4.12 Tabel Pelanggan ............................................................................75

Tabel 4.13 Tabel Pesan ...................................................................................75

Tabel 4.14 Tabel Pesanan ...............................................................................76

xix

Tabel 4.15 Tabel Rating ..................................................................................76

Tabel 4.16 Tabel Vooucher .............................................................................76

Tabel 4.15 Tabel Wedding .............................................................................77

Tabel 5.1 Implementasi Perangkat Keras........................................................87

Tabel 5.2 Implementasi Perangkat Lunak .......................................................88

Tabel 5.3 Pengujian Login .............................................................................90

Tabel 5.4 Pengujian Input Produk ...................................................................91

Tabel 5.5 Pengujian Edit Produk ....................................................................92

Tabel 5.6 Pengujian Cari Data Produk ............................................................92

Tabel 5.7 Pengujian Hapus Data Produk ........................................................93

Tabel 5.8 Pengujian Input Data Pelanggan .....................................................94

Tabel 5.9 Pengujian Edit Data Pelanggan .......................................................95

Tabel 5.10 Pengujian Cari Data Pelanggan.....................................................95

Tabel 5.11 Pengujian Hapus Data Pelanggan .................................................96

Tabel 5.12 Pengujian Cari Data Pesanan ........................................................97

Tabel 5.13 Pengujian Cetak Laporan ..............................................................98

DAFTAR PUSTAKA

Abdul rahmanyahoocom, E., Supaidi, A., & Ibrahim, A. (2018).

http://journal.unj.ac.id/unj/index.php/jrmsi 72, 9(1), 72–78.

Agustin, W., Adlan, R., & Efendi, Y. (2018). Pembangunan Website E-CRM

(Electronics Customer Relationship Management) pada House Of Smith

Pekanbaru. It Journal Research and Development, 3(2), 9–18.

https://doi.org/10.25299/itjrd.2019.vol3(2).1893

Ahmad, Z. (2018). rancang bangun portal pemasaran produk hasil pertanian dan

perkebunan di kelurahan malindo berbasis web.(2), 1–83

https://doi.org/10.20961/ge.v4i1.19180

Fitriana, A. (2019). Pengaruh E-Marketing dan E-CRM terhadap Loyalitas

Nasabah Menggunakan Internet Banking Bank Syariah Mandiri. Creative

Information Technology Journal, 4(4), 306.

https://doi.org/10.24076/citec.2017v4i4.124

Fridayanthie, Eka Wida, andTias M. (2016). Rancang Bangun Sistem Informasi

Permintaan Atk Berbasis Intranet (Studi Kasus: Kejaksaan Negeri

Rangkasbitung), IV(June), 126–138

Heriyanto, Y. (2008). Perancangan Sistem Informasi Rental Mobil Berbasis Web

Pada Pt.Apm Rent Car. Journal of Chemical Information and Modeling,

53(9), 287. https://doi.org/10.1017/CBO9781107415324.004

Hutahaean, J., & Yesputra, R. (2017). Sistem Informasi Pengadaan Pupuk Dan

Fungisida Berbasis Web (Studi Kasus: PT. Hutahaean, Pekanbaru-Riau).

Riau Journal Of Computer Science, 4(1), 55–68.

Jeperson Hutahaean, Z. A. (2018). Sistem Informasi Laporan Penilaian Barang

Milik Negara Berbasis Web (Studi Kasus : KPKNL KISARAN). Riau

Journal Of Computer Science (RjoCS), 4(2), 19–30.

Kurniawan, I., Wahyuddin, A., & Nurhayati, Y. (2012). Implementasi Customer

Relationship Management. Nuansa Informatika : Jurnal Ilmu Komputer,

10(2).

Malau, Harman (2018). Manajemen Pemasaran. Bandung: CV Alfabeta.

Malawat, M. S., Harwini, D., Mulyani, N., & Hutahaean, J. (2018). E - Commerce

Penjualan Menggunakan Metode Customer Relationship Management ( Crm

). Jurnal Manik Penusa, 2(2), 98–104.

Muzdalifah, L. (2018). E-Marketing Sebagai Strategi Pemasaran Untuk

Meningkatkan Penjualan Di Rumah Penganti Sidoarjo. Wiga : Jurnal

Penelitian Ilmu Ekonomi, 7(2), 125–131.

Nana Herdiana, A (2018). Manajemen Strategi Pemasaran. Bandung:

CV Pustaka Setia.

Okta, Nugraha Faisal, Wina Witanti, and A. K. (2017). Fakultas Teknik –

Universitas Muria Kudus 153. Prosiding SNATIF Ke-4 Tahun 2017, 153–

160. https://doi.org/10.2298/PAN0903301G

Prasetya, A. (2017). Implementasi Customer Relationship Management (Crm)

Pada Sistem Informasi Wedding Organizer. Progress in Physical Geography,

14(7), 450. https://doi.org/10.1177/0309133309346882

Pratama , I Putu Agus Eka (2019). Customer Relationship Management (CRM),

Bandung: Informatika.

Pratiwi, M. (2019). Analisa Strategi E-Marketing Pada E-Commerce Hijup.

Carbohydrate Polymers, 6(1), 5–10.

https://doi.org/10.1109/MTAS.2004.1371634.

Susanti, N. (2018). Perancangan E-Marketing Umkm Kerajinan Tas. Simetris:

Jurnal Teknik Mesin, Elektro Dan Ilmu Komputer, 9(1), 717–722.

https://doi.org/10.24176/simet.v9i1.2042

Taryono, johni s pasaribu and ardi. (2018). Implementasi Strategi E-Marketing

Berbasis Web ( Studi Kasus : Perusahaan Katering Dan Dekorasi, 2(1).

Wahirayasa, C. G., & Kusuma, A. A. G. A. A. (2018). Peran E-Marketing Dalam

Memediasi Pengaruh Orientasi Pasar Terhadap Kinerja Bisnis. E-Jurnal

Manajemen Universitas Udayana, 7(6), 3291.

https://doi.org/10.24843/EJMUNUD.2018.v07.i06.p16