PLEASE EXPLAIN. TRYING TO LEARN!!

This assignment aims to analyze schemas to determine dependencies and convert them to BCNF. Remember to state any assumptions you make.

1. Suppose we have the Schema R(A, B, C, D, E) and the dependencies:

Dependency	Type
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	Type

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.