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

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

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!