CREATE TABLE students ( id INT(11) NOT NULL AUTO_INCREMENT, first_name VARCHAR(50) NOT NULL, last_name VARCHAR(50) NOT NULL, gender ENUM(‘male’, ‘female’) NOT NULL, date_of_birth DATE NOT NULL, email VARCHAR(100) NOT NULL, phone_number VARCHAR(20) NOT NULL, address VARCHAR(200) NOT NULL, city VARCHAR(50) NOT NULL, state VARCHAR(50) NOT NULL, country VARCHAR(50) NOT NULL, zip_code VARCHAR(20) NOT NULL, enrollment_date DATE NOT NULL, graduation_date DATE, program_id INT(11) NOT NULL, PRIMARY KEY (id), FOREIGN KEY (program_id) REFERENCES programs(id) );
