Q4MCQ1 mark, −0.33In a relational data model, which one of the following statements is TRUE?\text{TRUE}?TRUE?(A)A relation with only two attributes is always in BCNF.\text{BCNF}.BCNF.(B)If all attributes of a relation are prime attributes, then the relation is in BCNF.\text{BCNF}.BCNF.(C)Every relation has at least one non-prime attribute.(D)BCNF\text{BCNF}BCNF decompositions preserve functional dependencies.Sign in to save attempts.Show answer← PreviousNext →SolutionsDiscussionLoading…Sign in with Google