Read the error message:
Cannot specify a column width on data type int.
Then look at your code, and find all the INT datatype columns:
CREATE TABLE Employee (
employee_id INTEGER PRIMARY KEY IDENTITY,
contractor_id INTEGER,
...
zip INTEGER(5),
department_id INTEGER,
building_assigned INTEGER
);
One of these is not like the others:
zip INTEGER(5),
As the error message says, you can't specify a width for integer values: they all take the same amount of space: 4 bytes.
Remove the
(5)
bit.
You should expect to get syntax errors every day, probably many times a day while you are coding - we all do regardless of how much experience we have! Sometimes, we misspell a variable, or a keyword; sometimes we forget to close a string or a code block. Sometimes the cat walks over your keyboard and types something really weird. Sometimes we just forget how many parameters a method call needs.
We all make mistakes.
And because we all do it, we all have to fix syntax errors - and it's a lot quicker to learn how and fix them yourself than to wait for someone else to fix them for you! So invest a little time in learning how to read error messages, and how to interpret your code as written in the light of what the compiler is telling you is wrong - it really is trying to be helpful!
So read this:
How to Write Code to Solve a Problem, A Beginner's Guide Part 2: Syntax Errors[
^] - it should help you next time you get a compilation error!