2NF: is super key, or if is a non-prime attribute, then is also a non-keyon-prime attributes. 3NF: is a super key or is a prime attribute BCNF: is a super key or is a trivial dependency. Note: To identify the highest normal form, please use the table format. Please also show the steps you have completed to decompose the tables. II) The given relation is R2(ABCDE). The given dependencies are ABBECD a. Can you identify the candidate keys of the given relation R2 ? (AC) b. Is the relation in 2NF? If not, can you decompose the table in 2NF? (Mark 20) c. Are the decomposed relations in 3NF ? If not, can you decompose the decomposed tables in 3 NF? (Mark 20)