Let
be a relation with functional dependency
a)
Compute
the candidate keys for
;
b)
Is
in 3NF
? If it is , justify your answer . If not , produce a
decomposition of
into 3NF .
c)
Is
in BCNF ?
If it is , justify your answer . If not , produce a
decomposition of
into BCNF .