DROP TABLE IF EXISTS book;
CREATE TABLE book (
book_id INT NOT NULL AUTO_INCREMENT,
title TEXT,
author_id INT,
publisher_id INT,
PRIMARY KEY( Book_id ) );

DROP TABLE IF EXISTS author;
CREATE TABLE author (
author_id INT NOT NULL AUTO_INCREMENT,
first TEXT,
last TEXT,
PRIMARY KEY( Author_id ) );

DROP TABLE IF EXISTS publisher;
CREATE TABLE publisher (
publisher_id INT NOT NULL AUTO_INCREMENT,
name TEXT,
PRIMARY KEY( Publisher_id ) );