Which of the following statements is true about a relational database model with respect to its normalization

Fantastic news! We've Found the answer you've been seeking!

Question:

Which of the following statements is true about a relational database model with respect to its normalization levels and referential integrity?

A) A table that is in 2NF cannot have a foreign key that references a primary key in another table that is not in at least 2NF.

B) A table that is in 3NF cannot have a foreign key that references a non-primary key attribute in another table that is not in at least 3NF.

C) A table that is in BCNF cannot have any transitive dependencies between its attributes and cannot have a foreign key that references a non-primary key attribute in another table that is not in at least BCNF.

D) A table that is in 4NF cannot have any multivalued dependencies and cannot have a foreign key that references a non-primary key attribute in another table that is not in at least 4NF.

E) All of the above statements are true.

Hint: The answer may require a thorough understanding of the normalization levels in relational databases, as well as the concept of referential integrity and their relationships with one another.