Find candidate key and normalize the relation into 2nf and 3nf
- Give a set of FDs for this relation.
- What are the candidate keys?
- Is R in 3NF? 2NF? Explain why?
- If R is not in 3NF, normalize it into 3NF relations.
find candidate keys
convert 2nf relation to 3nf relation
convert unnormalized into normalized relation