DAFTAR TABEL

Tabel 2.1 Perintah DDL ................................................................................... 28Tabel 2.2 Perintah DML .................................................................................. 29Tabel 3.1 Profil SMK Negeri 1 Rajadesa ........................................................ 47Tabel 3.2 Tabel Spesifikasi Peragkat Keras .................................................... 55Tabel 3.3 Tabel Spesifikasi Peragkat Lunak ................................................... 56Tabel 3.4 Spesifikasi Proses ............................................................................ 68Tabel 3.5 Kamus Data ..................................................................................... 78Tabel 3.6 tbl_absensi ....................................................................................... 89Tabel 3.7 tbl_agenda ........................................................................................ 89Tabel 3.8 tbl_album_galeri .............................................................................. 89Tabel 3.9 tbl_berita........................................................................................... 90Tabel 3.10 tbl_data........................................................................................... 90Tabel 3.11 tbl_download................................................................................. 90Tabel 3.12 tbl_galeri......................................................................................... 90Tabel 3.13 tbl_gambar...................................................................................... 91Tabel 3.14 tbl_jawabanpoll.............................................................................. 91Tabel 3.15 tbl_kelas.......................................................................................... 91Tabel 3.16 tbl_kepegawaian............................................................................. 91Tabel 3.17 tbl_menu......................................................................................... 92Tabel 3.20 tbl_pengumuman............................................................................ 92Tabel 3.21 tbl_pesan......................................................................................... 92Tabel 3.22 tbl_siswa......................................................................................... 92Tabel 3.23 tbl_soalpolling................................................................................ 93Tabel 4.1 Spesifikasi Perangkat Keras Pembangun ........................................ 102Tabel 4.2 Spesifikasi Perangkat Lunak Pembangun ........................................ 103Tabel 4.3 Rencana Pengujian Sistem ............................................................... 103Tabel 4.4 Pengujian Registrasi (data normal) .................................................. 104Tabel 4.5 Pengujian Registrasi (data salah) ..................................................... 105Tabel 4.6 Pengujian Login (data normal) ........................................................ 105Tabel 4.7 Pengujian Login (data salah) ........................................................... 106Tabel 4.8 Pengujian Tambah Data Berita (data normal) ................................. 107Tabel 4.9 Pengujian Ubah Data Berita (data normal) ...................................... 107Tabel 4.10 Pengujian Hapus Data Berita (data normal) .................................. 108Tabel 4.11 Pengujian Tambah Matapelajaran (data normal) ........................... 108Tabel 4.12 Pengujian Tambah Data Matapelajaran (data salah)...................... 109Tabel 4.13 Pengujian Ubah Data Matapelajaran (data normal) ....................... 109Tabel 4.14 Pengujian Ubah Data Matapelajaran (data salah) .......................... 109Tabel 4.15 Pengujian Tambah Data Materi (data normal) .............................. 110Tabel 4.16 Pengujian Ubah Data Materi (data normal) ................................... 110Tabel 4.17 Pengujian Hapus Data Materi (data normal) ................................. 111Tabel 4.18 Pengujian Download Data Materi (data normal) ........................... 111Tabel 4.19 Pengujian Tambah Data Ekstrakulikulerkul (data normal) ........... 111Tabel 4.20 Pengujian Ubah Data Ekstrakulikuler (data normal) ..................... 112Tabel 4.21 Pengujian Hapus Data Ekstrakulikuler (data normal) ................... 112Tabel 4.22 Pengujian Tambah Data Galeri (data normal) ............................... 113

vii

Tabel 4.23 Pengujian Ubah Data Galeri (data normal) ................................... 113Tabel 4.24 Pengujian Hapus Data Galeri (data normal) .................................. 114Tabel 4.25 Pengujian Tambah Data Guru (data normal) ................................. 114Tabel 4.26 Pengujian Tambah Data Guru (data salah) .................................... 114Tabel 4.27 Pengujian Ubah Data Guru (data normal) ..................................... 115Tabel 4.28 Pengujian Ubah Data Guru (data salah) ........................................ 115Tabel 4.29 Pengujian Tambah Data Siswa (data normal) ............................... 116Tabel 4.30 Pengujian Tambah Data Siswa (data salah) .................................. 117Tabel 4.31 Pengujian Ubah Data Siswa (data normal) .................................... 117Tabel 4.32 Pengujian Ubah Data Siswa (data salah)........................................ 118Tabel 4.38 Pengujian Tambah Data Nilai (data normal) ................................. 118Tabel 4.39 Pengujian Buat Data Pesan (data normal) ..................................... 119Tabel 4.40 Pengujian Lihat Data Pesan (data normal) .................................... 119Tabel 4.41 Pengujian Balas Data Pesan (data normal) .................................... 119

viii