Question: please answer as soon as possible!!!!!! If you had to create a new table in your database called EMPLOYEE and load data into it using

please answer as soon as possible!!!!!!
If you had to create a new table in your database called EMPLOYEE and load data into it using SQL commands below. CREATE TABLE EMPLOYEE ( EMP_ID INTEGER PRIMARY KEY, EMP_FNAME VARCHAR(200) NOT NULL, EMP_LNAME VARCHAR(200) NOT NULL, EMP_CITY VARCHAR(500) NULL, EMP_STATE VARCHAR(20) NULL ) 1. INSERT INTO EMPLOYEE VALUE (1, 'Kevin', 'Lailnay, NULL, 'PA' 2. INSERT INTO EMPLOYEE VALUE (2, 'Sarita, 'Kawn, 'Princeton, NJ) 3. INSERT INTO EMPLOYEE VALUE (2, 'Gloria, 'Pitts, 'Allentown, 'PA') 4. INSERT INTO EMPLOYEE VALUE (3, Jose, 'Hawillian, 'Buffalo, 'NY') 5. INSERT INTO EMPLOYEE VALUE (NULL, Jose, 'Hawillian, 'Brooklyn, 'NY) Out of the 5 INSERT commands above, which SQL INSERT commands will violate Entity Integrity? Copy and Paste those SQL commands in the answer below. Explain in detail why the Entity integrity is violated for each of those rows
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
