PERANCANGAN DATABASE BERBASIS PHPMYADMIN PADA SITUS PARIWISATA PENDUKUNG PROSES PEMBUATAN RENCANA PROGRAM TOURISM
Abstract
Situs Pariwisata Pembuatan Rencana Program Tourism is a web-based tourism sites that allow users to design their own travel plan. Database is needed to support tourism site. The data that is contained in database includes information of travel destination, hotels, travel routes, and transportation. The design of the database is divided into four phases, namely Requirements Collection and Analysis (Data collection and Analysis), Conceptual Database Design (Design Entity Relationship Diagram), Logical Database Design (Design Relational Database), physical database design (structure of the storage on database files) , After designed, the database were tested, using anomaly testing included insert anomaly, updates anomaly, and delete anomaly. After tested, the database there are some table, the table is table trip, table trip detail, table admin daerah, table jenis wisata, table wisata, table hotel, table transportasi, table gambar wisata, table wisata like, table member, dan table testimoni, where table trip can help tourist in making plans own tourism in detail and clear.