CREATE TABLE order (id INT PRIMARY KEY, product_name VARCHAR(1));

CREATE TABLE employee (emp_id INT PRIMARY KEY emp_name VARCHAR(5));

CREATE TABLE course (course_id CHAR(1) PRIMARY KEY, course_name VARCHAR(1) NOT NULL, credit TINYINT CHECK (credit BETWEEN 1 AND 5));

CREATE TABLE book (book_id INT, book_content TEXT(65535), publish_date DATE);