A company wants to create a database to store records of its employees. Foreach employee, the company records their personal details, the location of thebranch where they work and their qualifications. Below is a sample of data fortwo employees.

i$)$Identify the repeating group of attributes from the above relations.

$($ii$)$Create new relations by transforming the unnormalised table in Figure $1$into tables that are in $1$st Normal Form.

$($ii$)$ Create new relations by identifying any partial dependencies and

transform into tables that are in $2$nd Normal Form.

$($iv$)$Create new relations by identifying any transitive dependencies andtransform into tables that are in $3$rd Normal Form.