Consider the following relational schema and the listed functional dependencies. R = (A, B, C, D)...

Transcribed Image Text:

Consider the following relational schema and the listed functional dependencies. R = (A, B, C, D) {BAC, C D} For each of the questions, first list the answer, and then give a brief reasoning. (a) List a candidate key. (b) Is the relation in 3NF? Why or why not? List one FD that violates it if it is not. (c) Decompose the relation into 3NF if it is not already in it. Consider the following relational schema and the listed functional dependencies. R = (A, B, C, D) {BAC, C D} For each of the questions, first list the answer, and then give a brief reasoning. (a) List a candidate key. (b) Is the relation in 3NF? Why or why not? List one FD that violates it if it is not. (c) Decompose the relation into 3NF if it is not already in it.