You have two tables: CREATE TABLE department ( Department_ID int unsigned NOT NULL auto_increment PRIMARY KEY, Department _Name varchar(12) NOT NULL ) ENGINE=InnoDB CREATE TABLE employee (…

You have two tables:

CREATE TABLE department ( Department_ID int unsigned NOT NULL auto_increment PRIMARY KEY, Department _Name varchar(12) NOT NULL ) ENGINE=InnoDB CREATE TABLE employee ( Employee_Number int unsigned NOT NULL PRIMARY KEY, Employee_Name varchar(10) NOT NULL, Department_ID int unsigned DEFAULT NULL, FOREIGN KEY (Department ID) REFERENCES Department (Department_ID) ON UPDATE SET NULL ON DELETE CASCADE ) ENGINE= InnoDB The tables have the data:

Department You execute the statement:

REPLACE INTO department (Department_ID, Department_Name) VALUES (1, `Admin'); What data is in the employee table after the statement?