Consider a relational schema team(name, city, owner), with functional dependencies .
The relation team is decomposed into two relations, t1(name, city) and t2(name, owner). Which of the following statement(s) is/are TRUE?
- (A)
The relation team is NOT in BCNF.
- (B)
The relations t1 and t2 are in BCNF.
- (C)
The decomposition constitutes a lossless join.
- (D)
The relation team is NOT in 3NF.
