Appendix C: Suggested Solution for Project
sportsDB.sql
CREATE DATABASE sports_booking;
USE sports_booking;
-- ********************* CREATE TABLES ********************************
CREATE TABLE members (
id VARCHAR(255) PRIMARY KEY,
password VARCHAR(255) NOT NULL,
email VARCHAR(255) NOT NULL,
member_since TIMESTAMP DEFAULT NOW() NOT NULL,
payment_due DECIMAL(6, 2) NOT NULL DEFAULT 0
);
CREATE TABLE pending_terminations (
id VARCHAR(255) PRIMARY KEY,
email VARCHAR(255) NOT NULL,
request_date TIMESTAMP DEFAULT NOW() NOT NULL,
payment_due DECIMAL(6, 2) NOT NULL DEFAULT 0
);
CREATE TABLE rooms (
id VARCHAR(255) PRIMARY KEY,
room_type VARCHAR(255) NOT NULL,
price DECIMAL(6, 2) NOT NULL
);
CREATE TABLE bookings (
id INT AUTO_INCREMENT PRIMARY KEY,
room_id VARCHAR(255) NOT NULL,
booked_date DATE NOT NULL,
booked_time TIME NOT NULL,
member_id VARCHAR(255) NOT NULL,
datetime_of_booking TIMESTAMP DEFAULT NOW...