Question: Functional Dependencies: Given the relation R(A, B, C, D, E, F, G) and the function dependencies FD1: E --> {C,G} FD2: {F,G} --> {A,B,E} FD3:

Functional Dependencies: Given the relation R(A, B, C, D, E, F, G) and the function dependencies

FD1: E --> {C,G}

FD2: {F,G} --> {A,B,E}

FD3: {B,C} --> D

Note: You will have to infer two additional FDs that are in F+ before transforming from 2NF to 3NF

Functional Dependencies: Given the relation R(A, B, C, D, E, F, G)

2a. Draw a the dependency diagram for this relation 2b. Identify all candidate keys using either the synthesis OR decomposition method. Show each step Candidate key(s): 2c. Is the relation in 2NF? 2d. Why or why not? 2e. Write the relation(s) in 2NF here, the FDs, and candidate keys for each relation. If already in 2NF, just write the relation 2t. Are the relation(s) you provided in question 2e in 3NF? 2g. Why or why not? 2h. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!