Student id Semester$-$no Branch name Specialization subjects

$4210001421$ tabouk Fatimah CS P$2$

$4210001422$ tayma Fatimah CS DS

$4210002421$ tabouk Fahad IT P$2$

$4210002422$ tabouk Fahad IT DS

$4210003421$ umluj sultan CS P$2$

$4210003422$ tabouk sultan CS DS

$($a$)$ Why is this table not in $2$NF$?$

$($c$)$Describe and illustrate the process of normalizing the data shown in this table to third nor form $(3$NF$).$

$($d$)$Identify the primary, $($alternate$)$ and foreign keys in your $3$NF relations.