$20.$ Examine the table shown below: $($US$114049$ SO$2$ AC$1,2)14$ Marks

Employee No$.$ Branch No$.$ Branch

Address Employee

Name Position Hours per

week

KM$028$ DR$02$ Randburg

$2038$ Paul Senior

Lecturer $32$

KM$022$ DR$02$ Randburg

$2038$ Dale Lecturer $16$

KM$022$ DB$01$ Braamfontein

$2001$ Dale Lecturer $18$

KM$030$ DB$01$ Braamfontein

$2001$ John Lecturer $26$

KM$031$ DR$02$ Randburg

$2038$ Peter Senior

Lecturer $22$

a$)$ Why is the table above not in $2$NF$?$

b$)$ Describe the process of normalizing the data shown in the table above to third normal form $(3$NF$).$

c$)$ Identify the primary and foreign keys in your $3$NF relations.