Author Question: A relation is in Boyce-Codd normal form (BCNF) if and only if it is in 3NF and ________. A) all ... (Read 86 times)

dalyningkenk · **on:** Jul 7, 2018

A relation is in Boyce-Codd normal form (BCNF) if and only if it is in 3NF and ________.

A) all non-key attributes are determined by the entire primary key
B) there are no non-key attributes determined by another non-key attribute
C) every attribute is a candidate key
D) every determinant is a candidate key

Question 2

When one SQL query is embedded in another SQL query, this is referred to as a ________.

A) subquery
B) join
C) WHERE Query
D) subset query