Please answer the following questions:

What is the normal form of the table? Please answer by describing the functional dependency in the table.

Normalize the table to 3NF. You may use word document table, or figures generated from other software.

Identify the primary keys and foreign keys in the 3NF relational schema.

Please answer the following questions:

What is the normal form of the table? Please explain by describing the functional dependency in the table.

List all the logical functional dependency, such as name

Normalize this table to 3NF and mark the primary keys and foreign keys. You may use word document table, or figures generated from other software.

\begin{tabular}{|l|l|l|} \hline branchNo & branchAddress & telNos \\ \hline B001 & 8 Jefferson Way, Portland, OR 97201 & 5035553618,5035552727,5035556534 \\ B002 & City Center Plaza, Seattle, WA 98122 & 2065556756,2065558836 \\ B003 & 148 th Avenue, New York, NY 10012 & 2123713000 \\ B004 & 16- 14th Avenue, Seattle, WA 98128 & 2065553131,2065554112 \\ \hline \end{tabular}