CREATE TABLE Colleges ( college_id INT NOT NULL, college_code VARCHAR(20) NOT NULL, college_name VARCHAR(50) );