$1\mathrm{.}2$ Consider the table below.

Convert the report into a set of BCNF tables. Describe each step in detail and show the relational

schema associated with each step.Convert the report into a set of BCNF tables. Describe each step in detail and show the relational schema associated with each step.

EMP$\_$NUM EMP$\_$FNAME EMP$\_$LNAME JOB$\_$DESC BENEFIT$\_1$ BENEFIT$\_2$ BENEFIT$\_3$ PROJ$\_$ID PROJECT

$200$ Luke Shaw Manager Company Car Medical Aid $13$th Cheque $445$ Sub Zero

$200$ Luke Shaw Manager Company Car Medical Aid $13$th Cheque $555$ Scorpion

$300$ Matthew Matthews Marketing Company Car $445$ Sub Zero

$500$ John Staples Marketing Company Car $445$ Sub Zero

$600$ Samuel Jackson Accountant $13$th Cheque $445$ Sub Zero

$600$ Samuel Jackson Accountant $13$th Cheque $555$ Scorpion