Problem $4$:

a$)$ What are the potential issues with the flat database structure?

b$)$ Transform the following flat database table into a normalized relational database structure:

$\backslash$table$[[\backslash$table$[[$Employee$],[$ID$]],\backslash$table$[[$Employee$],[$Name$]],$Department,$\backslash$table$[[$Department$],[$Head$]],\backslash$table$[[$Project$],[$ID$]],$Project Name,$\backslash$table$[[$Project$],[$Budget$]]],[101,$Alice,HR$,$Mr$.$ Green,P$001,$Payroll System,$50000],[102,$Bob,IT$,$Mr$.$ Blue,P$002,\backslash$table$[[$Network$],[$Upgrade$]],150000],[103,$Charlie,IT$,$Mr$.$ Blue,P$002,\backslash$table$[[$Network$],[$Upgrade$]],150000],[104,$David,Finance,Mrs$.$ White,P$003,$Tax Software,$200000],[105,$Eve,Finance,Mrs$.$ White,P$004,$Audit System,$120000],[101,$Alice,HR$,$Mr$.$ Green,P$005,$Recruitment,Tool$]]$