Given the following spreadsheet EMPLOYEE2 Emp ID Name Dept Name Salary Course_Title Date Completed 100 100...

1)

FD1:

Emp ID ---> Name, Dept Name, Salary, Course_Title, Date Completed;

FD2:

Name ---> Emp ID,Name Dept Name, Salary, Course_Title, Date Completed;

2)

EMP ID is the primary key of EMPLOYEE2

3) & 4)

A table is said to be not normalised because of the in consistence.

The given table is not normalised as with the below scenarios:

Update anomaly:

If we want to update the emp Susan Martin here we have to update same in two rows which is in consistent.

Insert anomaly:

When we want to insert an emp with out knowing the dept name of him then when dept row cant allow null values then we can not update the employee table.

Delete anomaly:

when an updation of department table modified there then must be change in here also.sometimes we delete some departments that may leads to deletion of employee record also.