CREATE TABLE student
(student_id NUMBER (8,0) constraint pk_student PRIMARY KEY,
salutation VARCHAR2(5),
first_name VARCHAR2(25),
last_name VARCHAR2(25) constraint nn_last_name NOT NULL,
street_address VARCHAR2(50),
zip VARCHAR2(5) CONSTRAINT fk_student_id_zip REFERENCES zipcode,
phone VARCHAR2(15),
employer VARCHAR2(50),
registration_date DATE CONSTRAINT nn_registration_date NOT NULL);