2. Consider the following relation: Bank ID Branch ID Branch Address Branch City Branch State Branch ZipCode Bank City BranchManagerID Application Application Amount Requested AppStatus Date Name Consider this to be all one relation. I've put it on two lines to make it all fit. 1. Identify the primary key(s). Are there any other candidate keys (fields that could be considered in choosing a primary key?) Identify the partial functional and transitive dependencies. You can either show these with arrows on the diagram or write them out. 2. 3. Convert the relation into a set of third normal form relations 4. Extra Credit (If you have time) Convert the relations to an ERD