Skip to Main Content
Learn SQL using MySQL in One Day and Learn It Well
book

Learn SQL using MySQL in One Day and Learn It Well

by Jamie Chan
April 2024
Intermediate to advanced content levelIntermediate to advanced
127 pages
2h 29m
English
Packt Publishing
Content preview from Learn SQL using MySQL in One Day and Learn It Well

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

MySQL Crash Course

MySQL Crash Course

Rick Silva

Publisher Resources

ISBN: 9781836205678Supplemental Content