The following relation(table) contains data about employees in an institution of higher learning. Employees can have more than one designation or title and can belong to 1 or more departments as shown in this relation. A composite key (Designation, Emp_ No, Dept No) uniquely identifies each row. Designation Emp_Name Technician Mdu Technician Moodley Receptionist Zintle Marketer Mbuso Lecturer Lecturer Lecturer Lecturer Dept Name MICT MICT Admin Marketing BEMS MICT Moodley MICT Mdu MBA The following are the attributes of this relation: Emp_Name: Name of employee, Emp_Add: Address of employee, Emp_No: Employee number, Dept_No: Department number, Dept_Name: Name of department, and Dept Location: location of the department. 4.1 Identify the update and deletion anomalies in the above relation. (5) 4.2 Normalise the above relation up to Boyce Codd Normal Form (BCNF). For each of the normal forms, state the conditions and explain if the relation(s) meet the requirements for that normal form. Write down all the relations, indicating primary keys for each of them. (20) Hint: the following functional dependencies exist: Emp No Emp_Name, Emp_Add Dept No Dept Name, Dept_Location Dept Name Dept_Location Emp_Add 123 1st Road 555 2nd ST 222 Aim ST 321 Brad ST 123 1st Road 123 1st Road 555 2nd ST 123 1st Road Pillay Mdu Emp_No 001 005 003 002 009 001 005 001 Dept_No Dept Location Area 1 Area 1 Area 2 Area 3 Area 4 Area 1 Area 1 Area 5 100 100 200 600 500 100 100 800