QUESTION $4(20$ Marks$)$

Use the following EMPLOYEE table to answer related SQL questions below:

EMPLOYEE:

Empl$\_$ID EMP$\_$Name EMP$\_$Email EMP$\_$AGE EMP$\_$SALARY

X$0001$ Eva Evak@Maredi.co$.$za $44$ R$25000$

X$0002$ Lucy LucyB@Maredi.co$.$za $25$ R$12000$

X$0003$ Charlene CharleneJ@Maredi.co$.$za $24$ R$46000$

X$0004$ Danny DannyB@Maredi.co$.$za $35$ R$8000$

$4\mathrm{.}1$ Normalise the Employee table and provide a detailed explanation for each level of normalisation

implemented. $($Your solution should be supplied on a separate Word document named $$Question

$4\mathrm{.}1$ and submitted as part of your final submission$)$

$4\mathrm{.}2$ Formulate the SQL statement$($s$)$ required to rename one of the normalised tables to HR

Remuneration and substantiate your answer.