CREATE TABLE employee
(
     employeenumber INT(2) NOT NULL,
     firstname      CHAR(30) NOT NULL,
     lastname       CHAR(100) NOT NULL,
     department     CHAR(35) NOT NULL,
     position       CHAR(35) NOT NULL,
     supervisor     INT(2) NOT NULL,
     officephone    CHAR(12) NOT NULL,
     emailaddress   CHAR(100) NOT NULL

);