@Ms_Anne

-- CREATE TABLES -- CREATE TABLE Books ( book_id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255) NOT NULL, author VARCHAR(255) NOT NULL, genre VARCHAR(100), published_year YEAR, is_available BOOLEAN DEFAULT TRUE );