Examine the data shown in Table $1,$ Where sNO is the staff number, fName and Iname are the first name and last name of the staff, and bno, bAddr, and phNo are tthe branch number, branch adress and phone numbert of the branch in that respective order.

a$)$ describe the typers of insertion anomaly, deletion anomoly, and update anomaly that mayoccur in this relation.

b$)$ Why is this table not in $1$NF $($first normal form$)?$

c$)$ Describe and illustrate the normalization process to make this relation to a set of $3$NF $($third normal form$)$ relations.

d$)$ Identify the priomary key and foriegn key$($s$)($if any$)$ in each of the $3$NF relations

Table $1$: StaffBranch Data$)$

SNo$)$ S$11,$ S$74,$ S$35,$ S$04$

fName$)$

for S$11,$ Matt, Matt

for S$74,$ Cody, Cody

for S$35,$ Mary

for S$04,$ Alan, Alan, Alan

Iname$)$

For S$11,$ Smith, Smith

For S$74,$ Snow, Snow

For S$35,$ Meyer

For S$04,$ Wheet, Wheet, Wheet

bNo$)$

For S$11,$ B$1$ and B$1$

For S$74,$ B$1$ and B$1$

for S$35,$ B$3$

For S$04,$ B$6,$ B$6$ and B$6$

BAddr$)$

for S$11,345$ Coral St$,$ Miami, FL$,$ and $345$ Coral St$,$ miami FL

for S$74,345$ Coral St$,$ Miami, FL$,$ and $345$ Coral St$,$ miami FL

For S$35,5011$ SW $20$th St$,$ Chicago IL

For S$04,2$ N $8$th Ave, New York, NY$,2$ N $8$th Ave, New York, NY$,2$ N $8$th Ave, New York, NY

phNO$)$

For S$11,305-111-2222$ and $305-111-2244$

For S$74,305-111-2222$ and $305-111-2244$

For S$35,206-555-5678$

For S$04.212-333-4567.212-333-7890,$ and $212-333-8787$