Question: please correct any syntax errors using sql CREATE TABLE EMPLOYEE 2) (SSN Number CHAR(9) NOT NULL, First Name VARCHAR(15) NOT NULL, Mid Name CHAR, N

please correct any syntax errors using sql
please correct any syntax errors using sql CREATE TABLE EMPLOYEE 2) (SSN

CREATE TABLE EMPLOYEE 2) (SSN Number CHAR(9) NOT NULL, First Name VARCHAR(15) NOT NULL, Mid Name CHAR, N Last Name VARCHAR(15) NOT NULL, SRYD Birthday DATE, CGN) Address VARCHAR(50) 8) Gender CHAR CHECK (Gender IN (**', 'F', 'm', 'f')). 9 Salary MONEY INTEGER DEFAULT 80000", 10> Supervisor SSN CHAR(9), 11) Department Number INT 12) CONSTRAINT EMPLOYEE PK PRIMARY KEY (SSN Number), 13) CONSTRAINT EMPLOYEE_FK FOREIGN KEY (Supervisor SSN)); Msg 102, Level 15, State 1, Server HRZN-VDT-0061\LOCALOBN488CDB72, Line 2 Incorrect syntax near *CHAR. 1480

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!