DATABASE FP
CREATE DATABASE Alfajr; USE Alfajr; CREATE TABLE users ( user_id INT NOT NULL AUTO_INCREMENT, nama_lengkap VARCHAR(100), no_hp VARCHAR(100), email VARCHAR(100), password VARCHAR(100), alamat VARCHAR(100), PRIMARY KEY (user_id) ); CREATE TABLE travel ( travel_id INT NOT NULL AUTO_INCREMENT, car_name VARCHAR(100), type_car ENUM('sedan', 'SUV', 'minivan', 'coupe', 'wagon'), -- Contoh nilai ENUM untuk type_car PRIMARY KEY (travel_id) ); CREATE TABLE review ( review_id INT NOT NULL AUTO_INCREMENT, user_id INT, travel_id INT, rating ENUM('1', '2', '3', '4', '5'), review TEXT, PRIMARY KEY (review_id), FOREIGN KEY (user_id) REFERENCES users(user_id), FOREIGN KEY (travel_id) REFERENCES travel(travel_id) ); CREATE TABLE reservati...