Suppose you are given the table: EMPLOYEE DEPARTMENT (EmployeeNumber EmployeeLastName. EmployeeFirstName, Email, DepartmentName. BudgetCode) You want…

Suppose you are given the table: EMPLOYEE DEPARTMENT (EmployeeNumber EmployeeLastName. EmployeeFirstName, Email, DepartmentName. BudgetCode) You want to create an updated database and normalize the table into the two tables: DEPARTMENT (DepartmentName BudgetCode) EMPLOYEE (EmployeeNumber EmployeeLastName EmployeeFirstName, Email, DepartmentName) Show Sol statements for creating DEPARTMENT and EMPLOYEE.