QUESTION $4$

$(20$ Marks$)$

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

EMPLOYEE:

$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.