Examine the table shown below.

staff No. and branch No. are the composite key pair of the table. Deduce the following:

A. Identify the Normal Form of the Table? Mention step by step reasoning.

B. Describe and illustrate the process of normalizing the data shown in this table to third normal form (3NF)? Basically, design the tables with its attributes which will be formed as a result of the table converted to a 3NF. Make sure to include the Primary Keys and Foreign Keys for each of the resulting table after normalizing to 3NF
 

staffNo branchNo $4555 B002 $4555 B004 $4612 B002 $4612 B004 branchAddress City Center Plaza, Seattle, WA 98122 16-14th Avenue, Seattle, WA 98128 City Center Plaza, Seattle, WA 98122 16-14th Avenue, Seattle, WA 98128 name Ellen Layman Ellen Layman Dave Sinclair Dave Sinclair position hoursPer Week Assistant 16 Assistant 9 Assistant 14 Assistant 10