B, CC, D>EТуреB > DE > Aa. Identify a correct primary key for the table using the relational schema notation (i.e., bold and underline) given thedependencies above.R(A, B, C, D, E)b. Identify...

Extracted text: This homework aims to analyze schemas to determine dependencies and convert them to BCNF. Remember to state any assmptions you make. 1. Suppose we have the Schema R(A, B, C, D, E) and the dependencies: Dependency A > B, C C, D>E Туре B > D E > A a. Identify a correct primary key for the table using the relational schema notation (i.e., bold and underline) given the dependencies above. R(A, B, C, D, E) b. Identify each dependency as functional, full, partial, transitive, or multivalued. Place your answer in the table above. c. Are there any other dependencies that can be determined based on the dependencies listed? List any you discover and label them with a type. Add more rows if needed. Dependency Туре d. Convert the table R into BCNF using the dependencies listed above. Write the solution using our relational schema notation from the lectures. You can label tables with numbers, for example, R1, R2, R3, etc.