Question: 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 FD1: A --- {B,C} FD2: {D,E} ---A FD3: D --- G 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): 1c. Is the relation in 2NF? _____ 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: 1f. Are the relation(s) you provided in question 1e in 3NF? ______ 1g. Why or why not? 1h. Write the relation(s) in 3NF here, the FDs, and candidate keys for each relation. If already in 3NF, just write the relation(s): ?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
