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