CREATE TABLE org (org_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(55)); CREATE TABLE person (person_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, org_id INT, first_name VARCHAR(55) NOT NULL, last_name VARCHAR(55) NOT NULL, class ENUM('freshman','sophomore','junior','graduate','senior','other') NOT NULL DEFAULT 'other', birth_date VARCHAR(20) NOT NULL, email VARCHAR(75), date_modified TIMESTAMP(14)); CREATE TABLE quiz (quiz_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, person_id INT NOT NULL DEFAULT 0, module TINYINT NOT NULL DEFAULT 0, answers TEXT, comments VARCHAR(255), date_created VARCHAR(55), date_modified TIMESTAMP(14));