1. (2 pts) Are the following given relation schema with respect to the functional dependencies in 2NF? Explain why.

a) Schema (, , , , ) with functional dependencies , ,

b) Schema (, , , ) with functional dependencies , ,

2. (4 pts) Consider a relation schema (, , , , ) and a set of functional dependencies = { , , }.

a) Is in BCNF? If not, list all the functional dependencies in that violate BCNF

and explain why they are violations of BCNF.

b) Use the BCNF decomposition algorithm to decompose , as necessary, into a

collection of relation schemas that are in BCNF. Explain your steps.