1. Which of the following relations is in Third normal form (3NF)?

a) R(ABCD) FD's: AD C ; D A ; A C ; ABC D

b) R(ABCD) FD's: A B ; B A ; A D ; D B

c) R(ABCD) FD's: AB C ; BCD A ; D A ; B C

d) R(ABCD) FD's: C B ; A B ; CD A ; BCD A

2. Let R(ABCD) be a relation with functional dependencies A B, C D, AD C, BC A Which of the following is a lossless-join decomposition of R into Boyce-Codd Normal Form (BCNF)?

a) {AB, BC, ACD}

b) {AB, AC, AD, CD}

c) {AC, AD, BC, CD}

d) {BC, CD, ABC}