Examine the table shown below.

staffNo and branchNo are the composite primary key pair of the table. Deduce the following:

1. Identify the Normal Form of the Table? Mention step by step reasoning. [2 Marks]
2. 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 and keys which will be formed as a result of the table converted to a 3NF. Show the resulting tables below. You can use crows foot notation if needed to display the tables. Displaying data is not mandatory. Proper display of the resulting #NF normalised Table Schema is what is needed. [3 Mark]

staffNo branchNo branchAddress name position hoursPerWeek S4555 B002 City Center Plaza, Seattle, WA 98122 Ellen Layman Assistant 16 S4555 B004 16 - 14th Avenue, Seattle, WA 98128 Ellen Layman Assistant 9 S4612 B002 City Center Plaza, Seattle, WA 98122 Dave Sinclair Assistant 14 S4612 B004 16 - 14th Avenue, Seattle, WA 98128 Dave Sinclair Assistant 10