Functional Dpendencies

1. Given the relation R(A, B, C, D, E, G) and the function dependencies

FD1: A --> {B,C}

FD2: {D,E} --> A

FD3: D --> G

1. Given the relation R(A, B, C, D, E, G) and the function dependencies FD3: DG 1a. Draw a the dependency diagram for this relation 1b. Identify all candidate keys using either the synthesis OR decomposition method. Show each step Candidate key(s): DE 1c. Is the relation in 2NF?_No__ 1d. Why or why not? 1e. Write the relation(s) in 2NF here, the FDs, and candidate keys for each relation. If already in 2NF, just write the relation