1 DAFTAR PUSTAKA 1. Sutabri, Tata Konsep Sistem Informasi. Yogyakarta : Andi, A.S, Rosa dan M. Shalahuddin Modul Pembelajaran Rekayasa Perangkat Lunak...
1. Sutabri, Tata. 2012. Konsep Sistem Informasi. Yogyakarta : Andi, 2012 2. A.S, Rosa dan M. Shalahuddin.2011. Modul Pembelajaran Rekayasa Perangkat Lunak (Terstruktur dan Berorientasi Objek). Modula. Bandung. 3. Sutabri, Tata. 2012.Analisa Sistem Informasi. Jogjakarta : Andi, 2012, p. 1 4. Connolly, Thomas and Begg, Carolyn. Database Systems: A Practical Approach to Design, Implementation, and Management, Fifth Edition. Pearson Education, Boston,2010. 5. Rizky, Soetam.2011. Konsep Dasar Rekayasa Perangkat Lunak. Jakarta: Prestasi Pustaka, 2011 6. Adhi Prasetio, 2012 . Buku Pintar Pemrograman Web. MediaKita, Jakarta 2012 7. Satzinger, Jackson, Burd 2009, p504 8. Adi Winarnno, Macromedia Dreamweaver. Jakarta (2012:10) 9. Kustianingsih, Yeni, Devi Rosa Aramisa, Pemrograman Basis Data Berbasis Web Menggunakan PHP & MYSQL. Yogyakarta : Graha Ilmu, 2011
SOURCE KODE
Database: `db_fantasia` Table structure for table `tbl_admin` CREATE TABLE IF NOT EXISTS `tbl_admin` ( `kd_admin` varchar(6) NOT NULL, `nama_admin` varchar(30) NOT NULL, `alamat` text NOT NULL, `no_telp` varchar(15) NOT NULL, `username` varchar(30) NOT NULL, `password` varchar(30) NOT NULL, `blokir` enum('Y','N') NOT NULL, PRIMARY KEY (`kd_admin`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Table structure for table `tbl_bukti_pembayaran` CREATE TABLE IF NOT EXISTS `tbl_bukti_pembayaran` ( `kd_upload` varchar(6) NOT NULL, `no_reservasi` varchar(6) NOT NULL, `gambar` varchar(100) NOT NULL, `tanggal_upload` date NOT NULL, PRIMARY KEY (`kd_upload`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Table structure for table `tbl_detail_reservasi` CREATE TABLE IF NOT EXISTS `tbl_detail_reservasi` ( `no_reservasi` varchar(6) NOT NULL, `kd_sarana` varchar(6) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Table structure `tbl_gedung`
for
table
CREATE TABLE IF NOT EXISTS `tbl_gedung` ( `kd_gedung` varchar(6) NOT NULL, `nama_gedung` varchar(30) NOT NULL, `keterangan` text NOT NULL, `harga` double NOT NULL, PRIMARY KEY (`kd_gedung`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Table structure for table `tbl_pelanggan`
CREATE TABLE IF NOT EXISTS `tbl_pelanggan` ( `kd_pelanggan` varchar(6) NOT NULL, `nama_pelanggan` varchar(50) NOT NULL, `alamat` varchar(100) NOT NULL, `no_telp` varchar(15) NOT NULL, `email` varchar(50) NOT NULL, `tanggal_daftar` date NOT NULL, PRIMARY KEY (`kd_pelanggan`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Table structure for table `tbl_pembayaran`
CREATE TABLE IF NOT EXISTS `tbl_pembayaran` ( `kd_pembayaran` varchar(6) NOT NULL, `no_reservasi` varchar(6) NOT NULL, `jumlah_pembayaran` double NOT NULL, `tanggal_pembayaran` date NOT NULL, `status_bayar` varchar(20) NOT NULL, PRIMARY KEY (`kd_pembayaran`)
INPUT RESERVASI CREATE TABLE IF NOT EXISTS `tbl_reservasi` ( `no_reservasi` varchar(6) NOT NULL, `kd_pelanggan` varchar(6) NOT NULL, `kd_gedung` varchar(6) NOT NULL, `tanggal_sewa` date NOT NULL, `jam_masuk` time NOT NULL, `jam_keluar` time NOT NULL, `harga_reservasi` double NOT NULL, `status_baca` varchar(2) NOT NULL, PRIMARY KEY (`no_reservasi`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Table structure for table `tbl_saran`
CREATE TABLE IF NOT EXISTS `tbl_saran` ( `kd_saran` varchar(5) NOT NULL, `nama` varchar(30) NOT NULL, `email` varchar(30) NOT NULL, `saran` varchar(120) NOT NULL, PRIMARY KEY (`kd_saran`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Table structure for table `tbl_sarana`
CREATE TABLE IF NOT EXISTS `tbl_sarana` ( `kd_sarana` varchar(6) NOT NULL, `nama_sarana` varchar(50) NOT NULL, `keterangan` text NOT NULL,