CREATE TABLE students
(student_id varchar(9) PRIMARY KEY,
first_name varchar(40) NOT NULL,
last_name varchar(40) NOT NULL,
gender char(1) NOT NULL,
date_of_birth datetime NOT NULL
)
It is best to make as many columns as possible NOT NULL, due in part to how NULL contents are handled by different database systems